This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I am trying to establish connection to mssql2000 on server through JSP Server Tomcat The code used in jsp is
It's loading the driver and "JDBC Driver Loaded " message received I have properly replaced dsnname, username and password in url string with the exact dsn details provided by my system administrator. But when trying to get connection the server output is Hello loading and connecting to dB JDBC Driver Loaded Error Number. 2 : SQLException: Could not connect to dB Error Message is [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error Code is 0 Error State is IM002 The above error received for the both url formats The same code /jsp file when run on local machine (mssql7 and tomcat 4.0.1) with the same dsn name properly configured (Here I used user name="sa" and password="") is able to establish connection to database. System administrator says that the dsn is configured properly on the server. Please indicate whether the problem is with the code or the dsn is not properly configured at the server thanks Mohan [ Edited by Dave to format code and fix smilies ] [ April 09, 2002: Message edited by: David O'Meara ]
The correct way of using Class.forName is Class.forName("sun.jdbc.odbc.JdbcOdbcDriver:DSNName"); out.println("JDBC Driver Loaded"); Thanks Sanjay [ Edited by Dave to fix problem ] [ April 09, 2002: Message edited by: David O'Meara ]