OK, so we got the updated Client Access installed. Finally got the binding redirect to work and now we get this weird message on the traditional ASP.net error page. Google was stumped. Any ideas?


Access to the path 'CWB_MP_TI_EVENT' is denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access to the path 'CWB_MP_TI_EVENT' is denied.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. <snip>

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[UnauthorizedAccessException: Access to the path 'CWB_MP_TI_EVENT' is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) +9726046
System.Threading.EventWaitHandle..ctor(Boolean initialState, EventResetMode mode, String name) +9392848
IBM.Data.DB2.iSeries.iDB2NamedEvent..ctor(String eventName) +136
IBM.Data.DB2.iSeries.iDB2Trace..cctor() +89

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Wednesday, April 18, 2012 1:51 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL0104 Token (fieldname) not valid from .NET data provider

On 18Apr2012 08:43, Maassel, John R. wrote:
<<SNIP>>

My SQL statement looks like this:

SELECT INVID, INVCONO, INVUNNO, INVNUM, INVDATE, INVVENDNM ,
INVFOODAMT, INVNFAMT, INVCOMMENT, INVACCT, INVVHVECO , INVVHIREF,
INVVHAUDT, INVVHVEND, INVIMS, INVVEND FROM FINPINV WHERE invcono =
@cono AND invunno = @unno AND invvhiref IS NULL

I then add the parameters in and run the query. I get:
Token INVUNNO was not valid. Valid tokens: FOR SKIP WITH FETCH ORDER UNION
EXCEPT OPTIMIZE.

FWiW: If the replacement text for @cono is blank(s) or the empty string, having been applied to the statement text prior to SQL parsing, then the adjusted statement [e.g. "... WHERE invcono = AND invunno =..."] should fail with the -104 sqlcode for a syntax error, having identified the INVUNNO located after the "AND" as being problematic along with the noted list of expected valid tokens.

Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

________________________________

Notice from Bob Evans Farms, Inc: This e-mail message, including any attachments, may contain confidential information that is intended only for the person or entity to which it is addressed. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].