jTDS Driver is giving error when connecting to SQL 2000

[Ravi Tiruvaipati]

Hi,
I am trying to use jTDS driver 0.9rc1 to connect to SQL 2000 and I am keep getting following error...
java.sql.SQLException: Cannot open database requested in login 'testdb'. Login fails.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:366)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2048)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:1648)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:462)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:274)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:48)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:112)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at SQLTest.main(SQLTest.java:15)

for the code

import java.sql.*;
import java.util.*;
 
public class SQLTest{
public static void main(String[] args){
int ret;
Connection con=null;
Statement stmt = null;
ResultSet rs = null;
boolean exist=false;

try{
Class.forName("net.sourceforge.jtds.jdbc.Driver");
String url = "jdbc:jtds:sqlserver://sd1-baanbis/testdb;TDS=7.0;user=test;password=test";
//con = DriverManager.getConnection(url,"test","test");
con = DriverManager.getConnection(url);
//con = DriverManager.getConnection(url);
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
      ResultSet.CONCUR_UPDATABLE);
exist = stmt.execute("select * from emp");
rs = stmt.getResultSet();
System.out.println("Cursor Name : " + rs.getCursorName());
 int numOfColumns = rs.getMetaData().getColumnCount();
 for(int k=1;k<=numOfColumns;k++)
 System.out.println(rs.getMetaData().getColumnName(k) + "--" + rs.getMetaData().getColumnTypeName(k));
 System.out.println("No of columns : " + numOfColumns);
 
 while(rs.next())
 System.out.println(rs.getString(1) + "\t" + rs.getInt(2) + "\t" + rs.getString(3));
rs.close();
stmt.close();
con.close();
}catch(Exception ex){
System.out.println("Error:"+ex.getMessage());
ex.printStackTrace();
}
}
}
 

Can someone help me how to fix this problem.

thanks & regards
ravi

[Jeanne Boyarsky]

Ravi,
I'm not familiar with SQL Server, but most databases require a port in the connection string.

[Ravi Tiruvaipati]

Hi Jeanne,
I tried even with port but I am still getting the error. Infact when create ODBC connection to the same database with same user and password it works fine. I tried jdbc dbc bridge, it works there! I dont know what I am missing here for this jTDS. Looks like it is identifying the database and not able to authenticate the login.

ravi

[Ravi Tiruvaipati]

problem solved! It was issue with roles assigned to the user. I should select only public role to access table owned by 'dbo'. I changed the roles and now it works.

thanks for the effort.
ravi