Unable to Connect to Database

[mcintosb]

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

- User ID and Password

My available providers (on 32 bit) are: 

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?

[DWalsh · Accepted solution]

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

[TanyaYatskovska]

Thanks for the help, DWalsh.

@mcintosb, is this what you were looking for?

[mcintosb]

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