Perl and MS Access

[circuitjump]

I'm trying to connect a perl script to an access DB

This is the code for the connection

open(INF,"$/mainstreet/Htdocs/data/data.mdb") ¦¦ dienice("Can't open data.mdb: $! \n");

I don't think I'm doing the right thing here, so may I get a little bit of help, please :)

Thanks

[gethan]

I don't know if there is an easier way than this but heres what I did... (ages ago)

1) Register the access db as an OBDC database
2) Use the ODBC module

Heres a snippit.

use Win32::ODBC;
$dbh = DbConnect("DBNAME");

[circuitjump]

Thanks gethan

I'll try it out

[littleman]

You could also use DBD::ODBC [dbi.symbolstone.org] which would make porting the script easier if you ever decide to use a different database backend.