Forum @ SIB Visions

...
Class.forName("net.sourceforge.jtds.jdbc.Driver");

Connection connection = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/testdb","sa", "");

dba = DBAccess.getDBAccess(connection);
dba.open();
put("dBAccess", dba);
...

Using jTDS 1.2.5 to the SQL Server connection,
"Invalid object name 'sys.database_principals'." I get the error.
What can I be missing.

We recommend the usage of DBCredentials and/or DataSourceHandler, because JVx uses jtds for MSSql.

It is also possible to use the MSSQLDBAccess direct:

Code: Select all

MSSQLDBAccess dba = new MSSQLDBAccess();


Please post your StackTrace and SQLServer version.

Sory, I can't post StackTrace. SQLServer version 2000.

Without Stack Trace we have no chance to find the error cause/position. If you don't want to show your classes, remove your classes from the stack trace. We only need JVx information!

Do you get the error during open() or when accessing data or...?

This is a problem with metadata detection in MSSql 2000, because schema handling is different.

Details are available in the Support System.