Skip to main content
C
coolidge
Known Participant
November 30, 2020
Question

Cannot start ODBC Server service

  • November 30, 2020
  • 1 reply
  • 1728 views

Hello - I recently installed ColdFusion Standard 2018.  I tried to add an MS Access data source, but I noticed that the ColdFusion 2018 ODBC Server was not started.  When I try to start it, I see the error in the attached.  Has anyone encountered this?  Any suggestions?  I am not able to start the service.  Thank you.

    This topic has been closed for replies.

    1 reply

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    November 30, 2020

    Coolidge, to be clear the service works so whatever is amiss is a local issue. Could be any of several. Tough to list all here, so let's go a couple at a time. And even if a question seems obvious or dumb, we can't ignore any possibilities in a case like this.

     

    Are you sure the process you point to was not running already? It could be, and yet not show as the SERVICE running it.

     

    If you go to the command line, as admin, and run the same command shown in the service (including any args there), do you see any error at the command line?

     

    And I'm not at a computer at the moment, but there's a port for the odbc service that may be amiss somehow on your setup.

     

    Reply to the above as a  start, and next time I respond I'll be on a pc to test things and suggest more, if needed. 

    /Charlie (troubleshooter, carehart. org)
    C
    coolidgeAuthor
    Known Participant
    December 1, 2020

    Charlie - Thanks so much, really appreciate the help.  Here's what I see when I run the command from the command line.

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    December 1, 2020

    OK, that rings a bell, then. I recall a discussion here in the forums in the past couple of years, where people reported that upon applying a certain CF update, they found this happened--because the update had REMOVED that file when it should not have (or it should have replaced it with an updated version).

     

    Granted, that discussion was about CF2016 and 11, and you are on CF2018, but perhaps the discussion still applies.

     

    So first, I had done a blog post to summarize the key points from that very long thread:

    https://coldfusion.adobe.com/2019/02/fix-recent-cf11-2016-updates-causing-failure-cf-odbc-services/

     

    And notice how I quote Adobe's own technotes from that era, about a "known issue" (in some of the updates), which said what to do. You can try what I (and that technote) suggest, and I suspect it will work.

     

    Back to how you are on CF2018, I will say at least that the last CF2018 update that had a technote with "known issues" was update 7 (https://helpx.adobe.com/coldfusion/kb/bugs-fixed-coldfusion-2018-update-7.html), and it makes no mention of this issue. But perhaps the problem has returned. Do give the fix a shot (finding the dll in the update backup folder, and copy it back into CF, per the docs or my post). 

     

    (Also, I notice that the link to the forum discussion which I offer in the post, https://coldfusion.adobe.com/discussion/2534653/, fails for some reason, but this works: https://community.adobe.com/t5/coldfusion/cf-11-update-15-cf-odbc-server-no-more-starts/m-p/10059797 )

     

    Let us know how it goes. And in case it's helpful, let us know what CF update you are on.

    /Charlie (troubleshooter, carehart. org)
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices