• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

WDSC iSeries V7.0.0 - MS SQL Server Connections

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am new to WDSC when trying to connect to non iSeries data sources, and am after some help please.....

Trying to create a new DB connection to SQL server 2000 using the wizard.

select driver as > IBM Websphere Connect JDBC Driver

Enter database name, host and port parameters

JDBC driver class > com.ibm.websphere.jdbc.sqlserver.SQLServerDriver

Class location > point to folder containing jars (base/sqlserver/util)

When I test connnection i get login failed error for my userid.
I have noted that the "com.ibm.websphere.jdbc.sqlserver.SQLServerDriver"
is not in the directory structure where WS was installed on my laptop, and am wondering if this is one of the causes of my problems?

Any help most appreciated

 
reply
    Bookmark Topic Watch Topic
  • New Topic