Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Weblogic 7.0 with MS Sql Server 2000

 
Ramesh Kumar Swarnkar
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 !!
 
somkiat puisungnoen
Ranch Hand
Posts: 1312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please set CLASSPATH to driver class in startup server script..

Example :: startWebLogic.bat

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic