[AccessD] Need SMTP Code

Hi Rocky

I would use that code - or at least test it. Provide a default external SMTP server with credentials you set up in the app.
If that fails for a user, provide an option for modifying the default settings.

But there is no single "right" way to do this. We once had a server running for receiving reports from a dozen clients. The setup was simple (no credentials) as we had recorded the IP addresses of the senders - any other connection was refused. Worked great, but over time the sender addresses of course changed and that required a little maintenance. And one client had no port 25 so he had to e-mail the reports which we then handled manually.

It is also a question of confidence. If the transmitted data are confident, either the data (file or transfer) or the connection must be encrypted.

So may ifs ...

/gustav

>>> rockysmolin at bchacc.com 06-08-2007 19:40:10 >>>
So what do you think is the best solution?  This legacy app I'm enhancing
has some SMTP code in it but I haven't looked at it closely yet.  

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, August 06, 2007 10:34 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Need SMTP Code

Hi Rocky

Before you get too happy, note all the traps no matter what tool you decide
for.

For a corporate workstation it is quite common that it has no access to the
outside on port 25. If it has, you or the app must provide the name of the
external SMTP server and the user's credentials. These must be required or
your SMTP server will be an open relay which will be blocked within an hour.

If port 25 is open, it may be blocked at the corporate firewall. If so, you
can only access an in-house (corporate) SMTP server, the name of which -
again - must be provided. It may even require a secure connection which only
the more sophisticated SMTP clients offer, for example Chilkat:

http://www.chilkatsoft.com/email-activex.asp 

If no port 25, you may connect to the corporate mail system, say, via
Outlook or MAPI which is a completely different ball game.

/gustav

>>> pctech at mybellybutton.com 06-08-2007 19:04:59 >>>
Dan:

Sterling endorsement. :)  Looks like a good candidate. Simplest for the end
user is best.  With vbSendMail does the user have to know their server name,
port, etc.?  The less stuff they have to know the better.

Thanks

Rocky



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007
4:16 PM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com