cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Connect to Database

SOLVED
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
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
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

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

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓
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.