![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;da
tabasename
=ot
Driver Class: com.ddtek.jdbc.openedge.Op
enEdgeDriv
er
Driver name: C:\Progress\OpenEdge\java\
openedge.j
ar
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.