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 <*> 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/
