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