Copy link to clipboard
Copied
Hi,
Please be kind, this info is coming from one of our programmers, it's likely I will get terms wrong as I am a Blood Banker, not a programmer, hence my username. 🙂
We are running CF 2021. We are trying to connect to an offsite Oracle database.
When she tried to create the connection in Data Sources she got "The ColdFusion ODBC Server service is not running or has not been installed." In the pic below of IIS you can see the error when she tries to start it. Is there something I need to install too?
Thank you!
Hi @bloodbanker
You can connect using Oracle JDBC thin driver instead of using ODBC. For ODBC services, you can try these command from command prompt for re-installing ODBC.
ColdFusion2021\cfusion\bin>cfpm.bat uninstall odbc
ColdFusion2021\cfusion\bin>cfpm.bat install odbc
Copy link to clipboard
Copied
Hi @bloodbanker
You can connect using Oracle JDBC thin driver instead of using ODBC. For ODBC services, you can try these command from command prompt for re-installing ODBC.
ColdFusion2021\cfusion\bin>cfpm.bat uninstall odbc
ColdFusion2021\cfusion\bin>cfpm.bat install odbc