Post reply

xp_smtp_sendmail

  • March 4, 2006 at 4:14 am

    #89645

    I am getting this error while installing xp_smtp_sendmail. Can anybody try this?

    ODBC: Msg 0, Level 16, State 1

    Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

    Ramaa

  • March 5, 2006 at 11:26 pm

    #624814

    I might run Depends (Microsoft's Dependency Walker) on that dll, to see what other dlls it depends on, and more importantly, to see if any are missing.

  • March 5, 2006 at 11:59 pm

    #624817

    Hi Perry,

    I did't get U. Can U more elabarate?

    Ramaa

  • March 6, 2006 at 5:29 am

    #624843

    What version of SQL Server are you using?

     

    --------------------
    Colt 45 - the original point and click interface

  • March 6, 2006 at 8:07 am

    #624924

    Hi,

    You must copy the file xpsmtp80.ddl to the sql server 2000 binn directory.

    After you copy the file run the commands below in Query Analyzer:

    exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'

    grant execute on xp_smtp_sendmail to public

    /Stefan

  • March 6, 2006 at 9:31 pm

    #625105

    Hi,

    I am using Microsoft sql Server 2000 - 8.00.194.

    I executed the above two statements still i am getting the same error.

    Ramaa

  • December 4, 2006 at 3:54 pm

    #675656

    I also copied the DLL to my C:\WINDOWS directory and then it worked.

  • December 4, 2006 at 5:50 pm

    #675689

    from the command line, use

    REGSVR32 'C:\program file\Microsoft SQL Server\MSSQL\Binn\xpsmtp80.dll'

    then follow stefan's instructions.

    note: you may need to change the path above.

     

    Ronald San Juan | SQL DBA
    ID 710124 ~ Code "Northwind"

  • December 12, 2006 at 2:04 pm

    #677620

    Just FYI.  I don't recall win 2000, but I just had this same issue with win 2005 and figured out the prob.  Go to the extended sp (if the xp_smtp_sendmail exists) and check out the setting in the properties where it points to the .dll in the BINN folder.  Mine said xpsmtp70.dll and I am running 2005.  Not sure if this might be the final issue, but give it a shot.

Viewing 9 posts - 1 through 8 (of 8 total)

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