|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
vb.net app error when running in master..xp_cmdshellI get an error when I run master..xp_cmdshell 'myprogram.exe' in SQL query analyzer. The error occurs on this line "oOutlook = New Outlook.Application" Unhandled Exception: System.Runtime.InteropServices.COMException (0x80080005): Server execution failed at WindowsApplication3.Main.ProcessInbox(String FolderName, String WhichFolder, String DateTimePicker1) in C:\Documents and Settings\user1\My Documents\Visual Studio Projects\WindowsApplication3\Main.vb:line 80 at WindowsApplication3.Main.main() in C:\Documents and Settings\user1\My Documents\Visual Studio Projects\WindowsApplication3\Main.vb:line 20 verify account it is running under has permissions to perform this
operation. Show quoteHide quote "mike" <beth***@hotmail.com> wrote in message news:On9oBZxHHHA.1264@TK2MSFTNGP06.phx.gbl... >I created a VB.NET app that uses Outlook's COM object. > > I get an error when I run master..xp_cmdshell 'myprogram.exe' in SQL query > analyzer. > > > > The error occurs on this line "oOutlook = New Outlook.Application" > > > > Unhandled Exception: System.Runtime.InteropServices.COMException > (0x80080005): > > > > Server execution failed at WindowsApplication3.Main.ProcessInbox(String > FolderName, String WhichFolder, String DateTimePicker1) in C:\Documents > and Settings\user1\My Documents\Visual Studio > Projects\WindowsApplication3\Main.vb:line 80 > > at WindowsApplication3.Main.main() in C:\Documents and Settings\user1\My > Documents\Visual Studio Projects\WindowsApplication3\Main.vb:line 20 > > > > Hi,
running in SQL QA as sysadmin Show quoteHide quote "vbnetdev" <ad***@kjmsolutions.com> wrote in message news:OvdTzCyHHHA.1008@TK2MSFTNGP06.phx.gbl... > verify account it is running under has permissions to perform this > operation. > > > "mike" <beth***@hotmail.com> wrote in message > news:On9oBZxHHHA.1264@TK2MSFTNGP06.phx.gbl... >>I created a VB.NET app that uses Outlook's COM object. >> >> I get an error when I run master..xp_cmdshell 'myprogram.exe' in SQL >> query analyzer. >> >> >> >> The error occurs on this line "oOutlook = New Outlook.Application" >> >> >> >> Unhandled Exception: System.Runtime.InteropServices.COMException >> (0x80080005): >> >> >> >> Server execution failed at WindowsApplication3.Main.ProcessInbox(String >> FolderName, String WhichFolder, String DateTimePicker1) in C:\Documents >> and Settings\user1\My Documents\Visual Studio >> Projects\WindowsApplication3\Main.vb:line 80 >> >> at WindowsApplication3.Main.main() in C:\Documents and Settings\user1\My >> Documents\Visual Studio Projects\WindowsApplication3\Main.vb:line 20 >> >> >> >> > > "mike" <beth***@hotmail.com> wrote in message sysadmin is a SQL Server Server Role. xp_cmdshell spawns processes using news:#67tZMyHHHA.4760@TK2MSFTNGP03.phx.gbl... > Hi, > > running in SQL QA as sysadmin > the windows identity of the service account. That's the relevant security principal to check. David "mike" <beth***@hotmail.com> wrote in I don't know enough about SQL server to be sure here, but is this trying news:On9oBZxHHHA.1264@TK2MSFTNGP06.phx.gbl: > I created a VB.NET app that uses Outlook's COM object. > > I get an error when I run master..xp_cmdshell 'myprogram.exe' in SQL > query analyzer. to run Outlook from the SQL server process itself? If so, then you probably can't do it: http://support.microsoft.com/kb/237913/en-us -- dan 
Other interesting topics
Updating database in a loop
System.Threading.Timer does not tick There is already an open DataReader associated with this Connection which must be closed first Q: DataColumn Expressions What is WebBrowser control called now? control array Looping through all Tables in a Database Form1.closing in VB2005??? Datagrid problem how can I reference this bitmap????????? |
|||||||||||||||||||||||
