PC Review


Reply
Thread Tools Rate Thread

Data Access Problem

 
 
=?Utf-8?B?Um9ja3lN?=
Guest
Posts: n/a
 
      4th Apr 2005
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

 
Reply With Quote
 
 
 
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      4th Apr 2005
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


RockyM <(E-Mail Removed)> wrote:
> 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


 
Reply With Quote
 
=?Utf-8?B?Um9ja3lN?=
Guest
Posts: n/a
 
      4th Apr 2005
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




"Kathleen Anderson [MVP - FrontPage]" wrote:

> 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
>
>
> RockyM <(E-Mail Removed)> wrote:
> > 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

>
>

 
Reply With Quote
 
=?Utf-8?B?Um9ja3lN?=
Guest
Posts: n/a
 
      4th Apr 2005
The dbquery.ascx file has the following line - should I change it to "true"?

private bool _showDebug = false;

Rocky




"RockyM" wrote:

> 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
>
>
>
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
> > 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
> >
> >
> > RockyM <(E-Mail Removed)> wrote:
> > > 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

> >
> >

 
Reply With Quote
 
=?Utf-8?B?Um9ja3lN?=
Guest
Posts: n/a
 
      5th Apr 2005
Can anyone help?



"RockyM" wrote:

> The dbquery.ascx file has the following line - should I change it to "true"?
>
> private bool _showDebug = false;
>
> Rocky
>
>
>
>
> "RockyM" wrote:
>
> > 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
> >
> >
> >
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> > > 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
> > >
> > >
> > > RockyM <(E-Mail Removed)> wrote:
> > > > 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
> > >
> > >

 
Reply With Quote
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      5th Apr 2005
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


RockyM <(E-Mail Removed)> wrote:
> Can anyone help?
>
>
>
> "RockyM" wrote:
>
>> The dbquery.ascx file has the following line - should I change it to
>> "true"?
>>
>> private bool _showDebug = false;
>>
>> Rocky
>>
>>
>>
>>
>> "RockyM" wrote:
>>
>>> 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
>>>
>>>
>>>
>>>
>>> "Kathleen Anderson [MVP - FrontPage]" wrote:
>>>
>>>> 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
>>>>
>>>>
>>>> RockyM <(E-Mail Removed)> wrote:
>>>>> 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


 
Reply With Quote
 
=?Utf-8?B?Um9ja3lN?=
Guest
Posts: n/a
 
      5th Apr 2005
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]" wrote:

> 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
>
>
> RockyM <(E-Mail Removed)> wrote:
> > Can anyone help?
> >
> >
> >
> > "RockyM" wrote:
> >
> >> The dbquery.ascx file has the following line - should I change it to
> >> "true"?
> >>
> >> private bool _showDebug = false;
> >>
> >> Rocky
> >>
> >>
> >>
> >>
> >> "RockyM" wrote:
> >>
> >>> 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
> >>>
> >>>
> >>>
> >>>
> >>> "Kathleen Anderson [MVP - FrontPage]" wrote:
> >>>
> >>>> 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
> >>>>
> >>>>
> >>>> RockyM <(E-Mail Removed)> wrote:
> >>>>> 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

>
>

 
Reply With Quote
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      5th Apr 2005
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 <(E-Mail Removed)> wrote:
> 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]" wrote:
>
>> 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
>>
>>
>> RockyM <(E-Mail Removed)> wrote:
>>> Can anyone help?
>>>
>>>
>>>
>>> "RockyM" wrote:
>>>
>>>> The dbquery.ascx file has the following line - should I change it
>>>> to "true"?
>>>>
>>>> private bool _showDebug = false;
>>>>
>>>> Rocky
>>>>
>>>>
>>>>
>>>>
>>>> "RockyM" wrote:
>>>>
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> "Kathleen Anderson [MVP - FrontPage]" wrote:
>>>>>
>>>>>> 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
>>>>>>
>>>>>>
>>>>>> RockyM <(E-Mail Removed)> wrote:
>>>>>>> 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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Memo format field data problem - Data import from Access database AFSSkier Microsoft Excel Programming 0 29th Apr 2009 05:51 PM
Problem Importing records with Date/Time data type into an Access 2007 data table Cillacil Microsoft Access External Data 0 3rd Apr 2009 08:50 PM
Data Access Problem thebison Microsoft ADO .NET 5 8th Apr 2006 01:38 PM
Problem saving Access Form as Data Access Page vpman Microsoft Access Forms 0 7th Apr 2006 05:12 AM
data access component 823718 3 and problem with access 3 tier architecture now Moritz Microsoft Windows 2000 Windows Updates 0 11th Nov 2003 08:48 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:52 PM.