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
example:
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
Ex
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
http://www.psdn.com/library/entry.jspa?categoryID=296&externalID=1101
SQL-92 Reference
http://www.psdn.com/library/entry.jspa?externalID=1094&categoryID=296
This question was written by Joe Hammond
It was last updated on January 8, 2007.