cancel
Showing results for 
Search instead for 
Did you mean: 

Error with Database connection.

Highlighted
Frequent Contributor

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 5
Highlighted
Community Hero

Re: Error with Database connection.

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.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
Highlighted
Frequent Contributor

Re: Error with Database connection.

hi

 

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

 

Thanks 

Highlighted
Community Hero

Re: Error with Database connection.

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.


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
Highlighted
Frequent Contributor

Re: Error with Database connection.

Hi I am still working on older version 12.30.1651.

Highlighted
Community Hero

Re: Error with Database connection.

This sounds more like an issue with how you have access to your db or how your environment is configured and less about test complete:

 

https://community.oracle.com/thread/3510766


Thanks,
Carson

Click the Accept as Solution button if my answer has helped
New Here?
Join us and watch the welcome video:
Announcements
Join TechCorner Challenge!
Want a fun and easy way to learn TestComplete? Try solving weekly TechCorner challenges and get into the Leaderboard!

Challenge Status

How to execute remote test and obtain results via Test Runner REST API

Participate!

Comparing content of HTML table with Excel file data

Participate!

Compare HTML table with Excel file and correct data in the file

Participate!

Retrieve Data from a Web Page

Participate!
Top Kudoed Authors