CF9 ODBC Socket issue

Report · Jun 23, 2011

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.

Report · Nov 04, 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.

Report · Nov 14, 2011

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

Report · Nov 14, 2011

No...running 32

Report · Nov 14, 2011

Same.. running in 32 bit.

Report · Nov 13, 2012

I am getting this error message as well and I am running 64-bit. Here is the full text of the error message I am getting.
------------------------------

The description for Event ID 0 from source ColdFusion 9 ODBC Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

ColdFusion 9 ODBC Server@LOCALHOST,ErrorCode=3004,ErrorMessage=sched.swschd.1424.Internal error, an unexpected exception was detected.