ARGHH: ADO - Access97 -> fastest provider supporting connection pool 
Author Message
 ARGHH: ADO - Access97 -> fastest provider supporting connection pool

Which provider in particular?
OLEDB ODBC?
OLEDB Jet?

Performance is priority number 1, however I want to keep the ADO
mechanism because we may switch to SQL Server in the future.

Which ConnectionString then, so that I can achieve connection pooling?

If I use the OLEDB Jet provider, I then get an error executing a stored
procedure (it requires some sort of PROCEDURE keyword in the SQL
instead).

I just want to get it right for the fastest execution and I also want to
use a connection pool.

If someone had experience in all this, that would REALLY help.

Yann.



Mon, 03 Dec 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Release ADO connection from a connection pool

2. ODBC Connection Pooling Vs OLE DB Resource Pooling

3. ODBC Connection Pooling Vs OLE DB Resource Pooling

4. ADO Connection Pooling in VB COM Component

5. ADO Connection (resource) pooling with COM+ transactions

6. connection pooling using ADO and VB5

7. ADO pooling or scoping connection ?

8. MDAC & ADO.Net Connection Pooling

9. ADO Connection Pooling & SQL Server : wrong behavior

10. Connection Pooling in ADO?

11. ADO Connection (resource) pooling with COM+ transactions

12. ADO 2.5 connection pooling

 

 
Powered by phpBB® Forum Software