Skip to main content
A
Anonymous
May 29, 2013
Question

What can be done when Cold Fusion 9 ODBC Services will not install?

  • May 29, 2013
  • 1 reply
  • 1467 views

What can be done when 64-bit Cold Fusion 9 ODBC Service will not install on a Windows Server 2008-R2 64-bit machine? Yes, most of the things in other discussions have been tried.

This topic has been closed for replies.

1 reply

Anit_Kumar
Anit_Kumar
Inspiring
May 29, 2013

Hi GDMVU,

Save the below code as CF9_RemoveOdbc.cfm

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

<cfscript> 

     writeOutput("Removing ODBC Services...<br>"); 

     returnValue = myObj.removeODBCservice(); 

     writeOutput("ODBC Services removed"); 

</cfscript>

Save the below code as CF9_InstallOdbc.cfm

 

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

   

<cfscript> 

         writeOutput("Installing ODBC Services...<br>"); 

         returnValue = myObj.installODBCservice(); 

         writeOutput("ODBC Services installed"); 

</cfscript>

Now try the following steps:-

  1. Change admin password in above .cfm pages for your CF 9 server.
  2. Use RemoveObdc cfm page first to remove any existing faulty/corrupted Odbc services.
  3. Use InstallOdbc Odbc services to install Odbc services there.

Hope this helps.

Regards,

Anit Kumar

A
Anonymous
May 30, 2013

I had tried these scripts before but tried them again. The removal script works fine. But there is a error returned for the second script:

"Unable to set value HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ColdFusion 9 ODBC Server\Description: Windows error number 0 occurred.The handle is invalid."

I had searched this error message before and found a discussion about a different matter where it was suggested that the permissions on the key area in the registry might need to be changed due the the lockdown process which changes the service account from the default. If this is true the lockdown instructions distributed by Adobe are incomplete. I am unsure of what needs to be changed and to what extent. Does the Services area of the registry need permissions added for the new CF service account to read and write or what? Maybe this has nothing to do with it, but it sounds credible. But I do not want to be messing with the registry without better guidance. And I would want to reverse this action after ODBC Server is installed.

Anit_Kumar
Anit_Kumar
Inspiring
May 30, 2013

Hi GDMVU,

Can you run the remove script first and then go to the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\. Rename the "ColdFusion 9 ODBC Server" to "ColdFusion 9 ODBC Server_old". Run the Install script thereafter.

Regards,

Anit Kumar

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