Something is probably trying to be clever behind the scenes by wrapping your work in a transaction. Have you tried using the SQL Profiler to see what is happening exactly on the server? It should through up any implicit transaction issues.
-----Original Message----- From: Andy and Kim Mills [mailto:[EMAIL PROTECTED] Sent: 24 January 2005 4:11 To: [email protected] Subject: [ASP] .ASPX and Stored Procedure When I run a Stored Procedure on the SQL Server box: I do not get any errors and the information is successfully copied. However: when I run it from the .ASPX page: I get the following error: System.Exception: Invalid object name 'tempAlbum'. Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1. And the information is not copied. I checked the database: and the user that is accessing the database is a DBOwner, so I do not think this should be a security or permission issue. However: I am not sure what is happening behind the scenes with the .ASPX page and SQL Server. I am not sure why I get an invalid object error when accessing the SP through the ASPX page, when I do not get that error running it directly on SQL Server. Would anyone happen to have any ideas or thoughts on the matter? Thanks Andy --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
