Forum Discussion

Lance_101's avatar
Lance_101
Occasional Contributor
8 years ago

How does TestComplete determine which Oracle provider to use?

We recently upgraded to TestComplete version 12.31.1833.7. We also updated our Oracle provider from version 11g to 12c. Shortly thereafter a SQL statement in one of our tests began producing duplicat...
AlexKaras's avatar
AlexKaras
Icon for Champion Level 2 rankChampion Level 2
8 years ago

Hi,

 

TestComplete does not do any search or consideration as for what provider to use but uses the one explicitly specified in test code.

A assume that you are using OLE DB to query database from TestComplete.

OLE DB can use either some native Oracle OLE DB provider or generic OLE DB provider that works with the database via ODBC. This is defined by the connection string that is used to query the database from TestComplete.

DLL to be used by the OLE DB engine is specified in the registry by the setup program of the given OLE DB provider or ODBC driver.

 

Can you provide the connection string that is used in your test code to connect to the database and query it?

Lance_101's avatar
Lance_101
Occasional Contributor
8 years ago

Thanks Alex, your response was very helpful.