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 at 8:53:44 AM EST.

Categories

Database / SQL

Comments

Comment made by Todd Mesick on February 7, 2007 at 9:26 AM
Hi

I have Redhat 4 es and CFMX7. I am trying to connect to Progress 9.1d. I keep getting this error java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection Any thoughts???

Comment made by christine on March 11, 2007 at 9:17 PM
Hi todd, I am converting 4gl progress application into coldfusion. Did you start progress database with procontrol? and did you create the user "sysprogress"?

Comment made by Stefan le Roux on July 2, 2008 at 6:23 AM
Thanks Joe! We've been struggling with this for quite a while. We used an ODBC/JDBC bridge before, with the usual performance penalty. Now our queries run at least 5-10 times faster depending on the data returned. You're not a cook, you are a Chef!

Add a Comment

Your Name:
Your Email Address:
Your Comment:
Enter the code shown: