Forum Discussion

msap's avatar
msap
Frequent Contributor
7 years ago

Error with Database connection.

Cannot connect to Oracle Database.

Provider Selected: Oracle Provider for OLEDB; 

connection String displays as below: "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=aexqc600;Data Source=QA"

Gives an error"Test connection failed because of error in initializing provider ORA_12154:TNS : couldnot resolve the connect identifier specified"

5 Replies

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor

    I'm not familiar with that error... however, double check: is the Oracle driver a 32-bit driver? If so, and you're running 64-bit TestComplete, you'll have errors.

    • msap's avatar
      msap
      Frequent Contributor

      hi

       

      Yes, its a  sqora32.dll file running on a 64 bit OS.How to avoid these errors/ Please let me know.

       

      Thanks 

      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor

        It's not a matter of the OS.  It's the version of TestComplete.  Starting with TestComplete 12.4, when you run TestComplete, it runs in 64-bit mode.  You CAN run TestComplete in 32-bit mode by finding the TestComplete.exe in C:\Program Files (x86)\SmartBear\TestComplete 12\Bin\ and run that instead.  This should allow you to use the 32-bit driver.