Skip to main content
D
dlally10
Participant
May 20, 2014
Answered

Coldfusion 11 new install - The ColdFusion ODBC Server service is not running or has not been installed.

  • May 20, 2014
  • 4 replies
  • 7779 views

I installed the developer edition on my machine and receive the message, "The ColdFusion ODBC Server service is not running or has not been installed." when trying to add an ODBC datasource in the ColdFusion administrator. I previously used ColdFusion 8 with no problems at all adding ODBC datasources. I uninstalled ColdFusion 8 before installing ColdFusion 11.

    This topic has been closed for replies.
    Correct answer Anit_Kumar

    Thank you for the update.  Is there an ETA for the fix?


    Yes, the fix is in the testing phase. We will share the fix soon.

    Regards,

    Anit Kumar

    4 replies

    CCPSWebmaster
    CCPSWebmaster
    Participant
    August 28, 2014

    On the bug page: Bug#3759846

    It was commented that There is now a fix, and that it will be included in the Upcoming Update of Colfusion 11.

    Do we have a date of release for that Update?

    Personally I think that this bug deserves it's own update. Why wait for other little fixes to be implemented when you have a big GLARING HOLE in your software?

    Isn't this a core feature?

    I find it hard to believe that nobody at Adobe took the time to make sure that Coldfusion 11 was actually able to connect to all the types of data sources that it is supposed to be able to connect to.

    It's not like this is an obscure bug that comes up rarely! Seriously all you have to do is attempt to add an ODBC datasource and "wow look at that, a bug!"

    Isn't such a core feature something that should be tested before software is released?

    davidt78194897
    davidt78194897
    Participant
    April 20, 2017

    can someone send me this hotfix - i am now having the same problem - ColdFusion ODBC Server service is not running or has not been installed

    please help if you can

    [Email removed; This is a public forum - private info is not allowed]

    CF 11 on a win 10 pro machine trying to set up datasources for MS Access files for the development environment.

    Thanks

    H
    haxtbh
    Inspiring
    April 20, 2017

    Just make sure you CF 11 is full patched. It will likely be in one of the rollups.

    Zarach0095
    Zarach0095
    Participant
    August 14, 2014

    Anit,

    I'm having the same issue adding Access Data Sources in CF11. I sent you a PM and also sent an email to the address you provided. Anxiously waiting a reply. Thanks for your help!

    Brandon

    A
    Anonymous
    May 20, 2014

    We discovered the same issue today as well trying to setup CF11 on a machine that has CF9 & CF10 installed on it and then tried to add Access DBs.

    A
    Anonymous
    May 20, 2014

    I tried the work around in the article of starting the ODBC services of CF10 which was offline and that let me add the resources.  However now they all fail to load however.

    Error Executing Database Query.

    [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
    Anit_Kumar
    Community Manager
    Anit_KumarCommunity Manager
    Community Manager
    May 20, 2014

    Hi Leith,

    The workaround will not work for ColdFusion 11. We are working on the fix.

    Regards,

    Anit Kumar

    Anit_Kumar
    Community Manager
    Anit_KumarCommunity Manager
    Community Manager
    May 20, 2014

    Hi dlally10,

    We are aware about the issue. Here is the Bug# 3759846.

    We are working on it with priority.

    Regards,

    Anit Kumar

    itisdesign
    itisdesign
    Inspiring
    July 7, 2014

    Hi Anit,

    I added the following comment on 3759846.  Just also noting the comment here as it contains some workarounds.

    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 3492574 fixed #2 for CF10-only. So #2 again exists in CF11. During Splendor Beta, I added a comment on 3492574 noting this - but there was no reply.

    Issue #4) (unresolved ticket 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 3492580 and 3492608) ODBC DSN creation (#5) and deletion (#6) fail in non-cfusion instances. (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 3029781. Can this ticket please be made public?

    Thanks!,

    -Aaron

    Anit_Kumar
    Community Manager
    Anit_KumarCommunity Manager
    Community Manager
    July 7, 2014

    Hi Aaron,

    I appreciate your time and efforts describing the various aspects. We will look into them.

    Regards,

    Anit Kumar

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