April 28, 2005 at 8:11 am
Has anyone tried using XP_smtp_sendmail provided by sqldev.net on 64-bit sql server? I have setup smtp mail to email us several notifications. Plans are to move to 64-bit sql server late this year. However, while testing smtp mail on it, it gives the following error:
Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 193(error not found)
Any ideas?
Thanks
Eric
April 29, 2005 at 7:55 am
Been there, bought the tee-shirt
We've been in production on clustered 64-bit Itanium 2 servers for the last 6 months now and ended up moving away from xp_smtp_sendmail because it didn't work (it's a 32-bit DLL).
We ended up going back to CDonts until SQL 2005 comes out and we are happy enough with it to migrate (Database Mail is their SMTP based mail system and does work on 64-bit servers)
It's not that hard to make the changes and I'd be happy to help out if you get stuck (as i'm sure most people here would).
Just to ask another question, you're not planning on using full-text indexing are you, because none of the 3rd party IFilters that are available (PDF, etc)work properly with 64-bit either (we spend a month comming up with a workaround)
Hope this helps,
Mike
May 2, 2005 at 10:42 am
Thanks Mike. We are also moving to 64-bit Itanium servers and are in the process of testing everything out. I have moved away from XP_smtp_sendmail and have started using cdonts. The change was quiet simple but thanks for offering the help.
I do not think we will be using full-text indexing but would like to research it further. I was not aware of this fact. Thanks for the caution.
Eric.
November 30, 2005 at 10:34 am
Hi guys,
Is that CDONTS supports queryout or attachements.Please let me know.
Thanks,
Mayil
DBA
August 2, 2006 at 11:18 am
where can i down load the 64-bit version of xp_smtp_sendmail?
thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply