Avatar of sglee
sglee

asked on 

Setting up a Driver in ColdFusion v.7 to access Progress database

Java Folder Other Driver in CF
I am trying to connect to Progress Database from ColdFusion v7 sot hat I can run a query against the table in the Progressive database. So far I have:
(1)  installed Progress OpenEdge 10.2B Driver on Windows 2003 Server running CF v7.
(2) Added C\Program Files\PROGRESS\java and C:\Program files\progress\bin  to OS path under Environment variables.
(3) Created the following OTHER DATASOURCE:
CF Data Source name: Progress
JDBC URL:         jdbc:datadirect:openedge://192.168.1.6:2550;databasename=ot
Driver Class:          com.ddtek.jdbc.openedge.OpenEdgeDriver
Driver name:    C:\Progress\OpenEdge\java\openedge.jar
User Name:       xxxxx
Password:      xxxxx

When I submit it, I get the following error:
********************************************************
Connection verification failed for data source: Progress
java.sql.SQLException: No suitable driver available for Progress, please check the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available for Progress, please check the driver setting in resources file, error: null
********************************************************

I am sure if syntax in Driver Class and Drive Name is correct as I have not done something like this in the past.

Thanks in advance.
ColdFusion LanguageJavaDatabases

Avatar of undefined
Last Comment
gheist

8/22/2022 - Mon