Friends,
I am having problem to configure Weblogic 7.0 with Ms Sql Server 2000.
The steps I have followed for creating new connection pool is as follows:-
NAME : - MSSQLServerConnectionPool
URL : -
jdbc:microsoft:sqlserver://192.168.0.46:1433/MSSQLServerConnectionPool
DRIVER :- com.microsoft.jdbc.sqlserver.SQLServerDriver
PROPERTIES:- user=sa
PASSWORD:- BLANK (AS I DONT HAVE PASSORD IN SQL SERVER FOR USER Sa)
ACL :- BLANK
Open
String Password :- BLANK
Then I click the create button then Apply- till now fine.
But, I select 'myserver' in 'Target' Tab and add, and click apply button. It generates lots of error, which is like this:-
---------------------
<Oct 13, 2004 4:15:16 PM GMT+05:45> <Error> <JDBC> <001060> <Cannot startup connection pool "MSSQLServerConnectionPool" weblogic.common.ResourceException: Cannot load driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver>
----------------------------------
I have the SQLServerDriver files (3 jar files- downloaded from microsoft site) in my system's Program folder, which I have set in classpath.
I have Sql Server Installed on another machine in LAN, and client in my machine (It is workign fine in
JBOSS).Weblogic is installed on my machine.
I would like to thank my friend(s), for investing valuable time to reply me, in advance !!