Using Perl with an Access Database

[peterv6]

I'm trying to figure out how to use Perl to manipulate (read, update, add, delete, etc.) records in an Access 2000 or 2003 database. I've looked up the DBI package, but it's a little confusing, as I'm quite new to this. What I'm looking for is a simple example of a Perl script that uses DBI to use as a kind of guide. Does anyone know where I might be able to find something like this?
Thanks....

PETERV
Syracuse, NY &
Boston, MA

 

[travs69]

Your kind of asking a very general statement..
in it's simplest

$data_source will be you db.. like DBD:g for postgres or DBD:racle for oracle, and if your not local usual contains a host statement and maybe a port statement like DBD:g;host=yourdbserver;port=1234

$username = well I'm sure you know this one
$pass = password

$statement can be any SQL statement you want..
$statement = "drop table x"
$statement = "select id,firstname,last from userlist"

@row_ary will contain your data if there something returned..

This doesn't really show you how to read data back out..
use DBI;
$dbh = DBI->connect($data_source, $username, $pass);
$sth = $dbh->prepare($statement);
$sth->execute;
@row_ary = $sth->fetchrow_array;
$dbh->disconnect;

 

[travs69]

oops.. I added reading.. so ignore that "This doesn't really show you how to read data back out.." statement.. how come we don't have a edit button here anyway?

 

[peterv6]

I know it's a general question, that was the intent. The information you provided is helpful. You mentioned postgres & oracle databases, but I need to know if this can be done for ACCESS databases, and if so, how to connect to one.

PETERV
Syracuse, NY &
Boston, MA

 

[travs69]

http://search.cpan.org/~jzucker/DBD-CSV-0.22/lib/DBD/CSV.pm

Check that our for the DBD you will need to use

 

[dmazzini]

Hi

You can use as well Win32::ODBC module.

There are several examples on the net.

Here an interesting link:

http://www.codeproject.com/books/1578700671.asp

Cheers




dmazzini
GSM System and Telecomm Consultant

 

[brigmar]

Use the DBD::ODBC module to talk to the Access Database

http://search.cpan.org/~jurl/DBD-ODBC-1.13/ODBC.pm

The DBD modules are the 'device drivers' for DBI.

An example of somebody's solution to their own problem:

http://www.tek-tips.com/viewthread.cfm?qid=1365047&page=1