sprakash has asked for the wisdom of the Perl Monks concerning the following question:

Hi! I recently started playing around with Perl and have just registered with a host who has support for access database. My problem is that they did give me some code but they say it will work using ASP (code is below):
strPathInfo = Request.Servervariables("APPL_PHYSICAL_PATH") strConnection="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & strPat +hInfo & "\_private\db1.mdb" Set objRecset=Server.CreateObject("ADODB.Connection") objRecset.open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & serve +r.mappath(".") & "\_private\db1" sqlstatement="SELECT email, password FROM surya" objRecset.Execute($sqlstatement) objRecset.Close set objRecset=Nothing
Thing is that I need the code Perl which does the same thing as above or any other advice you all can give me. I would really appreciate it. Thanks, SP

Replies are listed 'Best First'.
Re: Need help accessing Access database using Perl......
by neophyte (Curate) on Dec 13, 2000 at 10:28 UTC
    Not much to add to those on site links, but you might want to check out Win32::ODBC and the stuff on it on roth.net.

    neophyte

Re: Need help accessing Access database using Perl......
by Anonymous Monk on Dec 13, 2000 at 10:02 UTC
      (I promise that's the last time I post something as anon. I've saved a cookie & everything).