I'm working on a project where I would like to connect to a MS SQL Server 2000 database from websphere (using connection pooling etc...). I downloaded the Microsoft SQL Server 2000 Driver for
JDBC (which microsoft says they tested with websphere) and am having trouble getting it to connect to the database. I even tried setting up a connection through the Data Perspective and am unable to do that. It must have something to do with the properties. But I am unable to figure it out. Can someone give me a step by step guide on how to add this driver as a JDBC Provider (or make a simple connection) on WSAD4?
Thanks,
Mark