80040e14 Error Message

[Joe Goeke]

I have an ASP site running in IIS 5.0 using ASP 3.0. I am making a SQL call
to a DB2 database on our AS-400. The site has been running fine for 6
months and suddenly I'm getting sporadic 80040e14 errors in the log files.
The log file message is as follows:

2003-11-19 16:32:17 12.35.121.12 - 12.35.121.219 47806 GET /add_item.asp
submit=Order+Sample&item=020440B031&desc=100+Deg+F lat+Machine+Screws&type=Ad
d|80|80040e14|[IBM][iSeries_Access_ODBC_Driver][DB2_UDB]SQL0104_-_Token___wa
s_not_valid._Valid_tokens:_(_+_-_?_:_DAY_RRN_CASE_CAST_CHAR_DAYS_HOUR_LEFT_N
ULL_TRIM_USER. 500
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CL R+1.0.3705)

The code in line 79 and 80 of my add_item.asp page looks like this:

WBIBKsql = "INSERT INTO APLUS2.WBIBK(WIWUID, WIWPID, WIWTID, WIEVID, WIAPSV,
WI#BRK) VALUES (" & nUID & "," & nPID & ", 'LI', 'M1', 'APSV1 ', 001)"
Conn1.Execute WBIBKsql

I don't get the error message every time this code runs. Sometimes it
happens once or twice a day, sometimes it is more. All I can find out about
the error message is that there is a syntax error in the SQL statement but
I'm baffled as to what the syntax error is.

Thanks in advance for the help.

//Joe

[Bob Barrows]

Joe Goeke wrote:

> I have an ASP site running in IIS 5.0 using ASP 3.0. I am making a
> SQL call to a DB2 database on our AS-400. The site has been running
> fine for 6 months and suddenly I'm getting sporadic 80040e14 errors
> in the log files. The log file message is as follows:
>
> 2003-11-19 16:32:17 12.35.121.12 - 12.35.121.219 47806 GET
> /add_item.asp
>

submit=Order+Sample&item=020440B031&desc=100+Deg+F lat+Machine+Screws&type=Ad

>

d|80|80040e14|[IBM][iSeries_Access_ODBC_Driver][DB2_UDB]SQL0104_-_Token___wa

>

s_not_valid._Valid_tokens:_(_+_-_?_:_DAY_RRN_CASE_CAST_CHAR_DAYS_HOUR_LEFT_N

> ULL_TRIM_USER. 500
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CL R+1.0.3705)
>
> The code in line 79 and 80 of my add_item.asp page looks like this:
>
> WBIBKsql = "INSERT INTO APLUS2.WBIBK(WIWUID, WIWPID, WIWTID, WIEVID,
> WIAPSV, WI#BRK) VALUES (" & nUID & "," & nPID & ", 'LI', 'M1', 'APSV1
> ', 001)" Conn1.Execute WBIBKsql
>
> I don't get the error message every time this code runs. Sometimes it
> happens once or twice a day, sometimes it is more. All I can find
> out about the error message is that there is a syntax error in the
> SQL statement but I'm baffled as to what the syntax error is.
>
> Thanks in advance for the help.
>
> //Joe

I suggest putting the value of WBIBKsql into the log file when this error
occurs. You cannot debug this without knowing the actual SQL statement that
is causing the error.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray at]

You may get a better error message if you use OLEDB instead of ODBC.

What happens when you try to load that URL with that same querystring?

Are you checking for apostrophes in your values before trying to insert
them?

Since you're using GET instead of POST, if a user enters a lot of data, it
may be getting truncated and you're losing values. I suggest using POST.

You haven't been able to duplicate the error?

Are there any messages from QSYSOPR that may give hints?

What are the values of nUID and nPID?

That 001 isn't delimited, so I assume it is numeric. Is that the case?

Ray at work

"Joe Goeke" <joe@microplastics.com> wrote in message
news:OehwL0rrDHA.2408@tk2msftngp13.phx.gbl...

> I have an ASP site running in IIS 5.0 using ASP 3.0. I am making a SQL

call

> to a DB2 database on our AS-400. The site has been running fine for 6
> months and suddenly I'm getting sporadic 80040e14 errors in the log files.
> The log file message is as follows:
>
> 2003-11-19 16:32:17 12.35.121.12 - 12.35.121.219 47806 GET /add_item.asp
>

submit=Order+Sample&item=020440B031&desc=100+Deg+F lat+Machine+Screws&type=Ad

>

d|80|80040e14|[IBM][iSeries_Access_ODBC_Driver][DB2_UDB]SQL0104_-_Token___wa

>

s_not_valid._Valid_tokens:_(_+_-_?_:_DAY_RRN_CASE_CAST_CHAR_DAYS_HOUR_LEFT_N

> ULL_TRIM_USER. 500
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CL R+1.0.3705)
>
> The code in line 79 and 80 of my add_item.asp page looks like this:
>
> WBIBKsql = "INSERT INTO APLUS2.WBIBK(WIWUID, WIWPID, WIWTID, WIEVID,

WIAPSV,

> WI#BRK) VALUES (" & nUID & "," & nPID & ", 'LI', 'M1', 'APSV1 ', 001)"
> Conn1.Execute WBIBKsql
>
> I don't get the error message every time this code runs. Sometimes it
> happens once or twice a day, sometimes it is more. All I can find out

about

> the error message is that there is a syntax error in the SQL statement but
> I'm baffled as to what the syntax error is.
>
> Thanks in advance for the help.
>
> //Joe
>
>
>