Sql Server 2000 DataStore error

Hi.

I’m using Studio 11 and need to make a connection to a BB.DD with SQL Server.
I create a new connection, configure it and the connection test is correct.

imagen

Generating the model, I get an empty list of tables
imagen

and the next error when I refresh
imagen

> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)
2019-07-18 15:11:06,217 [ 941313] WARN - ndling.DefaultExceptionHandler - Studio error:
java.sql.SQLException: No se puede abrir la base de datos solicitada en el inicio de sesión ‘p7’. Error de inicio de sesión.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:371)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at com.haulmont.studio.backend.ed.ddl.DbManager.openConnection(SourceFile:267)
at com.haulmont.studio.backend.ed.ddl.DbManager.getConnection(SourceFile:121)
at com.haulmont.studio.backend.dbfirst.DbMappingManager.getEntitiesWithTableAndDependent(SourceFile:107)
at com.haulmont.studio.intellij.ui.modelgeneration.selecttables.TablesChooserStep.lambda$refreshData$5(SourceFile:178)
at com.intellij.openapi.progress.impl.CoreProgressManager$1.run(CoreProgressManager.java:220)
at com.intellij.openapi.progress.impl.CoreProgressManager$TaskRunnable.run(CoreProgressManager.java:731)
at com.intellij.openapi.progress.impl.CoreProgressManager$5.run(CoreProgressManager.java:442)
at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcess$2(CoreProgressManager.java:164)
at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:586)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:532)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:86)
at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:151)
at com.intellij.openapi.application.impl.ApplicationImpl.lambda$null$10(ApplicationImpl.java:594)
at com.intellij.openapi.application.impl.ApplicationImpl$1.run(ApplicationImpl.java:311)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Revisiting the DataStore definition, i can see a misconfiguration.
imagen

The DataBase Type is changed and no connection at all

Any help is appreciated

Thanks

Hi, @jmserrano4145. Thanks for the bug report. The issue https://youtrack.cuba-platform.com/issue/STUDIO-6398 will be fixed in a next release.

Workaround: Set cuba.dbmsVersion_p7=2005 property in app.properties file