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

Reply via email to