Dim sql As String sql = "exec master.dbo.xp_cmdshell 'dtsrun /Shitsql033 /NLinus_DTS_ASP_Test /UASPDTS /PASPDTS'" oic.executeSelectStatement(sql) oic.CloseConnection() Result: EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo'. 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.Data.OleDb.OleDbException: EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo'. I have make the account "ASPDTS" to be System Administrator Can anyone help? Many thanks Linus
Linus51680
Posts
-
ASP.NET Call SQL Server DTS -
when the asp.net page run page_load function.....when the asp.net page run page_load function, it always scroll to the top of the page, is there any solution to this? for example, I have a calendar (from asp.net) at a very low position, everytime i click the button to visible the calendar, this will refresh the screen and scroll up the top of the page. Then I need to scroll down to the calendar and select the day everytimes, it is quite inconvenient.
-
ASP.NET slow performance when user re-boot computerhi Lozano, every user firstly, when the user hit the application, it will help to login (single signon). Then, it will determine what the right the user has (retrieve such info from DB). It will display those item which can be accessed by the user onto the screen. Thanks for your help. Linus
-
ASP.NET slow performance when user re-boot computerI have a problem on ASP.NET in my web application, I find that when user first time access the application. It takes 2-3 minutes to load, in this period, the IE seems hanging. But after he loads this first time, it takes only few seconds to load the applcation again. However, when the user reboot the computer or delete all the internet temp files, it comes again. I m frustrating about it. i cant find any reason on it Any body can help? Million thanks