Can't load JdbcOdbc library on Win95`
I have set up my data source name and it is present in the odbc.ini file in C:\windows
I compile and execute the sample code and the Jdbc-Odbc Bridge loads but then it tries to load the JdbcOdbc library and can't. Here is the output:
DriverManager.getConnection("jdbc:odbc:Test")
trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1fef6f]
*Driver.connect (jdbc:odbc:Test)
JDBC to ODBC Bridge: Checking security
No SecurityManager present, assuming trusted application/applet
JDBC to ODBC Bridge 2.0001
Current Date/Time: Fri Jul 20 06:04:41 PDT 2001
Loading JdbcOdbc library
Unable to load JdbcOdbc library
java.sql.SQLException: Unable to load JdbcOdbc library
at sun.jdbc.odbc.JdbcOdbc.<init>(JdbcOdbc.java:81)
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:311)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:149)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at CreateCoffees.main(CreateCoffees.java:57)
Unable to load JdbcOdbc library
Unable to allocate environment
getConnection: no suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at CreateCoffees.main(CreateCoffees.java:57)
SQLException: SQLState(08001)
SQLException: No suitable driver
I have added the extension jdbc2_0-stdext.jar and it is in my classpath.
Can anyone help? I don't know where the library should be located, what it would be called or what configuration change I could make to help locate/load it.
