Post reply

Using XP_smtp_sendmail with 64-bit SQL Server

  • April 28, 2005 at 8:39 am

    #152395

    Has anyone tried using XP_smtp_sendmail provided by sqldev.net on 64-bit sql server?  I have setup smtp mail to email us several notifications.  Plans are to move to 64-bit sql server late this year.  However, while testing smtp mail on it, it gives the following error:

    Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 193(error not found)

    Any ideas?  The dll is in the correct binn folder and registered with the extended store procedure.

    Thanks

    Eric

  • May 2, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • May 5, 2005 at 7:00 am

    #557042

    am having the same problem using xp_smtp_sendmail. I will appreciate if someone can help us out.

    Thanks

    Lekan

  • July 9, 2005 at 10:05 am

    #572704

    The question is your SQL Server Agent installed with a service account with enough permission to run SMTP?  Try the link below for more info.  I was a beta one tester of SQL Server 64bits so I am assuming you know you can just register it in your 32bits version you use Enterprise manager.  Hope this helps.

    http://www.karaszi.com/SQLServer/info_no_mapi.asp

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

  • November 30, 2005 at 8:55 am

    #606776

    I am also having the same problme with 64 bit sql 2000.Any one had made this work .Please reply me.


    DBA

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

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