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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-20 : 07:14:19
|
| arghya writes "Whenever I am executing xp_smtp_sendmail stored procedure the message is showing like"Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)."I downloaded xpsmtp80.dll from www.sqldev.net. I copied it to Microsoft SQL Server/MSSQL/BINN directory. I am using SQL Server 2000. Then I registered it using exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll' and set the permissiongrant execute on xp_smtp_sendmail to public.But when I am using thisdeclare @rc intexec @rc = master.dbo.xp_smtp_sendmail @FROM = N'MyEmail@MyDomain.com', @TO = N'arghya@rivalogic.in', @subject = N'My first HTML mail', @message = N'<HTML><H1>This is some HTML content</H1></HTML>', @type = N'text/html'select RC = @rc go It is showing that message.Please help me." |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-20 : 11:15:52
|
| try using the dependency walker from depenencywalker.com to see if you have any missing DLLs or other problems. just point it at the xpsmtp80.dll and see what it says.-ec |
 |
|
|
|
|
|
xp_smtp_sendmail