Skip to main content
R
ryanpatsko-RmwQmB
Participating Frequently
June 23, 2011
Question

CF9 ODBC Socket issue

  • June 23, 2011
  • 1 reply
  • 1998 views

I upgraded from CFMX7 Standard to CF9 Enterprise this week. Since the upgrade, I am unable to create a new datasource using either the ODBC Socket driver or the Microsoft Access driver. When I attempt to add an ODBC Socket ds, I get this message:

The ColdFusion ODBC Server service is not running or has not been installed.

Both the ODBC Server service, and the ODBC Agent service are installed and running. I tried uninstalling and reinstalling the services (using the instructions in the comment of this tech note) but the problem was not solved.  I also had to fix port numbers as described in this post. (After my original install, none of my imported datasources worked until I changed those ports from 19999/20000 to 19997/19998)

Has anyone run into this issue? I've googled it for days and I have an open case with Adobe, but so far we have not been able to solve it. I appreciate any suggestions.

Other install details: Windows Server 2003 Web Edition SP2, using IIS v6.0. Also using Sequelink 5.4 - I feel like the issue might be with that but I'm just guessing at this point.

    This topic has been closed for replies.

    1 reply

    F
    frankinamac
    Participant
    November 4, 2011

    I have a similar issues as well..

    We have upgraded from MX7 to CF9 and after the upgrade, we're able to connect to the database using ODBC however there's some instance we hit an error

      Source: ColdFusion 9 ODBC Server

      Description: The description for Event ID ( 0 ) in Source ( ColdFusion 9 ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ColdFusion 9 ODBC Server@LOCALHOST,ErrorCode=3004,ErrorMessage=sched.swschd.1424.Internal error, an unexpected exception was detected..

    Has onyone encountered this issue or any suggestions? Many thanks.

    A
    Anonymous
    November 14, 2011

    Are either/both of you running 64 bit by any chance?

    R
    ryanpatsko-RmwQmBAuthor
    Participating Frequently
    November 14, 2011

    No...running 32

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