Currently our Intranet default.asp runs on our primary web server. The folder containing all needed files is copied to a backup web server.
When trying to run the same default.asp from the backup web server, we get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Visual FoxPro Driver]File 'core.dbf' does not exist.
/birth.asp, line 28
When setting up the backup web server, we did the following:
1. Copied all ODBC set up to match exactly with the primary web server.
2. All paths for the DSN are explicite, i.e. \\application-file server\shared drive\folder
3. Created IUSR_ backup web server and made sure that this user was in the top security group just like the IUSR_ primary web server.
4. Both are Windows 2003 Servers.
What are we missing on the set up of our backup web server?
Note: Pages are on the local computer. The ones that do not require an ODBC run without issues on the backup server.
None the solutions that I have found have addressed this issue of running on one machine but not the other.
Your help will be greatly appreciated,
Darlene