On Sun, 2 Nov 1997 [EMAIL PROTECTED] wrote:
> >Im trying to connect a perl program to a mysql database on my home computer
> >running win 2k. I can connect, but i have no idea of how to extract the
> >information out of tables using perl. I have a book about SQL, but it never
> >mentions programming or perl. If anyone could point me to a good tutorial,
> >or give me a few pointers I would be greatly appreciative.
On Windows 2000, you have several choices. You can use an ODBC or ADO
connection to your database through the Win32 modules (see
http://www.roth.net/perl/odbc/), or you can use Perl's Database Interface
(DBI), for which there are drivers available for MySQL. Take a look at
http://dbi.symbolstone.org/index.html for more information on DBI. DBI is
very similar to ODBC & JDBC, and enables you to create connections to
database servers through a generic interface that uses a 'driver' for the
particualr server you want to connect to. There's also an O'Reilly book
on the DBI (although it needs to be updated -- rumour has it this is in
the works). There is also a mailing list (of course) for DBI programming,
and many of the people on this list are on that one.
-- Brett
Brett W. McCoy
Software Engineer
Broadsoft, Inc.
240-364-5225
[EMAIL PROTECTED]
