jTDS SQL Server
5 posts
• Page 1 of 1
jTDS SQL Server
...
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.
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.
- Garantisoft
- Posts: 16
- Joined: Wed Aug 17, 2011 3:26 pm
Re: jTDS SQL Server
We recommend the usage of DBCredentials and/or DataSourceHandler, because JVx uses jtds for MSSql.
It is also possible to use the MSSQLDBAccess direct:
Please post your StackTrace and SQLServer version.
It is also possible to use the MSSQLDBAccess direct:
- Code: Select all
MSSQLDBAccess dba = new MSSQLDBAccess();
Please post your StackTrace and SQLServer version.
-
Support@SIB - Posts: 353
- Joined: Mon Sep 28, 2009 1:56 pm
Re: jTDS SQL Server
Sory, I can't post StackTrace. SQLServer version 2000.
- Garantisoft
- Posts: 16
- Joined: Wed Aug 17, 2011 3:26 pm
Re: jTDS SQL Server
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...?
Do you get the error during open() or when accessing data or...?
-
Support@SIB - Posts: 353
- Joined: Mon Sep 28, 2009 1:56 pm
Re: jTDS SQL Server
This is a problem with metadata detection in MSSql 2000, because schema handling is different.
Details are available in the Support System.
Details are available in the Support System.
-
Development@SIB - Posts: 325
- Joined: Mon Sep 28, 2009 1:54 pm
5 posts
• Page 1 of 1