Copy link to clipboard
Copied
I'm migrating a server from ColdFusion 8 to ColdFusion 9, Standard edition. The CF 9 ODBC Agent and Server services are not getting installed during the CF 9 installation (however, all other CF services do install correctly.)
Here's what I've done so far:
The first time around, I did a CF 9 install, then migrated CF 8 settings. At that point I noticed that the CF 9 ODBC services were not installed.
I searched and found these instructions for installing ODBC services manually on CF 8, but found nothing for CF 9.
Then I completely uninstalled all versions of CF from this server -- CF7, 8, and 9 -- and installed CF 9 again from scratch. The ODBC services still didn't install.
I need the ODBC services to connect to Oracle databases. How can I get them?
I'm installing from CD on Windows 2003 if it makes any difference.
Copy link to clipboard
Copied
lorila wrote:
I need the ODBC services to connect to Oracle databases. How can I get them?
My first question is why you need ODBC to connect to Oracle? Oracle does offer a JDBC "thin client" that one can download and use to connect to ColdFusion.
But if you do need it. Just to be thorough, when you installed CF9, you did select the ODBC option, right? It is an optional installation, and I beleive it is not selected by default in CF9.
Copy link to clipboard
Copied
Ian,
Yes, I did select the ODBC option. Sorry for not mentioning it, it seemed like a given to me
I was not aware of the JDBC thin client option -- I'll check it out.
Still curious why the ODBC services won't install!
Thanks,
Lori
Copy link to clipboard
Copied
lorila wrote:
Ian,
Yes, I did select the ODBC option. Sorry for not mentioning it, it seemed like a given to me
It is always good tech support practice to make sure the obvious have in fact been done. Otherwise an hour into debugging you find out the the person complaining about their computer not working, have in fact NOT plugged it in to the power outlet.
lorila wrote:
Still curious why the ODBC services won't install!
I'm afraid that has never happened to me in over 10 years of ColdFusion installations. Nor have I ever come across anyone discussing a problem like this. I'm afraid you are probably dealing with something rather unique to your systems.
I would thouroghly examine all logs you can, ColdFusion installation and running as well as windows Event logs and anything else you can find.
Copy link to clipboard
Copied
No answer here, but sharing what I've been observing of the install process...
When the initial install EXE is finished running, the ODBC services won't yet be installed.
The install EXE shunts the process over to the "Configuration Wizard" which runs in the browser.
It appears to be that wizard that does, or calls the scripts that do, the actual install of the ODBC services.
Perhaps something is interupting/blocking that part of the install?