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>
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.
[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
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Wednesday, April 18, 2012 1:51 PM
Subject: Re: SQL0104 Token (fieldname) not valid from .NET data provider
On 18Apr2012 08:43, Maassel, John R. wrote:
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
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.
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,
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.