Hi! I am using SQL Server 2000. I wanted to send MIME type mail through SQL Mail. So I downloaded xpsmtp80.dll and copied to C:\Program Files\Microsoft SQL Server\MSSQL\Binn\DLL. Then I registered it by exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'. I granted permission to public by grant execute on xp_smtp_sendmail to public.Now when I am executing this declare @rc int exec @rc = master.dbo.xp_smtp_sendmail @FROM = N'MyEmail@MyDomain.com', @TO = N'MyFriend@HisDomain.com', @subject = N'My first HTML mail', @message = N'
This is some HTML content
', @type = N'text/html' select RC = @rc go An error generating stating 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.). (1 row(s) affected) Please anyone help me to sort out this problem.
Arghya Mahapatra