Post reply

SQL Server SMTP mail problem (fiber mode)

  • September 29, 2004 at 3:35 am

    #152289

    I am trying to use a trigger to send an e-mail through SMTP, However when i try and test the Stored prodcedure which sends the e-mail, i get an error that says OLE automation objects are not supported in fiber mode. Is there any other way i can achieve my aim? SQL mail is not set up and i have no ooutlook client installed on the server.

    Any advice much appreciated

    thank, ade

  • October 4, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • October 5, 2004 at 11:26 am

    #525467

    Did you try xp_smtp_sendmail? Its free & flexible. I have been using this morethan a year. Pretty neat.

    Here is the link. http://sqldev.net/xp/xpsmtp.htm

    For this, You would need to register the XP_smtp_sendmail DLL.

    .

  • October 6, 2004 at 1:30 am

    #525539

    Thanks for the link, i have actually fixed this problem now. I found that fiber mode only effects the performance of SQL server under certain conditions, and since these did not apply to my server i turned it off and can now use the CDONTS method of sending mail.

    thakns, Ade

  • October 6, 2004 at 6:10 am

    #525558

    You are welcome!!! Glad your problem resolved.

    .

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply