That, unfortunately, can be a bad message because of the way that DBD::ODBC
handles opening the database. What's happening is that DBI can't open the
database using the "DSN-less" style open (SQLDriverConnect) which fails and
then tries to call SQLConnect, which expects a 32? character or less DSN. I
hope to make this better in the future...
In the mean time, I'm going to guess that this may work from the command
line and not from the CGI. If that's not the case, this may or may not
apply.
Check the share name "fssdata" and ensure it's accessible from the username
starting the web service (make sure the web server is not being started as
local system, either, as that will have NO access to the network).
IF that doesn't work, set a trace file and set the DBI tracing level to 4
(or above) and post it back here.
Jeff
>
> 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
>
>
