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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Email : CDO transport failed

Author  Topic 

beyonder422
Posting Yak Master

124 Posts

Posted - 2005-11-10 : 15:47:08
Question: I've put together a proc to send email. The proc works on one server, but throws this message on another.

"CDO.Message.1: The transport failed to connect to the server."

I can get it to work on my local machine, WinXP, but when I try to run it on a Win2003 Server with SQL Server 2000 Sp4 I get the error.

Reason I'm confused is I didn't set-up any security or IP access or anything on my local machine and it works fine, it's just when I put it on the Production server that is throws-up...

And what's even more confusing is that I have the same email logic "CDOSYS" working in an asp page.

Anyone familiar with why this error is scenario?
   

- Advertisement -