Highlighted

Coldfusion 10 ODBC Services

New Here ,
Dec 03, 2014

Copy link to clipboard

Copied

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

Views

725

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Coldfusion 10 ODBC Services

New Here ,
Dec 03, 2014

Copy link to clipboard

Copied

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

Views

726

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Dec 03, 2014 0
Adobe Employee ,
Dec 03, 2014

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 03, 2014 0
New Here ,
Feb 24, 2016

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 24, 2016 0
Adobe Employee ,
Mar 11, 2016

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 11, 2016 0