Skip to main content
Domi_ogm
Domi_ogm
Participant
June 24, 2014
Question

ColdFusion 11 ODBC service

  • June 24, 2014
  • 1 reply
  • 3818 views

People who installed coldFusion 11 on our server didn't select the option "ODBC Service".

Is there a way to install the ODBC service without re-installing coldFusion ?

    This topic has been closed for replies.

    1 reply

    vishu_13
    vishu_13
    Inspiring
    June 24, 2014

    Hi

    Here are the steps you need to follow .

    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>false</runmigrationwizard> and <odbc>false</odbc>.
    3. Change the value from “false” to “true” <odbc>false</odbc>.
    4. Save the file and restart ColdFusion Service.
    5. After restarting the service, you will get the migration wizard. Follow the onscreen wizard to continue.

    HTH

    Thanks

    VJ

    Domi_ogm
    Domi_ogmAuthor
    Participant
    June 24, 2014

    Thank you, but it didn't work.

    Now I have the message "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."

    but there isn't any "MS Access with Unicode" in the list of drivers.

    Dominique

    vishu_13
    vishu_13
    Inspiring
    June 24, 2014

    If there is ColdFusion 11 ODBC Agent and ColdFusion 11 ODBC Server services created then delete them via command prompt

    Then use this script to delete the corrupted ODBC services. Run these cfm from CF 11 and then check the services.

    Remove_ODBC.cfm

    <cfscript>

      //login using admin 

      //createObject("component","cfide.adminapi.administrator").login("administrator_password");

      createObject("component","cfide.adminapi.administrator").login("admin");      

      //instantiate datasource object

      myObj = createObject("component","cfide.adminapi.datasource");

    </cfscript>

     

    NOW TO REMOVE ODBC SERVICES:

    <cfscript> 

         writeOutput("Removing ODBC Services...<br>"); 

         returnValue = myObj.removeODBCservice(); 

         writeOutput("ODBC Services removed"); 

    </cfscript>

    Install_ODBC.cfm

    <cfscript>

      //login using admin 

      //createObject("component","cfide.adminapi.administrator").login("administrator_password");

      createObject("component","cfide.adminapi.administrator").login("admin");

      //instantiate datasource object

      myObj = createObject("component","cfide.adminapi.datasource");

    </cfscript>

     

    TO Install ODBC Services:

    <cfscript> 

             writeOutput("Installing ODBC Services...<br>"); 

             returnValue = myObj.installODBCservice(); 

             writeOutput("ODBC Services installed"); 

    </cfscript>

    HTH

    Thanks
    VJ

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