Forum Discussion

hb's avatar
hb
Occasional Contributor
7 years ago

JScript runtime error. ORA-12541: TNS:no listener

I have installed the new oracle 12 client on the machine (32 bit) , i have Excel-connecting to the oracle db as well, on the same machine, testcomplete keeps giving "JScript runtime error. ORA-12541:...
  • hb's avatar
    hb
    7 years ago

    added the env variable ORACLE_HOME , i had windows 10 installed on it and forgot about this PATH variable, this was working before the upgrade to windows 10. It started working once the path is added.

     

    thanks again

tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago

Under Help | About, what bitness of TestComplete are you running, x86 or 64 bit?  Because if you're running 64-bit, since you're using the 32-bit driver, TestComplete won't "see" that driver.  If you run TestComplete.exe from C:\Program Files (x86)\SmartBear\TestComplete 12\bin\, you'll be running the 32-bit version.  Run that and see if your problem continues.

  • hb's avatar
    hb
    Occasional Contributor
    7 years ago

    Hi Thank you for the response, my bad i did not include the test complete version before itself, i am using the 32 bit i have my shortcut referring to the below location

     

    ""C:\Program Files (x86)\SmartBear\TestComplete 12\Bin\TestComplete.exe""

    • hb's avatar
      hb
      Occasional Contributor
      7 years ago

      added the env variable ORACLE_HOME , i had windows 10 installed on it and forgot about this PATH variable, this was working before the upgrade to windows 10. It started working once the path is added.

       

      thanks again