jrpfinch wrote: > I have an externally-written piece of software that spits out emails > using SMTP (a few hundred per hour) and I would like to dump the > content of them in an MS SQL Server database. > > I have barely used Python before but it looks as if it could do the > job. I have no experience with mail agents. My starting point is this > recipe: > > http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/440690 > > I know that there are various libraries that can connect to MS SQL > server and I am going to research these. http://sourceforge.net/projects/mysql-python > > I have two questions: > > i) Does this sound like an efficient way of transferring data to the > database? Not certain I understand
> ii) Looking through the Python documentation, I cannot see a way to > set the password on the SMTP server. I would like to have a password - > does anyone know how to use the recipe above to set one? s = smtplib.SMTP() .... s.login(...,'password') > > Any other useful nudges in the right direction appreciated. > > Many thanks > > Jon hg -- http://mail.python.org/mailman/listinfo/python-list