aspose file tools*
The moose likes Websphere and the fly likes how to connect to SQL server 2000 in WSAD 5.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "how to connect to SQL server 2000 in WSAD 5.1" Watch "how to connect to SQL server 2000 in WSAD 5.1" New topic
Author

how to connect to SQL server 2000 in WSAD 5.1

aliya sharma
Ranch Hand

Joined: Aug 11, 2004
Posts: 48
Hello,
I'm trying to configure my test enviornment to connect to db2 and SQl Server 2000. I can connnect to db2 just fine but can't to SQL Server 2000. THis iswhat i did:
db view -make new connection-then fill in the appropriate fields and specify the class path for the jar files. But when i click on finish. I get the following error:

Problems encountered while trying to establish connection. Reason: Problems encountered while loading the JDBC driver, Reason: 'com.ibm.websphere.jdbc.sqlserver.SQLServerDriver

Could anyone please help me out with this??..I would really appreciate your help. THanks
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

is there any error code you are getting !!!1

how ever I always make connection using data source
[ October 15, 2004: Message edited by: Shailesh Chandra ]

Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
aliya sharma
Ranch Hand

Joined: Aug 11, 2004
Posts: 48
Hey, just an update..i got it working!!..Thanks
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

if there is any thing additional share it with forum so that other user may get advantage of it .
aliya sharma
Ranch Hand

Joined: Aug 11, 2004
Posts: 48
It ws just that with DB2, when setting the data source, i didn't have to name the server location andit worked fine, but with SQL Server, i specify the server location and got it working
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: how to connect to SQL server 2000 in WSAD 5.1