• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

how to connect to SQL server 2000 in WSAD 5.1

 
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
 
Ranch Hand
Posts: 1087
Oracle Spring Java
  • 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: 1087
Oracle Spring Java
  • 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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!