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 |
|
arghya_mp
Starting Member
1 Post |
 Posted - 2006-09-06 : 05:56:39
|
| I downloaded and copied xpsmtp80.dll to Microsoft SQL server/MSSQL/BINN/DLL folder from www.sqldev.net. I am using SQL Server 2000. Then I registered using exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'.Then I granted permission using grant execute on xp_smtp_sendmail to public.Then I am trying to executedeclare @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 goBut the message is showing like thisODBC: Msg 0, Level 16, State 1Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).(1 row(s) affected)I could not understand where is wrong. please help me.Arghya MahapatraJunior Web DeveloperRiva Logic Pvt. Ltd. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-06 : 09:41:51
|
| what is the exact path of where you copied the DLL? it should be something like C:\program files\microsoft sql server\MSSQL\Binn-ec |
 |
|
|
|
|
|
xp_smtp_sendmail