Data Access Problem

[Guest]

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

 

[Kathleen Anderson [MVP - FrontPage]]

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--

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

 

[Guest]

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

 

[Guest]

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

private bool _showDebug = false;

Rocky

 

[Guest]

Can anyone help?

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

private bool _showDebug = false;

Rocky

 

[Kathleen Anderson [MVP - FrontPage]]

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

 

[Guest]

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 [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

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

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