Data Access Problem

R

RockyM

I recently tried to create a website using the built in database interface
wizard. I chose ASP.NET and allowed FP2003 to create an Access database. The
wizard appears to complete it's task properly and creates a website.

I then uploaded the website to my server (IIS 6.0 on Windows Server 2003).
On browsing the site, the pages appear to work properly, except that when I
try to add, edit, or delete a record, I receive an error message stating:
The operation failed. If this continues, please contact your server
administrator.

Since I haven't made any changes to any of the pages, I don't understand why
this error is coming up. Is there a problem with FP or could it be something
on my server?

Any help would be appreciated.

Rocky
 
R

RockyM

I looked under /_fpclass/ and don't have the file mentioned. Aren't .inc
files used for ASP? I'm using ASP.NET and have the following files in that
directory...

dbquery.ascx
dbregion.ascx
fpdbnet.cs
fputil.cs

Rocky
 
R

RockyM

The dbquery.ascx file has the following line - should I change it to "true"?

private bool _showDebug = false;

Rocky
 
R

RockyM

The error message now reads:
Debug messages:
Update unable to find TableMapping['Table'] or DataTable 'Table'.

Keep in mind that this is a template website - I haven't made any
modifications at all.

Rocky
 
K

Kathleen Anderson [MVP - FrontPage]

Post your SQL please.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx


RockyM said:
The error message now reads:
Debug messages:
Update unable to find TableMapping['Table'] or DataTable 'Table'.

Keep in mind that this is a template website - I haven't made any
modifications at all.

Rocky



Kathleen Anderson said:
Hi Rocky:
I haven't run the DBRW using ASP.NET, so I can't give you any
advice. It probably wouldn't hurt, though, to change it to "true"
and see what happens.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx
Click to expand...
Click to expand...
 
Top