tracker issue : CF-3759846

select a category, or use search below
(searches all categories and all time range)
Title:

Cannot add ODBC Socket Data Source in ColdFusion 11 on Windows x86 / x64 | Error "ColdFusion ODBC Server Service is not running or has not been installed."

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): / ext-user (Anjaneai Srivastava)

Created: 05/13/2014

Components: Database, ODBC

Versions: 11.0

Failure Type: Usability Issue

Found In Build/Fixed In Build: 11,0,0,289883 /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Mac 10 All,Win XP All

Vote Count: 5

Listed in the version 11.0.01.291346 Issues Fixed doc 
Problem: Cannot add ODBC Socket Data Source in ColdFusion 11 on Windows x86 / x64. 

Method: 

1) Install ColdFusion 10 and then install ColdFusion 11.
2) Stop the ODBC Server Service for ColdFusion 10.
3) Go to CF 11 Web Admin.
4) Go to  Data Source in ColdFusion 11 from Data & Services -- Data sources
5) Select ODBC Socket data source and select Add.

Result:  It would give the prompt - "The ColdFusion ODBC Server Service is not running or has not been installed." despite the service is installed and running.  If we have CF 10 and CF 11 Installed on the same machine, the CF 10 ODBC Server service is controlling CF 11 ODBC Connection.

Expected: We should be able to add ODBC Socket data sources in CF 11 

Workaround: Start the ODBC Server service for CF 10 and try to add the data source in CF 11 and it would work.

Connect : - https://my.adobeconnect.com/p1x5c8cadbc/ -- Demonstration of the problem and its workaround.

Additional Information:

1) If we install CF 11 on a fresh Windows VM 2012 /2008 it would give us the error message as stated in the screenshot regarding "Error accessing available odbc data source, cannot find the ODBC Data Source HKEY under Windows Registry.

2) Problem occurs whether you use 64 bit or 32 bit installer for CF.

3) The scenario is applicable for CF 9 and CF 10 as well. At times, when CF 9 ODBC Server service is stopped it would not let you add a ODBC Socket data Source in CF 10 admin.

4) Similar Bug# 3029781

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3759846

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments:

We're having the same issue with Access datasources. System has CF9, CF10 (services disabled), and just installed CF11 which would not allow adding Access datasources. Enabling the CF10 ODBC services allows us to add the Access datasource however when a page is runt hat would call the datasource we get an error. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
Vote by External U.
12119 | May 20, 2014 02:39:28 PM GMT
On our machine we have CF9 installed & running, CF10 installed but disabled, and CF11 installed and running. The workaround of enabling the CF10 ODBC services worked in terms of letting us add Access datasources to the CFIDE. However trying to run any code that relies on them fails. I have ProcessMonitor running and I could see the CF9 swsoc.exe trying to access the mdb file instead of the one from CF10 or CF11 but data does not seem to make it back to CF11 to let it know that it was there. It doesn't seem like the various ODBC services play well together at all.
Comment by External U.
12112 | May 20, 2014 02:46:13 PM GMT
Same issue here! Unfortunately I uninstalled CF10 before installing CF11 so I'm stuck without a solution.
Vote by External U.
12120 | May 23, 2014 03:05:54 PM GMT
@RyanISD196, Please send an email to cfinstal<AT>adobe<DOT>com for the fix.
Comment by Anit K.
12113 | May 23, 2014 03:10:09 PM GMT
Similar problem: Windows Server 2012 R2 Fresh ColdFusion 11 Standard 64-bit install Error message on attempting to add Microsoft Access datasource: "The ColdFusion ODBC Server service is not running or has not been installed. You may also use the "MS Access with Unicode" driver to connect to MS Access datasources." "MS Access with Unicode" is not an option on ColdFusion 11 standard... Attempting to add ODBC Socket datasource error: The ColdFusion ODBC Server service is not running or has not been installed. This is a fresh install, previous CF versions are not breaking it.
Comment by External U.
12114 | May 30, 2014 07:28:54 PM GMT
Can't use Microsoft Access or ODBC datasources.
Vote by External U.
12121 | May 31, 2014 12:29:19 AM GMT
@sjibben, you may like to visit https://forums.adobe.com/message/6416141#6416141 , discussing the similar issue. Or you can send an email to us at cfinstal<AT>adobe<DOT>com
Comment by Anit K.
12115 | June 02, 2014 07:40:05 AM GMT
Hi Anit, Issue #1) CF11's C:\ColdFusion11\cfusion\lib\neo-drivers.xml has 20002 (CF10's ODBC Server port) for both MSAccess and ODBCSocket. Workaround #1) Open that file and replace all 20002 with 20004 (CF11's ODBC Server port). Issue #2) CF11's Settings Migration, Datasources page and CAR Deploy feature all write 20002 to C:\ColdFusion11\cfusion\lib\neo-datasource.xml for ODBC DSNs. Workaround #2) Open that file and replace all 20002 with 20004. Restart CF after editing those files. Issue #3) Creating CF11 ODBC DSN fails if CF10's ODBC Server isn't running. (same issue regardless if CF10 was installed or not prior to installing CF11) Workaround #3) Noted in description for this ticket (install CF10 w/ ODBC support, then create the CF11 ODBC DSN, then stop CF10's ODBC service). Ticket CF-3492574 fixed #2 for CF10-only. So #2 again exists in CF11. During Splendor Beta, I added a comment on CF-3492574 noting this - but there was no reply. Issue #4) (unresolved ticket CF-3492620) 64-bit CF11 still requires same-named 32-bit "System DSN" to be manually registered w/ Windows using C:\Windows\SysWOW64\odbcad32.exe. (the "Unable to update the NT registry. Variable DRIVERPATH is undefined." error indicates CF didn't successfully register the DSN as 32-bit - tho the 64-bit registration succeeds) Issue #5 and #6) (unresolved tickets CF-3492580 and CF-3492608) ODBC DSN creation (#5) and deletion (#6) fail in non-cfusion instances. (CF-3492608 has workaround for #5) Hopefully this port issue can be fixed in a future-proof way. And hopefully CF12 can properly register ODBC DSNs w/ Windows as the correct bitness. I'm unable to view CF-3029781. Can this ticket please be made public? Thanks!, -Aaron
Comment by External U.
12116 | July 07, 2014 04:14:26 PM GMT
This issue is fixed and this fix will be available in the upcoming update of ColdFusion 11.
Comment by Nimit S.
12117 | August 22, 2014 10:02:59 AM GMT
Do we have a date of release for this update? Personally i think this bug should have it's own update. This is a MAJOR issue. We can't use a core feature of the software!
Comment by External U.
12118 | August 28, 2014 10:29:33 AM GMT
Working on a legacy application that uses ODBC to Visual FoxPro. This is a requirement at this point and time. This is a fresh CF 11 install and getting the error stating the ODBC list is unavailable in the registry. This is happening with a downloaded installer from Jan 11, 2016. The ODBC is a 32-bit Syustem connection as VFP is 32-bit and the drivers to connect are not available in a 64-bit version.
Vote by External U.
12122 | January 13, 2016 08:51:15 AM GMT
Cannot access ODBC database: Fresh install CF11 on Windows Server 2012. Application requires ODBC 32 bit. CF Administrator error "Error accessing available odbc datasources. - Cannot open HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources: Windows error 2 occurred.The system cannot find the file specified. The ColdFusion ODBC Server service is not running or has not been installed"
Vote by External U.
12123 | May 21, 2016 10:42:31 AM GMT