DRW Error if ODBC is used pointed to a File Server

[Pat]

I have a asp page using DRW to display a report. The page returns results
properly if the ODBC on the web server is pointing to a local database. If I
move the MDB to a file server and update the ODBC, I get the following error
on the client.

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

I know the ODBC is working properly, verified with Excel to read data. I
have verified the ODBC in frontpage in the site options. I have googled the
IIS config and not found anything to help. The IIS server is using an
application pool with an account that has access to the file on the server.
I have even tried to include the everyone group in the ACL on the file.

Any help is appreciated.

 

[Ronx]

As far as I know, an Access database has to be on the same machine as
the web site that uses it.
An MS SQL Server database can be located anywhere.

Using Excel to access the database is not the same as using web pages.

 

[Pat]

I used Excel just to confirm the ODBC was setup properly. If the MDB has to
be on the local disks, what options do I have to access a database that is on
a remote file server? The database needs to be on the file server because it
handles transactions. I just need to create some web based reports.

 

[Thomas A. Rowe]

Then you will have to use MS SQL server or MySQL server. Also the when using Access as a database,
it can not be open with Access and access via web page at the same time, as the application will
lock the file.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================