
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.