I have SQL 2000 running on my machine. I need JDBC drivers for that to access from my entity EJB. How can i know where the driver classes reside on my machine so as to supply that information to the WSAD workbench (for websphere j2ee application development) for creating the entity beans bottom-up from the db tables.
I downloaded Microsoft SQL Server 2000 Driver for JDBC and gave the WSAD inputs as the following for EJB to RDB mapping -
JDBC driver class - as com.microsoft.jdbc.sqlserver.SQLServerDriver
Class location - C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar
Its says "no suitable driver" when i apply the above settings.