Forum Discussion

mcintosb's avatar
mcintosb
Occasional Contributor
6 years ago

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

- 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's avatar
    DWalsh
    6 years ago

    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

  • DWalsh's avatar
    DWalsh
    Moderator
    6 years ago

    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

    • mcintosb's avatar
      mcintosb
      Occasional Contributor
      6 years ago

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