I figured as much. I ran it on IIS and Apache with no success. Just thought someone had figured out a way to pull it off. I'm trying to run a few scripts out of Tripod for my site ( since I don't want to pay hosting fees right now )-8 ) and had tried a few different things. Oh well. Flat files it will have to be.
Thanks guys! -----Original Message----- From: "Mark G. Franz"<[EMAIL PROTECTED]> To: "Jenda Krynicky"<[EMAIL PROTECTED]>, [EMAIL PROTECTED] Date: Mon Mar 04 09:12:33 PST 2002 Subject: Re: Dsnless Question >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 ___________________________________________________ GO.com Mail Get Your Free, Private E-mail at http://mail.go.com _______________________________________________ Perl-Win32-Web mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
