Search code examples
coldfusioncoldfusion-2016

Is it possible to add ODBC service to existing CF 2016 install?

We are migrating some code from CF 10 to CF 2016 virtual machines that needs to connect to a couple Access databases. I installed the necessary drivers and setup odbc datasources in Windows but have found that our CF 2016 VM was setup without the ODBC service and I have not been able to find a clear way to add it.

When I go to add/remove programs the only option is to uninstall CF and when I run a CF 2016 installer it will not let me go through the "Server configuration" process because an existing install already exists. Is there a standard approach for adding sub-components to a CF server that were not chosen on first install?

Solution

  • Looks like I found my answer after digging around for a while. The migration wizard needs to be run again to add the ODBC service but there could be various complications with this depending on permissions and other factors. I was not able to get this to work after a brief period of time so I am just going to wrap up my transition to using python for our limited Access needs but I do believe this to be the answer.

    https://community.adobe.com/t5/ColdFusion/ColdFusion-11-ODBC-service/td-p/6207226

    Here are the basic steps. See link above for various troubleshooting info from Charlie Arehart and others.

    1. Navigate to adminconfig.xml at C:\ColdFusion11\cfusion\lib\ and open it with text editor (say notepad).
    2. Change the value from “false” to “true” in runmigrationwizard
    3. Change the value from “false” to “true” in odbc
    4. Save the file and restart ColdFusion Service.
    5. After restarting the service, access the cf admin url and you will get the migration wizard. Follow the onscreen wizard to continue.

    I came upon the answer by way of a thread about getting Access data sources setup in CF11 and CF2016 which Charlie Arehart contributed to and linked over to info about the ODBC service setup.