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


C:\Program Files\PROGRESS\java;

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

SQL-92 Reference

This question was written by Joe Hammond
It was last updated on January 8, 2007.


Database / SQL


comments powered by Disqus