how to connect to SQL server 2000 in WSAD 5.1

[aliya sharma]

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]

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 ]

[aliya sharma]

Hey, just an update..i got it working!!..Thanks

[Shailesh Chandra]

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

[aliya sharma]

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