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 libraryno JdbcProgress in java.library.pathUnable to load JdbcProgress libraryUnable to allocate environmentReturning from initialize --- JdbcProgressDriver.javajava.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)
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?