Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

What's the difference between DBD::ADO and DBD::ODBC, especially in terms of locking?

I'm using ODBC connections to an Access database on IIS (don't laugh! It's to interface a commercial product a client is using). Problem is that Jet/ODBC cannot deal with multiple processes on the same machine accessing the same database, so it locks all other connections out of the database.

Would using ADO instead solve this problem? Or is ADO affected by the same limitations?

For that matter, is there any decent documentation on using DBD::ADO? The default documentation isn't much better than what h2xs generates.

  • Comment on What's the difference between DBD::ADO and DBD::ODBC

Replies are listed 'Best First'.
Re: What's the difference between DBD::ADO and DBD::ODBC
by John M. Dlugosz (Monsignor) on Aug 30, 2001 at 23:07 UTC
    I had crashing troubles with ADO, and switched back to ODBC. There is a generic implementation of DBD::ADO that calls ODBC, so that would have to be a subset and subject to the same limitations.