June 13, 2006 at 3:57 pm
Hi all the experts,
i have a Error(or is's a bug) in my MS SQL Server 2000 sp 4 (8.0.0.2187)
I have a stored procedure, witch was filled with datas from other tables. when i declare a cursor for this temp-DB i become a EXCEPTION_ACCESS_VIOLATION. i have commend the declare lines and the procedure works fine. the error comes, when i connect the DB via SQLOLEDB. A call direct in the Query Analyzer works fine(????), but the call from my Website has the Error.
Thanks Thomas
PS give me a Pumpgun and i shot out my SH.. Server
June 14, 2006 at 9:01 am
It is you who runs a query from Query Analyzer, but it is someone else who is trying to connect from the website! And this person (he/she/it) most probably IUSR_ServerName or someone other identity that is used for the web app. This person probably does not have prmissions on your database server.
Regards,Yelena Varsha
June 14, 2006 at 9:08 am
yes this understand i, but when i connect the same Database from the same Sever via MSDASQL-Provider(ist a odbc-like connection) then works the stored procedure. This
connection type is not wish from us webadministrator.
Have i right understand, that i added the IUSR{Servername}-User on the DB-Server and the SP works?
many Thanks for your replay
June 14, 2006 at 9:37 am
no is not enoth to add the User IUSR... I have tested, but the same Error comes. I have added a new connection in my Web-App with odbc connection and all the sites works fine. I'ts very musterious(I am very confused)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply