data acess pages not displaying data over the internet in 3-teir m

[cesemj]

Hello,

NOTE: My test were performed on a local machine and a remote system.

Test #1
******
I receive an "Internet Server Error" error message when I opened a
three-tier data access page with a pivot table and graph chart bound to the
pivot table. The page works fine in two-tier mode.

The pages are opened by clicking on a mainmenu.asp page. The mainmenu page
is located in C:\Inetpub\wwwroot. The links on the mainmenu point to the
DAPs located in the same directory.

System: XP PRO


http://support.microsoft.com/kb/291783 (How to deploy data access pages over
the internet).

IIS: 5.1
IIS
0. Router WANIP forwarded to private IP- Port 80 enabled and open
1. Default WebSiute: port 80
2. Home Directory: c:\inetpub\wwwroot

DAP Connection string: Data Source= C:\Inetpub\webdb\2000.mdb
DAP Connection File: C:\Inetpub\wwwroot\2000.odc
DAP Page Location: C:\Inetpub\wwwroot
DB location: C:\Inetpub\webdb
DAP UseRemoteProvider: True


Test #2
******
I received the following message when I tried to pen the DAP “error occured
trying to use "Query or table bound to the DAP" Check to see that the object
exists. The only changes I mad are:

System: XP PRO
IIS: 5.1
**DAP Connection string: Data Source= \\Server Name\Share\2000.mdb
**DAP Connection File: C:\Inetpub\wwwroot\2000.odc
Inside the ODC file: \\Server Name\Share\2000.mdb
DAP Page Location: C:\Inetpub\wwwroot
DB location: C:\Inetpub\webdb
DAP UseRemoteProvider: True


Any Ideas?