cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Connect to Database

SOLVED
Highlighted
Occasional Contributor

Unable to Connect to Database

I'm trying to connect to a Win10/Oracle12 database within my local network, via a DB Table variable. 

 

I have the following information:

 

- Full Data Source, including protocol/host/port and SID

2019-07-23_10-12-14.png

- User ID and Password

 

My available providers (on 32 bit) are: 

2019-07-23_10-10-04.png

 

I've tried all of them so far and none have worked. I'm just wondering, what am I missing? What does it look like to access an Oracle database with these credentials?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Staff

Re: Unable to Connect to Database

Can you connect successfully to your datasource outside of TestComplete? 

 

You may need an Oracle 12 client to get the correct settings in ODBC section. See https://kb.iu.edu/d/awqf for example which discusses this

View solution in original post

3 REPLIES 3
Highlighted
Staff

Re: Unable to Connect to Database

Can you connect successfully to your datasource outside of TestComplete? 

 

You may need an Oracle 12 client to get the correct settings in ODBC section. See https://kb.iu.edu/d/awqf for example which discusses this

View solution in original post

Highlighted
Community Manager

Re: Unable to Connect to Database

Thanks for the help, DWalsh.

@mcintosb, is this what you were looking for?

---------
Tanya Gorbunova
SmartBear Community Manager

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
Highlighted
Occasional Contributor

Re: Unable to Connect to Database

Yes, it was. I had to set up an ODBC connection before I could reference it in TestComplete.

 

 

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

Changing options from outside of TestComplete

Participate!

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!
Top Kudoed Authors