This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C3F7A4.B9781DE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Now I know this code works on IIS5.0, trying it on a Windows2003 server =
(IIS6) I get this lovely error which I can not trace, I think it's =
something either on IIS6 or the server but any suggestions welcome....
On loading the update page I get the error...
Database Results Wizard Error
The operation failed. If this continues, please contact your server =
administrator.
The SQL code is UPDATE t_deeds_main SET deed_no=3D'::deed_no::' WHERE =
id=3D::id::
As I say, works fine on IIS5, and I can view asp pages OK on IIS6 but =
adding a custom query just throws it.
Any help appreciated.
Setup:- FP2003, IIS6, SQL2000SP2 (SQL and IIS on separate boxes).
------=_NextPart_000_0008_01C3F7A4.B9781DE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff background=3D"">
<DIV><FONT face=3DArial size=3D2>Now I know this code works on IIS5.0, =
trying it on=20
a Windows2003 server (IIS6) I get this lovely error which I can not =
trace, I=20
think it's something either on IIS6 or the server but any suggestions=20
welcome....<BR><BR>On loading the update page I get the=20
error...<BR><BR><STRONG>Database Results Wizard Error<BR>The operation =
failed.=20
If this continues, please contact your server=20
administrator.</STRONG></FONT></DIV>
<DIV><STRONG><FONT face=3DArial size=3D2></FONT></STRONG> </DIV>
<DIV><FONT face=3DArial size=3D2>The SQL code is <STRONG>UPDATE =
t_deeds_main SET=20
deed_no=3D'::deed_no::' WHERE id=3D::id::</STRONG></FONT></DIV>
<DIV><STRONG><FONT face=3DArial size=3D2></FONT></STRONG> </DIV>
<DIV><FONT face=3DArial size=3D2>As I say, works fine on IIS5, and I can =
view asp=20
pages OK on IIS6 but adding a custom query just throws it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any help appreciated.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Setup:- FP2003, IIS6, SQL2000SP2 (SQL =
and IIS on=20
separate boxes).</FONT></DIV></BODY></HTML>
------=_NextPart_000_0008_01C3F7A4.B9781DE0--