Sybase and SQL Anywhere ODBC drivers and multiple threads

Sybase and SQL Anywhere ODBC drivers and multiple threads

Post by Fuzz » Tue, 18 May 1999 04:00:00



Hi,

Does anyone know if the Sybase ODBC drivers and the SQL Anywhere ODBC
drivers are multi-thread capable?  If so, are they safe?  How many
concurrent threads have people tried running?

Ciao
Fuzzy
:-)

 
 
 

Sybase and SQL Anywhere ODBC drivers and multiple threads

Post by leotoh.. » Tue, 01 Jun 1999 04:00:00


Here is a response that Sybase provided to someone else's identical
question:

"The SQL Anywhere ODBC driver is thread safe. What this means is that
you can have many connections with many threads accessing those
connections simultaneously. One important rule must be followed:

Two threads cannot simultaneously access the same connection.

Implentation wise this means that you need one connection for every
active thread. Connections in SQL Anywhere do not have thread affinity
(thread affinity means a connection can only be used on the same thread
that created it) so you can use a connection pool to hand off unused
connections to any thread that requires it."

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.