July 1, 2005 at 7:36 am
I have a console program that loads a crystal report object. The program runs fine if I execute it from the command prompt. When I execute the program from xp_cmdshell, the program just hangs indefinitely at exactly the point where the program accesses the crystal report object. If I remove the report from my program, it runs through fine. There isn't a window being drawn or anything like that. Due to the nature of the program it has to run this way. Does anyone have any suggestions as to what the problem might be?
July 4, 2005 at 8:00 am
This was removed by the editor as SPAM
July 4, 2005 at 8:46 pm
It may be SQL Server Agent permissions related because to run xp_cmdshell in an application require SQL Server Agent with Domain level permissions. Try the links below to configure the permissions. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
November 12, 2007 at 2:11 pm
Hi Dain, I think we met awhile back in Wichita, at a book store, thought I'd look you up and this is the place I found you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply