This is Interesting: Free Magazines for Graphics designers and webmasters
Home > Archive > Front Page > May 2004 > FP2002 - Database editor...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
FP2002 - Database editor...
|
|
| Stephan 2004-05-14, 12:11 am |
| 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
| |
|
| What system are you running? - Have you applied Office SP3 update - If so
this may be the cause.
M
"Stephan" <anonymous@discussions.microsoft.com> wrote in message
news:ce8e01c43961$29b36490$a501280a@phx.gbl...
> 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
| |
|
| Yes I have sp3 installed. I'm running winXP pro. 1GB or
RAM 1.7Ghz.
Thanks Stephan
>-----Original Message-----
>What system are you running? - Have you applied Office
SP3 update - If so
>this may be the cause.
>
>M
>
>"Stephan" <anonymous@discussions.microsoft.com> wrote in
message
>news:ce8e01c43961$29b36490$a501280a@phx.gbl...
>
>
>.
>
| |
|
| 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
<anonymous@discussions.microsoft.com> wrote in message
news:cffb01c439b0$dc3d03b0$a401280a@phx.gbl...[color=darkred]
> Yes I have sp3 installed. I'm running winXP pro. 1GB or
> RAM 1.7Ghz.
>
> Thanks Stephan
>
> SP3 update - If so
> message
| |
| Andrew Murray 2004-05-14, 10:29 pm |
| how does SP3 effect a web page on a web server i.e completely separate machine
from your own.....
"Mettá" <metta@re-movethis-metta.org.uk> wrote in message
news:u6ta5KbOEHA.2164@TK2MSFTNGP12.phx.gbl...
> 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
>
>
> <anonymous@discussions.microsoft.com> wrote in message
> news:cffb01c439b0$dc3d03b0$a401280a@phx.gbl...
>
>
| |
|
| 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
"Andrew Murray" <SPAMadBUSTERmurray@iinet.net.au> wrote in message
news:40a57371$0$16580$5a62ac22@freenews.iinet.net.au...
> how does SP3 effect a web page on a web server i.e completely separate
machine
> from your own.....
>
>
>
>
> "Mettá" <metta@re-movethis-metta.org.uk> wrote in message
> news:u6ta5KbOEHA.2164@TK2MSFTNGP12.phx.gbl...
attributes[color=darkred]
>
>
| |
|
| 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 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
"Andrew Murray" <SPAMadBUSTERmurray@iinet.net.au> wrote in message
news:40a57371$0$16580$5a62ac22@freenews.iinet.net.au...
> how does SP3 effect a web page on a web server i.e completely separate
machine[color=darkred]
> from your own.....
> news:u6ta5KbOEHA.2164@TK2MSFTNGP12.phx.gbl...
attributes[color=darkred]
| |
| Kathleen Anderson [MVP - FP] 2004-05-18, 7:38 pm |
| 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/
Dan <anonymous@discussions.microsoft.com> wrote:[color=darkred]
> 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 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
>
>
> "Andrew Murray" <SPAMadBUSTERmurray@iinet.net.au> wrote in
> message news:40a57371$0$16580$5a62ac22@freenews.iinet.net.au...
> separate machine
> and attributes
> fine as custom >> DRW, post SP3 they fails with the same
> message you are getting >>>> UPDATE tTABLE
> hand coding. >> Someone else might have an answer...
| |
| Neil Imrie 2004-05-29, 12:15 pm |
| I experienced the same problem. I have been trying to fix=20
it for 2 weeks. I though my host had changed something.
So I went to a backup of fpdbrgn1.inc which is VASTLY=20
different:
=20
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=20
file? Will any fpdbrgn1.inc work as long as it is pre=20
SP3? =20
>
> =20
> ----- Mett=C3=A1 wrote: -----
> =20
> I wish I knew, how SP3 causes this problem, my guess=20
is something around
> security has got screwed, however, Paul E Bushnell's=20
post dated 31/03/04
> claims to have a fix - if you have backed up data=20
matching the fpdbrgn1.inc
> file it will fix the problem - I have not tried this=20
yet.
> =20
> M
> =20
> =20
> "Andrew Murray" <SPAMadBUSTERmurray@iinet.net.au>=20
wrote in message
> news:40a57371$0$16580
$5a62ac22@freenews.iinet.net.au...
completely separate[color=darkred]
> machine
wrote in message[color=darkred]
field names and[color=darkred]
> attributes
Date fields etc.[color=darkred]
below worked fine as custom[color=darkred]
you are getting[color=darkred]
TypeX=3D'::TypeX::',Name1=3D'::Name1::',Quals1=3D'::Quals1::'[color=darkred]
time without hand coding.[color=darkred]
message[color=darkred]
1GB or[color=darkred]
Office[color=darkred]
<anonymous@discussions.microsoft.com> wrote in[color=darkred]
the "database[color=darkred]
to update[color=darkred]
getting[color=darkred]
please contact[color=darkred]
same result.[color=darkred]
>.
>
|
|
|
| | Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |
|