DBI's and DBD's.... where to obtain for download

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

Hi Monks,

I am brand spanking new to PERL and have a few questions regarding DBI's and DBD's. We are (my colleague and I) exploring options as far as which database and operating system to use on a project. My questions are related to DBI and DBD's: (The DB's we are considering are MS Access, MySQL and SqlServer:

Are the DBI's and DBD's portable or does each database have it's own unique DBI/DBD combination ??
Where can I obtain downloads of the DBI/DBD files ???

Thanks in advance.... if you wish to email please send to michaeltoth@yahoo.com

Mike

Edited: ~Mon Aug 19 18:52:55 2002 (GMT) by footpad: Added HTML formatting tags.

Comment on DBI's and DBD's.... where to obtain for download

Replies are listed 'Best First'.
Re: DBI's and DBD's.... where to obtain for download by metadatum (Scribe) on Aug 19, 2002 at 18:13 UTC
DBI is the portability layer, DBD's are the database specific drivers. Also see dbi.perl.org . CPAN is your friend. See search.cpan.org	[reply]
Re: DBI's and DBD's.... where to obtain for download by krisahoch (Deacon) on Aug 19, 2002 at 19:02 UTC
Hi Mike! This comment goes a little beyond the scope of your question, but I would like to suggest it anyway. Try using MySQL. It's documentation is well maintained and even has a technical section on the MySQL Perl API. As for drivers, I agree that CPAN is your friend. There is both a commercial and free version of MySQL Hope this helps Kristofer Hoch This node is a correction waiting for Abigail-II to happen	[reply]
Re: DBI's and DBD's.... where to obtain for download by lachoy (Parson) on Aug 19, 2002 at 20:23 UTC
It sounds like you're on Win32. You can get started quickly by installing the ActivePerl distribution from ActiveState, then running: c:\ppm PPM> install DBI ... PPM> install DBD-ODBC You'll then be able to access any of your databases for which you have an ODBC System DSN. If later you decide on one of the databases that has a more direct driver (e.g., DBD::mysql or DBD::Pg), then you can install that and swap the driver in very easily. Once you've got these installed, check out the various DBI references around here or elsewhere. Chris M-x auto-bs-mode	[reply]