CDO failure

[ellenr]

I have a db that has been running several years with a cdo email module. The main user of this part of the program uses comcast isp @nc.rr.com. No problems for at least 3 years. Two weeks ago she began having email problems. With tech help she changed from smtp port 25 to port 587 and added auth and finally got her Outlook and phone email working. These changes did not help the cdo--she gets Failed: The transport failed to connect to the server. Any ideas? Where to start troubleshooting? The cdo routine sends out group emails as "one of" emails, so I doubt they are blocking her for spamming. She had only sent 4 or 5 emails in the last two months.

Really need your help! Thanks

 

[isladogs]

Ellen
You posted a very similar thread about this issue the other day
https://www.access-programmers.co.uk/forums/showthread.php?t=299549
I made a suggestion in that thread. Did you try it as you haven't responded.

 

[ellenr]

I have now sent your tester to the user with the problem. I cannot test from here, as I have no similar problem with my own isp. Hope this will give us some clues! Thank you.

 

[isladogs]

I have now sent your tester to the user with the problem. I cannot test from here, as I have no similar problem with my own isp. Hope this will give us some clues! Thank you.

The help file that comes with my tester includes an explanation of what causes each possible error. The 'transport failed to connect to the server' error is due to one or more incorrect email settings.

 

[ellenr]

ridders, I assumed that is the case. However, when the email settings match the settings in the working Outlook, I am not sure what to do next.

 

[isladogs]

ridders, I assumed that is the case. However, when the email settings match the settings in the working Outlook, I am not sure what to do next.

I've never known a situation where the CDO mail settings were identical to those used by Outlook yet one worked and the other didn't.
I suspect that not all CDO settings were correctly updated

 

[The_Doc_Man]

If this is an office setting as opposed to a home setting, then ask the IT group in your office whether someone upgraded a security router/firewall in your location.

Sometimes the information in one of the transport layers gets intercepted and blocked. I had a case where when using Outlook, SMTP outbound messages were allowed, but when using Access and CDO, SMTP messages were blocked. Somehow, the router knew that I wasn't using Outlook. It knew I was using Access.