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.
|
|---|
| 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 |