Hi,
I am wondering how to successfully connect to Microsoft Access database using
DBD::ODBC. Here is the snippet of my code:
.....
my $dbdrive=DBI->install_driver('ODBC');
my $dbn="driver=Microsoft Access Driver (*.mdb);dbq=\\\genethon\\data
drive\\www\\DB\\newgene.mdb";
my $dbh=$dbdrive->connect('dbi:ODBC:$dbn','','')|| die "$DBI::errstr\n";
....
where "genethon" is my PC name and the database file "newgene.mdb" actually locates
under C:\data drive\www\DB.
The error message is "[Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified <SQL-IM002><DBD:db-login/SQLConnect err=-1>"
I am working under win2000. Looking forward to your help! Thanks!
Regards
Haifeng
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Haifeng Liu
Ph.D., Member of Technical Staff
IFL/DS
DSO National Laboratories
20 Science Park Drive
Singapore 118230
Email: [EMAIL PROTECTED]
Tel: (65) 67728220
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
