Skip to main content
Participant
September 2, 2026
Answered

Installed ColdFusion 2023 hotfix 23, once installed ODBC database connection stops working. Error says I need to reinstall ODBC server but it's installed.

  • September 2, 2026
  • 3 replies
  • 28 views

Website was working fine with hotfix 22.

    Correct answer Charlie Arehart

    Tracy, first as with any update, have you confirmed all went well with the update?

    • Check the update log, within hf-updates folder for the given update.
    • At about line 70, does the table show 0 fatal and non fatal errors?
    • At the bottom (about 10 lines from the bottom), does it show no errors in downloading the packages that were updated?
    • Then in the coldfusion-out.log, look for the startup that happened to me right after the update. It should show uninstalling of the packages to be updated, then the starting of all installed packages. Any errors there?

    Usually, unexpected failures of things after an update turn out to be caused by problems DURING the update, even though there may have been no other indication of an error, to whoever applied that update. 

    Second, you mention odbc. Just curious: what db are you pointing to that still uses odbc as its connection? Sometimes people no longer need to rely on odbc (which will be removed from cf in the future). Maybe we could help you implement an easy alternative. I realize perhaps you can't won't consider that, but I hope you'll still clarify the db used for now. 

    3 replies

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity ExpertCorrect answer
    Community Expert
    September 2, 2026

    Tracy, first as with any update, have you confirmed all went well with the update?

    • Check the update log, within hf-updates folder for the given update.
    • At about line 70, does the table show 0 fatal and non fatal errors?
    • At the bottom (about 10 lines from the bottom), does it show no errors in downloading the packages that were updated?
    • Then in the coldfusion-out.log, look for the startup that happened to me right after the update. It should show uninstalling of the packages to be updated, then the starting of all installed packages. Any errors there?

    Usually, unexpected failures of things after an update turn out to be caused by problems DURING the update, even though there may have been no other indication of an error, to whoever applied that update. 

    Second, you mention odbc. Just curious: what db are you pointing to that still uses odbc as its connection? Sometimes people no longer need to rely on odbc (which will be removed from cf in the future). Maybe we could help you implement an easy alternative. I realize perhaps you can't won't consider that, but I hope you'll still clarify the db used for now. 

    /Charlie (troubleshooter, carehart. org)
    Participant
    September 2, 2026

    I reviewed the logs and found that it had an error finding the ODBC package to update it. So I unzipped the bundle again and reran the install and all is working.  Thank you for your help.  And the reason we are still using ODBC we have an old application that still uses a 32 bit Access database file for updates. 

    Charlie Arehart
    Community Expert
    Community Expert
    September 2, 2026

    Great to hear you've solved it and glad to have helped.

    As a heads-up, be aware that both MS Access and ODBC are listed as deprecated as of cf2025. That doesn't mean you can't use them, but you should be striving to move off their use.  See:

    https://guides.adobe.com/coldfusion/en/docs/introduction-to-coldfusion/deprecated-features.html

    "Good news" for you is they're not in the "unsupported" column, as those things will be removed in the next cf release (which looks like it will be cf2027). Your impact will be the release after that. 

    /Charlie (troubleshooter, carehart. org)