Hi,
I hope other people have been successful at getting CGI scripts running that
access MS Access because I haven't. Here is a snippet of code that I am
trying to get to work:
#!d:/perl/bin/perl -wT
use DBI;
my $dsn = "driver=Microsoft Access Driver
(*.mdb);dbq=\\\\nrent01\\fssdata\\Roster03b.mdb";
my $dbh = DBI->connect("DBI:ODBC:$dsn","admin","xyzzy") ||
print "<BR>Error Opening Database: $DBI::errstr\n";
But I get this message:
Error Opening Database: [Microsoft][ODBC Driver Manager] Invalid string or
buffer length (SQL-S1090)(DBD: db_login/SQLConnect err=-1)
Am I doing something amazingly stupid and just can't see it? Is there a
better way to get to an MS Access database?
Please help!
Thanks,
Pete MacGown