The following tables summarize the threading information available at this time for the drivers. Always consult the readme file for the most up-to-date information as threading information is subject to change with new database transport and server revisions. Currently, the XML driver is the only thread-impaired driver. Refer to "Threading" in the DataDirect Connect Series for ODBC Reference for more information about threading and how to obtain reading information through SQLGetInfo.
Table 3. Threading Information for DataDirect Connect forODBC
Driver
Fully Threaded
Thread Per Connect
Btrieve
X
dBASE
X
DB2 Wire Protocol
X
Informix Wire Protocol
X
Informix
X
MySQL Wire Protocol
X
Oracle Wire Protocol
X
Oracle
X
PostgreSQL Wire Protocol
X
Progress OpenEdge
X
SQL Server Legacy Wire Protocol
X
SQL Server Wire Protocol
X
Sybase Wire Protocol
X
Text
X
Table 4. Threading Information for DataDirect Connect XE forODBC
1 Because Apache HiveServer1 servers do not currently handle multiple connections well, consider using a single Apache HiveServer1 for each connection.