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

[Anit_Kumar]

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

[dboiler]

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]

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