Skip to main content
D
dboiler
Participating Frequently
December 3, 2014
Question

Coldfusion 10 ODBC Services

  • December 3, 2014
  • 1 reply
  • 937 views

I have a server with an installation of ColdFusion 10 however the ODBC Services did not get installed with the initial installation. Is there a simple, manual method for installing ODBC Services without uninstalling CF and then reinstalling with that option selected? I have tried running the installation over the current one but with the Configure Installer window, it has Server Configuration greyed out as it has found a current installation. It then gives an option of either EAR file or WAR file in the JEE configuration. Not sure which to choose so that's why I ask the question of a manual install.

Thanks in advance. This is running on a Windows Server 2008 R2 64-bit box.

Dave

    This topic has been closed for replies.

    1 reply

    Anit_Kumar
    Anit_Kumar
    Inspiring
    December 3, 2014

    Here is the script to install ODBC services

    <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>

    Regards,

    Anit Kumar

    D
    dboilerAuthor
    Participating Frequently
    February 24, 2016

    This issue has resurfaced. I try to run this script but all I get is a screen with a large blue circle with the word Error inside it.

    Any advice?

    Dave

    Anit_Kumar
    Anit_Kumar
    Inspiring
    March 11, 2016

    Can you try to uninstall the corrupt service first, by using the below code.

    <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>

    Delete all the .trc files available at \cfusion\db\slserver54\tracing\ .

    And then install using the below code.

    <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>

    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