I know, I've been told before; however I won't change my name to Nagy Pattyn.
Luc Pattyn [Forum Guidelines][My Articles] DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.
The parameters don't get substitued and then sent to SQL Server. Your statement gets sent and the parameters supplied seperately, SQL server then does the 'substitution'. It allows it to work more efficiently that way.
SQL Profiler is an application contanined in SQL Server 2005 client tools.
You will probably find it installed on your database server, you can also install it on your development machine. With it you can trace queries made on your database.
I keep getting error ID 1314 "An unhanded security exception has occurred" in the event log. However this only happens on the staging servers. If i run it on my local machine it works fine.
What I'm trying to do is run a file uploader (flex) this then calls the handlers (C#.Net 2.0) in the pres layer. This should then call the app layer and do the basic file IO (create a folder and stick the uploaded file into this folder). However when I try to execute this code on any of the staging servers I get error 1314. I've googled loads and looked on here. The one topic I found on here said that I should change the group policy and set it to be able to run as part of the operating system. Did this but the problem is still there.
Some more info, I'm using windows impersonation on all of my IO methods. The account that is being impersonated is in the administrators group (for now). Also this type of IO (create folder and stick something in it) is being done in other parts of the website and is working fine??
The error that the flex returns is as follows: "[IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2038"]" and "[HTTPStatusEvent type="httpStatus" bubbles=false cancelable=false eventPhase=2 status=500]".
In the event log:
Event Type: Information
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1314
Event code: 4010
Event message: An unhandled security exception has occurred.
Event time: 18/06/2009 09:27:26
Event time (UTC): 18/06/2009 08:27:26
Event ID: 4de8de366e684eec959db42fb5231dae
Event sequence: 20
Event occurrence: 2
Event detail code: 0
You could look it up in the row of the data grid, or in the row of the data source.
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp