Sending email using Sql Server 2000 CDOSYS

[ankushmn]

I tried code from http://support.microsoft.com/default.aspx?scid=kb;en-us;312839#XSLTH4156121122120121120120 As we are using window2003 we need to use CDOSYS code from given URL. Its working on our side. But giving problem on client side. Can any one help me this????? http://support.microsoft.com/default.aspx?scid=kb;en-us;312839#XSLTH4156121122120121120120

[FrankyT]

run a port sniffer on the server and see if any of the ports used are blocked on the firewall, or rely on IP or layer 2 broadcasts. it may be an SMTP relay issue as well. if your sec policy disables the right that might be it. I would typically advise against sending email from SQL (at least SQL2000). we had issues with it at work. hey...slang is the vernacular for the vernacular...wow