Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code forum!
  • 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
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

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
 
What's that smell? I think this tiny ad may have stepped in something.
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic