3 Replies Latest reply on Mar 11, 2016 1:42 AM by Anit_Kumar

    Coldfusion 10 ODBC Services

    dboiler

      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

        • 1. Re: Coldfusion 10 ODBC Services
          Anit_Kumar Adobe Employee

          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

          • 2. Re: Coldfusion 10 ODBC Services
            dboiler Level 1

            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

            • 3. Re: Coldfusion 10 ODBC Services
              Anit_Kumar Adobe Employee

              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