Connection Pooling - Server-side or Client-side

[redtiger23]

Is ODBC connection pooling server-side or client-side?

More specifically, if two client-side applications that are on separate machines access a MySQL database through ODBC, then will both applications have access to the same connection pool on the server?

 

[k5tm]

Since a connection is between a specific client and a specific server, there would seem to be no way a third machine can reuse the connection.

Microsoft FAQ at

http://support.microsoft.com/default.aspx?scid=kb;en-us;169470

Tom Morrison

http://www.liant.com

 

[redtiger23]

I think that you're right that a third machine can not access another machine's connection in ODBC.

However, I beleive that it should be possible. If I remember correctly, then a web server - such as Tomcat that uses JDBC connection pooling - allows clients to reuse a connection that may just have been used by a client on a different machine.

Since the connection is stored on the server, then it should be able to be able to give the connection to any number of clients that it wishes.

I could be wrong, though.