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

This may not be a strictly perl problem, but I am running a CGI on a Windows 2003 environment, and have difficulty logging into an MS Access ODBC. I've tried both Win32::ODBC and DBI, can't log in. I've tried changing various settings on the control panel.

Does anyone here know how to give the IUSR account the right permissions?

Replies are listed 'Best First'.
Re: CGI login problem
by bart (Canon) on Apr 05, 2004 at 21:02 UTC
    Either make it a system-DSN, or a DSN for the user the CGI runs under. (Whatever it may be...) For the rest of the discussion, I'll assume use of DBI+DBD::ODBC, only...

    You might try to use a DSN-less connection with a connection string for DBI, like: 

    dbi:ODBC:driver=Microsoft Access Driver (*.mdb);dbq=c:\full\path\to\da
+tabase.mdb

    [download]
    The full path (required!) for the database must be using backslashes, not forward slashes, as a directory separator.

    Oh, and the username/password must be given in the connect call, as 2nd and 3rd parameters — use empty strings if none.

[reply]
[d/l]
      It worked!! Outstanding, thank you.
[reply]

Back to Seekers of Perl Wisdom