Using Coldfusion to connect to a progress database running on a solaris host.
In Coldfusion the DSN setup is
CF Data Source Name dummy
JDBC URL jdbc.JdbcProgress:T:localhost:6000:dbname
Driver Class com.progress.sql.jdbc.JdbcProgressDriver
Driver Name ----don't know value----
resulting error message...
Connection verification failed for data source: its
java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: No suitable driver.
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: No suitable driver.
Although not that familiar with the Progress JDBC driver, when that error occurs with our JDBC driver, it usually indicates that you don't have the necessary JDBC driver in your classpath. Typically, your classpath would look something like
where the jar file contains the openlink JDBC information. You should have something like that setup for your environment. If this is not the case, I believe ColdFusion also has an option were you need to setup your Classpath that might be different from the System one. Again, add the necessary JAR files for Progress into this location.
I managed to get my ColdFusion Setup going yesterday and I had a similar problem to you. In the end, I did a couple of things. I had a CLASSPATH environment defined for my user which pointed to the actual jar file, secondly, I definied it using the JVM and JAVA setting via the administrator. With these defined, I was able to connect to my database.
Are you using CFMX? If so, Install the temp jrpatch.jar file (search for it on Macromedia support) and you should get more detailed error messages. I have the jdbc connection setup with a merant connection but not openlink. Can you tell me how you have your options configured for the openlink driver?
I added my jar file located /home/openlink/jdk1.4/opljdbc3.jar. This is all taken care of by the shell script script openlink.sh
After running this script, I restarted my coldfusion with these settings as part of my environment, don't believe this is really necessary but just in case, and in the Java and JVM settings, I added the directory structure incl. jar file to my settings, restarted CF
From the Datasources section, I added a new setting for Other and simply added