This will definitely not work. As Jenda pointed out, a URL is a no-no when making a dB connection, a UNC is acceptable as long as the IUSER_ has access to the dir, if it's a local dir then the permissions need to be modified if the path is outside the webroot, if the dB is in the webroot then by default the permissions are already set for read.
If the dB is on a mapped or shared dir outside the local server, then you need to set the remote server up with a emulated IUSER_ account, the details to do this is here; http://support.microsoft.com/default.aspx?scid=kb;EN-US;q184566 But definitely not a URL... Mark ----- Original Message ----- From: "Jenda Krynicky" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 4:30 AM Subject: Re: Dsnless Question > From: Mark Bergeron <[EMAIL PROTECTED]> > > > Does anyone think this will work? > > > > snippit ############## > > > > my $dsn = 'driver=Microsoft Access Driver > > (*.mdb);dbq=http://giglmon.tripod.com/cgi-bin/postit.mdb'; $dbh = > > DBI->connect( q{DBI:ODBC:$dsn} ) > > > > ###################### > > > > the question is in the dbq string. Does it have to be local? > > Well ... if the script runs under a network account that has enought > permissions it can be a network path. But it must be a WINDOWS > network math. Either a mapped disk or a UNC. Definitely not a > URL (web address). But it's much better if the MDB file is local. > > Another thing ... it's silly to put the database file into cgi-bin. It > should reside in a directory that's NOT directly accessible via web. > > Another thing is ... the user under which the script will run will most > probably need a write access to the DIRECTORY that contains the > MDB. At least it used to need. The Access driver needs to create a > lock file in that directory. > > Jenda > > =========== [EMAIL PROTECTED] == http://Jenda.Krynicky.cz ========== > There is a reason for living. There must be. I've seen it somewhere. > It's just that in the mess on my table ... and in my brain. > I can't find it. > --- me > _______________________________________________ > Perl-Win32-Web mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > _______________________________________________ Perl-Win32-Web mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
