At 01:56 PM 7/27/2001, you wrote:
>** Using ActiveState Build 522 (NT)
>
>I'm trying to decide on using DBI or an ODBC connection for moving data
>into or out of MS ACCESS 97 (or 2000) and back into the ACCESS table
>[yep, or change inside table].
>
>Given I need to perform all the usual extract and append, etc. tasks, do
>any of you have suggestions or pointers on which to use ? Other life
>lessons also appreciated ...
>
>TIA,
>Steve Few
Even if you use ODBC, you are still going to be using DBI from Perl.
ODBC is a low-level API for connecting to databases, and is designed to be
accessible from many a programming language. To my knowledge, there's no
module for using ODBC from Perl, without using DBI.
If you are going to do any amount of database programming using Perl, I
would use DBI, rather than finding some special-purpose ODBC module. The
beauty if DBI is that no matter what the underlying interface is (ODBC,
Oracle OCI, sockets) it looks the same from the application programmer's
side of DBI. Many times at work I use some very simple code to work with
an Oracle, an Access, and a MySQL database all from within the same
program. Once I have connected to these DB's, I just have some DBI
database handle objects lying around, and to DBI, they all look the
same. I can run the same queries on them and such, and it makes life
pretty easy.
Plus there's a really good DBI book out there. Take a look at it if you
are jumping into a decent size database project.
Have fun,
Sean.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
