Error occurs in IIS 5 and Not IIS4

[Ken Schaefer]

Suggest you attempt to Response.Write() the SQL statement you are sending to
the database:

Response.Write(strSQL)
Response.End

Cheers
Ken

"Reg Dwyer" <reg.dwyer@ausesales.com.au> wrote in message
news:01f901c35a20$9af38610$a501280a@phx.gbl...
: I hope this has been previously answered, however there is
: probably a really simple answer.
:
: The error I receive is from the IIS5 server is
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
: date in query expression 'procind = 4912101852003#hazard'.
: assessment-new.asp, line 148
:
: This is generated from a referring page which has the
: following code
:
: MM_editRedirectUrl = "assessment-new.asp?procind=" +
: Request.QueryString("procind") + "#hazard"
:
: The code works reliably in IIS4 however it generates the
: above message in IIS5,
:
: The intention is to have the referrer page refresh the
: called page and position the screen at the appropriate
: place.
:
: Any help on a workaround ??
:
: regards
:
: Reg
:
:
:

[Reg Dwyer]

Hi Ken,

Thanks for the reply, the problem seems to be more the
resolution of the '#' character when the address is
resolved at the mater page. Even attempting to pass '#'
via the RequestQueryString(URL) has the server faling to
resolve.

This seems to be a change from the IIS4 version to IIS5.
The scripts work fine in IIS4 and display correctly, IIS5
fails

Reg

>-----Original Message-----
>Suggest you attempt to Response.Write() the SQL statement

you are sending to

>the database:
>
>Response.Write(strSQL)
>Response.End
>
>Cheers
>Ken
>
>"Reg Dwyer" <reg.dwyer@ausesales.com.au> wrote in message
>news:01f901c35a20$9af38610$a501280a@phx.gbl...
>: I hope this has been previously answered, however there

is

>: probably a really simple answer.
>:
>: The error I receive is from the IIS5 server is
>: Error Type:
>: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>: [Microsoft][ODBC Microsoft Access Driver] Syntax error

in

>: date in query expression 'procind =

4912101852003#hazard'.

>: assessment-new.asp, line 148
>:
>: This is generated from a referring page which has the
>: following code
>:
>: MM_editRedirectUrl = "assessment-new.asp?procind=" +
>: Request.QueryString("procind") + "#hazard"
>:
>: The code works reliably in IIS4 however it generates the
>: above message in IIS5,
>:
>: The intention is to have the referrer page refresh the
>: called page and position the screen at the appropriate
>: place.
>:
>: Any help on a workaround ??
>:
>: regards
>:
>: Reg
>:
>:
>:
>
>
>.
>

[Ken Schaefer]

Hi,

The error that you are posting is caused because you have an invalid SQL
statement that you are sending to the database.

Passing # in the URL should not present any problems, as long as it is an
anchor name. However, if you are passing it as part of the query data, then
you need to use Server.URLEncode() on it.

That said, I don't understand what you are talking about when you say "the
server is failing to resolve...". The URL is being resolved. Somehow you are
trying to put this data into an SQL statement, and you are trying to send
that to the database, and the database is saying that the SQL statement is
invalid.

[url]www.adopenstatic.com/faq/80040e14.asp[/url]
for examples.

As I suggested before:

<%
Response.Write(strSQL)
Response.End
%>

and post the output to the newsgroup.

Cheers
Ken

"Reg Dwyer" <reg.dwyer@ausesales.com.au> wrote in message
news:036501c35a4c$ebaf1480$a601280a@phx.gbl...
: Hi Ken,
:
: Thanks for the reply, the problem seems to be more the
: resolution of the '#' character when the address is
: resolved at the mater page. Even attempting to pass '#'
: via the RequestQueryString(URL) has the server faling to
: resolve.
:
: This seems to be a change from the IIS4 version to IIS5.
: The scripts work fine in IIS4 and display correctly, IIS5
: fails
:
: Reg
:
:
: >-----Original Message-----
: >Suggest you attempt to Response.Write() the SQL statement
: you are sending to
: >the database:
: >
: >Response.Write(strSQL)
: >Response.End
: >
: >Cheers
: >Ken
: >
: >"Reg Dwyer" <reg.dwyer@ausesales.com.au> wrote in message
: >news:01f901c35a20$9af38610$a501280a@phx.gbl...
: >: I hope this has been previously answered, however there
: is
: >: probably a really simple answer.
: >:
: >: The error I receive is from the IIS5 server is
: >: Error Type:
: >: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
: >: [Microsoft][ODBC Microsoft Access Driver] Syntax error
: in
: >: date in query expression 'procind =
: 4912101852003#hazard'.
: >: assessment-new.asp, line 148
: >:
: >: This is generated from a referring page which has the
: >: following code
: >:
: >: MM_editRedirectUrl = "assessment-new.asp?procind=" +
: >: Request.QueryString("procind") + "#hazard"
: >:
: >: The code works reliably in IIS4 however it generates the
: >: above message in IIS5,
: >:
: >: The intention is to have the referrer page refresh the
: >: called page and position the screen at the appropriate
: >: place.
: >:
: >: Any help on a workaround ??
: >:
: >: regards
: >:
: >: Reg
: >:
: >:
: >:
: >
: >
: >.
: >