SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 xpsmtp80.dll not working on sql server 2005 (64bi)
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

amitabhwankhede
Starting Member

2 Posts

Posted - 02/09/2007 :  07:24:13  Show Profile
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 02/09/2007 :  11:32:37  Show Profile
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000