This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to connect to SQL server 2000 in WSAD 5.1

 
aliya sharma
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey, just an update..i got it working!!..Thanks
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
if there is any thing additional share it with forum so that other user may get advantage of it .
 
aliya sharma
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic