Facing problem in ODBC datasource configuration for ingress…

Report · Jan 04, 2010

I'm posting this issue on behalf of our client who is using CF 9.

Client says he's not able to configure Cold fusion datasource for ingress. It gives him some error - see attachments please. For your information, he says he was successful on configuring it on an older CF version 5.

I wasn't able to provide needed support as I'm specialized in Adobe's DTP applications, hence your assistance here is very much appreciated.

Report · Jan 04, 2010

Things to check/try.

1. Verify that CF's ODBC service are installed and running correctly: http://help.adobe.com/en_US/ColdFusion/9.0/Installing/WSc3ff6d0ea77859461172e0811cdec18ae0-7fed.html#WSc3ff6d0ea77859461172e0811cdec18ae0-7ff8

2. Try using a JDBC driver rather than an ODBC driver. This option *should* have better performance than using an ODBC driver.

Ingres JDBC drivers:

http://esd.ingres.com/product/drivers/JDBC/java/JDBC

Connecting to an external JDBC Type 4 data source (ColdFusion):

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf3639b1-7fe6.html

JDBC in ColdFusion:

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf3639b1-7ffd.html

Report · Jan 05, 2010

Hi Bob,

I shall forward your recommendations to the user, or better I'll ask them to participate directly here if possible. Thanks for the input.