Skip to main content
Zaid Al-Hilali
Zaid Al-Hilali
Participating Frequently
January 4, 2010
Question

Facing problem in ODBC datasource configuration for ingress…

  • January 4, 2010
  • 1 reply
  • 525 views

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.

    This topic has been closed for replies.

    1 reply

    J
    JR__Bob__Dobbs-qSBHQ2
    Inspiring
    January 4, 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

    Zaid Al-Hilali
    Zaid Al-HilaliAuthor
    Participating Frequently
    January 5, 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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices