Jeff, You are correct that it does work from the command line. The share name "fssdata" share is accessible to me, but just to verify that something funky isn't going on, I copied the mdb file over to the web server and tried to run it from there. I still got the same message. As a newbie to perl and apache, I took on a task of trying to set up a web application to cut my teeth. The existing application has proven all too successful and the user population has outgrown MS Access. An Oracle server is in the works, but until then, I need to get it up and running using MS Access. I Know that this question is perl-101, but, given my inexperience with perl, what do you mean by "...set a trace file and set the DBI tracing level to 4..."? Thanks, Pete MacGown
-----Original Message----- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 9:22 PM To: MacGown, Peter; [EMAIL PROTECTED] Subject: RE: MS Access/CGI/Apache on WinNT questions 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 > >
