Skip to main content
B
bloodbanker
Known Participant
July 29, 2021
Answered

2021 ODBC Agent

  • July 29, 2021
  • 1 reply
  • 1415 views

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!

 

      This topic has been closed for replies.
      Correct answer Priyank Shrivastava.

      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

      ​

      1 reply

      Priyank Shrivastava.
      Community Manager
      Priyank Shrivastava.Community ManagerCorrect answer
      Community Manager
      July 29, 2021

      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

      ​

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