xp_smtp_sendmail

Question

xp_smtp_sendmail

devaraya

Default port

Points: 1455
More actions
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

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

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

Perry-300990 Default port Points: 1451 More actions · Answer 1

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.

devaraya Default port Points: 1455 More actions · Answer 2

Hi Perry,

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

Ramaa

philcart SSC-Forever Points: 47794 More actions · Answer 3

What version of SQL Server are you using?

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

stefan.c SSC Journeyman Points: 75 More actions · Answer 4

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

devaraya Default port Points: 1455 More actions · Answer 5

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

Allen Laird SSC Rookie Points: 43 More actions · Answer 6

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

Ronald San Juan SSCrazy Points: 2937 More actions · Answer 7

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"

Tim Riley Valued Member Points: 73 More actions · Answer 8

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.