I'm having a nightmare trying to use JDBC 2.0 drivers for SQL Server. I'm using JRun, and understand that the drivers must go into the class path, which is <JRun home dir>/lib/ext, or <approot>/WEB-INF/lib, or <approot>/WEB-INF/classes etc however, even when I put the driver jar files into one of these directories, I still get the error "No Suitable Driver". I've tried a number of different drivers (all 30 day trial ones), the only ones I can get to work are ones that I can undo the jar file and put the class directory into the same directory as my application - even this only works if those jar files are self reliant and ond't require other classes. The other I can get to work using JDBC test utilites, I know the problem lies in the JRun classpath, but I don't know what. Any ideas, I'm getting desperate. The JDBC-ODBC driver just isn't up to what I want to do. Thanks
Dorj Galaa
Ranch Hand
Joined: May 29, 2001
Posts: 113
posted
0
copy rt.jar to JRUN classpath
Senior software engineer
Steven Briggs
Greenhorn
Joined: Jul 20, 2001
Posts: 6
posted
0
I'll try that, but what and where is rt.jar? Thanks
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 Drivers - No Suitable Driver - NIGHTMARE !!