Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wendy
Starting Member
19 Posts |
 Posted - 2005-05-16 : 16:22:47
|
| Has anyone tried using xp_smtp_sendmail provided by sqldev.net on " Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790) "sql server? I have setup SMTP mail and got it works at some exact same configured servers but others don’t work. 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: 126(The specified module could not be found.).”Any ideas? The dll is in the correct binn folder and registered with the extended store procedure.ThanksWendy |
|
|
amitabhwankhede
Starting Member
2 Posts |
Posted - 2007-02-08 : 03:42:02
|
| I have done dependency walker on xpsmtp80.dll and found that DWMAPI.DLL , OPENDS60.DLL and UMS.DLL are missing. I need this ums.dll to run xpsmtp80.dll successfully right now its showing not a valid win32 application error on sql server 2005 x64 sp2 running on windows server 2003 x64 sp1. Can you suggest me the solution. Any hotfix? Or should i use another alternative |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-08 : 11:24:24
|
quote:
Originally posted by amitabhwankhede
I have done dependency walker on xpsmtp80.dll and found that DWMAPI.DLL , OPENDS60.DLL and UMS.DLL are missing. I need this ums.dll to run xpsmtp80.dll successfully right now its showing not a valid win32 application error on sql server 2005 x64 sp2 running on windows server 2003 x64 sp1. Can you suggest me the solution. Any hotfix? Or should i use another alternative
xpsmtp80.dll is 32bit, so it won't work with 64bit SQL Server. Also, this extended stored proc was designed to work with SQL 7 and SQL 2000 - not SQL 2005.In SQL 2005 they have replaced SQLMail with SQLiMail. Have you looked into using it instead?-ec |
|
|
|
|
|
|
xp_smtp_sendmail error