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.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 xpsmtp80.dll not working on sql server 2005 (64bi)

Author  Topic 

amitabhwankhede
Starting Member

2 Posts

Posted - 2007-02-09 : 07:24:13
hi, i have an application that was running successfully on sql server 2000 x86 machine but now its been migrated to sql server 2005(64 bit) with windows 2003 server x64 machine. And now the xp_smtp_sendmail is not working when called through sql server even declare @rc int exec @rc = master.dbo.xp_smtp_sendmail @server = 'my.server.com', @port = 25, @ping = 1 select RC = @rc wont work it would give error that could not load the dll or one of its module not a valid win32 application. but its working fine in x86 win server 2003 n sql server 2005 machine when i run dependency walkthrough it, it shows some dlls missing i have also read that in syswow64 can run only those application that are not running in kernel mode. what might be the problem...or should i look for another alternative.. thanks for help in advance

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-02-09 : 11:32:37
use sqlimail instead on sql2005. this is the smtp mail replacment for sqlmail that is now included in sql2k5. xp_smtp_sendmail was only intended to work with sql 7 and sql 2000.

btw, you can contact the developer of xp_smtp_sendmail directly at his website http://www.sqldev.net if you have further questions.



-ec
Go to Top of Page
   

- Advertisement -