Skip to Content
Former Member
Apr 23, 2007 at 04:52 PM

SQL Exception ResourceException , No Suitable driver WD -SQL connection


Hi Experts

I need some help. I am trying to retrive data from SQLServer. The steps I did are .

In the Visual Administrator ,I have created Data Source 'MSSQL2000SRVR' and added recommanded 3 jar files for SQL2000 .The code is

InitialContext initialContext = new InitialContext();

javax.sql.DataSource dataSource = (DataSource)initialContext.lookup("jdbc/MSSQL2000SRVR");

java.sql.Connection conn = dataSource.getConnection();

I am getting the error bellow


SQL Exception ResourceException in method ConnectionFactoryImpl.getConnection(): SQLException thrown by the physical connection: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'sa'.

SQL Exception : No suitable driver

Could any one help me . I promise to reward points to the right solution. I would like to speak if any one is willing to give me their contact number/mail.

Thank you