Problems with VB email program from xp_cmdshell

[Craftor]

Hi all

I am experiencing serious problems with xp_cmdshell. I have written a program in VB that launches an email message flow (part of our software - just basically functions like an email message with an XML front end). Now the program works fine if I double click on it in Windows Explorer, but the moment I try to launch it as a SQL job, it just hangs. I have left it running for an entire weekend and it did NOTHING so I know it's not just slow ;-)

Any help please!!!

Craftor

 

[aalmeida]

To send Emails from SQL you do not need to use xp_cmdshell it Has it's own email procudure and they do not interact with the desktop, they use the MAPI client on the background you might whant to read more on BOL article called "xp_sendmail" AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Craftor]

Unfortunately my program requires me to send an email from VB - it works off an email basis and SQL Mail can't provide me with the functionality I need. But not to worry I found the problem ... thanks anyway