SQL Server , No Suitable Driver

[Ratnakar Malla]

Hi,
I am trying to configure JDBC Connection pool with WL8.1 and SQL
Server 2000.
I configured using the console, and also tested the connection. It
works like charm. I can test the pool, and it says pool connection as
success.
However , when I try to invoke the connection , in my program it
fails.

From the trace below, we can gather that it can find the driver, but I
dont know
why it throws the error??

Any ideas?

Thanx,
Ratnakar

From my Code, I am invoking the pool as follows:

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("Created Driver");
Properties props = new Properties();
props.put("connectionPoolID", "WebmmPool");
dbCon = DriverManager.getConnection("jdbc:weblogic:pool", props);

Here is the trace of error:
************ START TRACE *****************
Created Driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.quantros.webmm.DBMSConnection.getConnection(DBMSConnection.java:3
9)
at jsp_servlet._jsp._webmmauto.__reflist._jspService(__reflist.java:231)

at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)

************ END TRACE *****************

################ START CONFIG ########################
MY CP Settings:
set SQLSERVER_CP=C:\sqlserver_drivers\msbase.jar;C:\sqlserver_drivers\mssqlserver.jar;c:\sqlserver_drivers\msutil.jar;
set WEBLOGIC_CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\weblogic_sp.jar;%SQLSERVER_CP%%WL_HOME%\server\lib\weblogic.jar;%WL_HOME%\server\lib\ojdbc14.jar

My Config.xml settings:
<JDBCConnectionPool
DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
Name="WebmmPool" Password=""
Properties="user=sa;url=jdbc:microsoft:sqlserver://MUKERJIMUKERJI1:1433;selectMethod=cursor;userName=sa;dataSourceName=SQL2000JDBC;databaseName=UCSFExternal;serverName=localhost"
Targets="myserver"
TestTableName="SQL SELECT COUNT(*) FROM sysobjects"
URL="jdbc:microsoft:sqlserver://MUKERJI\\MUKERJI1:1433"/>

################ END CONFIG ########################