February 3, 2003 at 11:03 pm
I get the following error when trying to send an email using CDOSYS
to a domain outside my local network.
The server response was: 550 not local host hotmail.com, not a gateway
anyone know why?
thx
rg.
February 6, 2003 at 8:01 am
This was removed by the editor as SPAM
February 6, 2003 at 10:19 am
This means that the mail server you are using does not allow forwarding of SMTP mail via a gateway. There are articles on the MS site referring to this subject (cannot remember which offhand). We use Exchange server and this option is switched off for security reasons. I think there was a way round this but it was ugly, cumbersome and could breach security. I changed to use Outlook client and set up the mail service in SQL server.
Far away is close at hand in the images of elsewhere.
Anon.
February 6, 2003 at 6:31 pm
thanks, i actually figured it out i needed authentication.:
EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate").Value', '1'
EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', mail server
EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusername").Value', login
EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendpassword").Value', password
February 7, 2003 at 7:37 am
Has anyone managed to send attachmenst using cdosys.
Would be interested to know how you did it.
February 7, 2003 at 8:20 am
There are several threads on this site referring to your query and most seem to be attachments. I used the following snippet to add an attachment
EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment',@ret out, @Attachment
where @Attachment is varchar and @hr,@ret,@iMsg are int
I used the procedure published elsewhere on this site and cannot claim credit for it but altered it for my use. If you wish to email me I will send you my proc.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply