in reply to ODBC Cannot Connect

sounds like the webserver runs the script as another user than the shell, i.e. too little rights on the UNC share for that web user. If you use Internet Information server, the script normally runs as IUSR_$servername. Or if you use a connection created by Window's ODBC-Manager, you have to use a System-DSN, not a User-DSN

Best regards,
perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8.8.8.32.11.32"

Replies are listed 'Best First'.
Re^2: ODBC Cannot Connect
by roscomputing (Initiate) on Feb 02, 2006 at 02:46 UTC
    I think you may be partially right on this issue. However, I have setup the ODBC DSN as a System DSN for Microsoft FoxPro. When I manually go into Excel and try to open the database through the ODBC DSN, I can open it fine. But when the Perl script begins, I get "Cannot Connect." When I copy the database to the same web server machine, I can also open it locally through the ODBC driver with no problem. I am running this on an Apache web server. Is there perhaps a default User name that the apache web server uses when attempting to connect over the network? thanks, bill
[reply]

In Section Seekers of Perl Wisdom