How do I connect to a Progress Database
To connect to a Progress 9.1 Database you first need to licensed copy of the Progress Client.
Once the client is installed add the Progress classes file path into the
MX7 Jrun instance. If using a developer CFMX make this change to the settings under cfusion. Add a New Classpath
Restart CF instance. Search the System Information page to locate the following files in CF Admin
C:\Program Files\PROGRESS\java\jdbc.jar; C:\Program Files\PROGRESS\java\messages.jar; C:\Program Files\PROGRESS\java\progress.jar; C:\Program Files\PROGRESS\java\prosp.jar; C:\Program Files\PROGRESS\java\prowin.jar;
Progress Client requires license key. Once Java invokes the class it searches for the licences verification. So be sure to add the the Progress application to the OS path under Environment variables.
Ex. path=%path%;C:\Program files\progress\bin
Reboot maybe required.
Setup Datasource in CF select Driver = other
CF Data Source Name = Test JDBC URL = jdbc:jdbcprogress:T:[host]:[port]:[dbname] Driver Class = com.progress.sql.jdbc.JdbcProgressDriver Driver Name = Progress User Name = [username] Password = [password]
Some Useful links:
JDBC Driver Guide
This question was written by Joe Hammond
It was last updated on January 8, 2007.