Two Laptop Bag
The moose likes JDBC and the fly likes JDBC connection to SQL Server from Websphere Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

JDBC connection to SQL Server from Websphere

Anurag Swaym
Greenhorn

Joined: Aug 12, 2002
Posts: 14
Does anyone know, how to connect to a SQL Server from IBM Websphere using Type 4 JDBC ?
I have downloaded the SQL Server driver from the microsoft site. I then updated the classpath variable with the following 3 jar files. (msbase.jar, msutil.jar, mssqlserver.jar)
I am getting a Class Not Found exception.
I am able to successfully create a JDBC connection using Type 1 (JDBC-ODBC bridge) connection. Any help is appreciated. Thanks.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

This is more of a Websphere problem than a JDBC problem, and you've already created a duplicate there (naughty!) so I encourage people wanting to help to this thread:
http://www.coderanch.com/t/72009/Websphere/Creating-JDBC-connection-SQL-Server
Please dont post the same question in multiple forums!
Dave
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: JDBC connection to SQL Server from Websphere
 
Similar Threads
Use MS SQL Server 2000 JDBC driver with WSAD 4.0
Websphere 6.0 DataSource and Microsoft's JDBC driver
Connection Pooling : which one should i use?
Creating a JDBC connection with SQL Server database using Websphere
Need to know Sql version.