Skip to main content
dboiler
Participating Frequently
Dec 3, 2014 8:45 PM UTC
Question

Coldfusion 10 ODBC Services

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 is closed to new replies. Start a new post to keep the conversation going.

    3 replies

    Anit_Kumar
    Anit_Kumar
    Inspiring
    Dec 3, 2014 8:50 PM UTC

    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

    Translate
    dboilerAuthor
    Participating Frequently
    Feb 24, 2016 4:20 PM UTC

    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

    Translate
    Anit_Kumar
    Anit_Kumar
    Inspiring
    Mar 11, 2016 9:42 AM UTC

    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

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