• 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
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Rob Spoor
  • Henry Wong
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh
  • Jj Roberts

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

 
Grow your own food... or this tiny ad:
SKIP - a book about connecting industrious people with elderly land owners
https://coderanch.com/t/skip-book
reply
    Bookmark Topic Watch Topic
  • New Topic