Siegfried Heintze wrote:
Is there an example somewhere of accessing an MSAccess database from a SuSE
or RedHat machine via perl DBI?
Here is what I am presently using with ActiveState Perl to access the
MSAccess database on windows:
my $dbh = DBI->connect("dbi:ODBC:driver={Microsoft Access Driver
(*.mdb)};dbq=c:\\database.mdb","Admin","") or die "$DBI::errstr\\n";
What would I change to make this work on SuSE or RedHat?
Thanks,
Siegfried
Enabling ODBC support in Perl with Perl DBI and DBD::ODBC
http://www.easysoft.com/developer/languages/perl/dbi_dbd_odbc.html
Perl DBI/DBD::ODBC Tutorial Part 1 - Drivers, Data Sources and Connection
http://www.easysoft.com/developer/languages/perl/dbd_odbc_tutorial_part_1.html
Perl DBI/DBD::ODBC Tutorial Part 2 - Introduction to retrieving data
from your database.
http://www.easysoft.com/developer/languages/perl/dbd_odbc_tutorial_part_2.html
Perl DBI/DBD::ODBC Tutorial Part 3 - Connecting Perl on UNIX or Linux to
Microsoft SQL Server
http://www.easysoft.com/developer/languages/perl/sql_server_unix_tutorial.html
Although this is specifically for sql server it works for MS Access too.
Martin
