FP2002 - Database editor...

[Stephan]

Hello, I use frontpage 2002. Using the "database
interface wizard" I created the needed files to update
the database. When I go to edit a record, I'm getting
this error messare just after I click "ok":

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

I recreated the interface 3 times with same result.

Thanks

 

[Mettá]

What system are you running? - Have you applied Office SP3 update - If so
this may be the cause.

M

 

[Guest]

Yes I have sp3 installed. I'm running winXP pro. 1GB or
RAM 1.7Ghz.

Thanks Stephan

 

[Mettá]

What is your sql to update the db?

SP3 seems to have caused DISTINCT to fail also field names and attributes
seem to have become over sensitive inc ID and Date fields etc.

Prior to SP3 something like the two examples below worked fine as custom
DRW, post SP3 they fails with the same message you are getting

UPDATE tTABLE
Set TypeX='::TypeX::',Name1='::Name1::',Quals1='::Quals1::'
WHERE idw=::idw::

OR


DELETE DISTINCT from tTABLE
WHERE Idw=::Idw:: and Name1='::Name1::'

I have been trying to find a solution for some time without hand coding.
Someone else might have an answer...

M

 

[Andrew Murray]

how does SP3 effect a web page on a web server i.e completely separate machine
from your own.....

 

[Mettá]

I wish I knew, how SP3 causes this problem, my guess is something around
security has got screwed, however, Paul E Bushnell's post dated 31/03/04
claims to have a fix - if you have backed up data matching the fpdbrgn1.inc
file it will fix the problem - I have not tried this yet.

M

 

[Dan]

What about those of us who don't have a backup of that file? Will any fpdbrgn1.inc work as long as it is pre SP3?


----- Mettá wrote: ----

I wish I knew, how SP3 causes this problem, my guess is something aroun
security has got screwed, however, Paul E Bushnell's post dated 31/03/0
claims to have a fix - if you have backed up data matching the fpdbrgn1.in
file it will fix the problem - I have not tried this yet

 

[Kathleen Anderson [MVP - FP]]

The discussion in this forum:
http://www.frontpagewebmaster.com/m-175524/tm.htm includes a link to
download the files that you need.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Neil Imrie]

I experienced the same problem. I have been trying to fix
it for 2 weeks. I though my host had changed something.

So I went to a backup of fpdbrgn1.inc which is VASTLY
different:

New version fpdbrgn1.inc 17,303 bytes
Old version fpdbrgn1.inc 8,217 bytes

Plugged in the old version and everthing was okay.

Neil

-----Original Message-----
What about those of us who don't have a backup of that

file? Will any fpdbrgn1.inc work as long as it is pre
SP3?