Use of an ODBC Driver Manager to Support Concurrent Connections to Multiple Databases
(Doc ID 753815.1)
Last updated on AUGUST 17, 2023
Applies to:Oracle TimesTen In-Memory Database - Version 188.8.131.52.0 to 184.108.40.206.9 [Release 7.0 to 11.2]
Information in this document applies to any platform.
This Bulletin applies to all TimesTen applications where there may exist a need for concurrent connection to non-TimesTen databases.
This Bulletin identifies problems associated with attempting concurrent ODBC connections to multiple databases using proprietary ODBC drivers.
The Bulletin then identifies a potential solution to the problem using an ODBC Driver Manager. Although the Bulletin is written from the perspective of a TimesTen user, the concepts in the Bulletin may be applied to any application requiring concurrent connections to different vendors' datastores and databases via ODBC.
This Bulletin is intended for all application developers working who's applications require concurrent connections to different vendors' databases and datastores. It assumes a basic understanding of ODBC connectivity concepts, as well as C/C++ compilation and linking operations.
NOTE: SCOTT user is being used in the example, it is NOT an actual PRODUCTION or Customer Data. It is solely for testing purposes to access data from the Oracle Supplied samples including the ORACLE_SID.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document