ODBC Error

[qztm51]

I hope I have this in the right place...

I am receiving the following error when my asp page tries to access an Excel file being used as a database.

[Microsoft][ODBC Excel Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

The environment is as follows:
Server A - web server
Server B - file server

Server A has a drive mapped to a shared directory on Server B where the excel file is located.

Server A has a system DSN pointing to the excel file.

When I am logged into the web server (Server A) with an account that has administrative rights on the network, the asp page performs as desired. If I log off of the web server (Server A), the error above occurs on the page. If I copy the excel file to the c: drive of the web server, and set up the DSN to point to the file on the c: drive of the web server (Server A), the asp page performs as desired. The permissions on the excel file when it is on the file server (Server B) are set with the Everyone group having read, write access. Does anyone have any thoughts on this?

 

[qztm51]

FYI - I figured it out - when the DSNs were orignially created, the workbook path was set using a mapped network drive for the path instead of the UNC path.