connect from web server to remote database
I have created an asp page that makes a database connection through DSN (I have also tested with a connection string) to connect to a database on another server, which happens to be a Novell box.
The database has no ID or password set for it. It works fine . . . UNTIL . . . we turn off anonymous login for that directory on the web server. Then anytime we try to connect to that asp page we get the :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 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.
If we turn back on anonymous login it works fine once more.
If I put a copy of the database on the web server (above the web root) it all functions well regardless of the anonymity setting. It is just a problem when the database resides in a different box.
Any ideas for a solution to connecting to a remote DB?