I realize this is probably an elemtary question to many. My company has an internal Java project that requires us to connect to a product that uses Progress as the backend - version 9.1D07. We've copied the jar from the project with the jdbc classes in it, but when I try to connect to the database, I keep getting this:
Unable to load JdbcProgress library
no JdbcProgress in java.library.path
Unable to load JdbcProgress library
Unable to allocate environment
Returning from initialize --- JdbcProgressDriver.java
java.sql.SQLException: Unable to load JdbcProgress library
at com.progress.sql.jdbc.JdbcProgress.<init>(JdbcProgress.java:162)
at com.progress.sql.jdbc.JdbcProgressDriver.initialize(JdbcProgressDriver.java:321)
at com.progress.sql.jdbc.JdbcProgressDriver.connect(JdbcProgressDriver.java:155)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
...
getConnection: no suitable driver found for jdbc:JdbcProgress:T:******
java.sql.SQLException: No suitable driver found for jdbc:JdbcProgress:T:******
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
...
SQLException: SQLState(08001)
We know the connection string is correct, we took it out of the product's configuration file. I know the jar file is on the classpath, it's sitting in the lib directory in a web application and the IDE is including that in the build path.
We have no problem with Oracle or SQLServer connections. What am I missing?
Thanks