Fernando Costa de Almeida wrote:
>
> First of all, let me explain the scenario:
>
> We are setting a newsletter here in my work, so we set a database
> with users information, html, etc (using Sql-Server 7.0 and Windows NT
> 4.0), and we make administrators via web too, using ASP. We will have a
> lot of types of newsletter, acording user age, location, etc., he will
> receive a different newsletter.
> All this is working fine, and now we desire to send this emails
> quickly (QmAiL!!), and I was wondering how to integrate this application
> with qmail. My first ideia was to use ezmlm with suport to sql database,
> but how ezmlm cant connect to a SQL-Server, I decided to use a perl
> script (and perl module FreeTDS), to make queries to the sql database,
> insert into my local mysql database and then let ezmlm do the hard work
> for us.
> First, is there a better aproach? (I cant find). I would like to use
> ezmlm, because I think it will deliver the emails the most quickly
> possible. Second, how we will have a lot of kinds of newsletters, will
> I have to construct one diferent maillist to each diferent newsletter?
> They cant share the same tables....
>
> I hope I was clear, sorry about my English...
You could use ezmlm-idx. It has support for MySQL and PostgreSQL. I
think you could use one of those to connect to your SQL-Server (if
ezmlm-idx use standard queries).
http://www.ezmlm.org/
Hope it helps,
--------------------------------------------------------------------
Daniel Augusto Fernandes (DAF tm) [EMAIL PROTECTED]
GCSNet http://www.gcsnet.com.br/
--------------------------------------------------------------------
Se voc� n�o encontra
o sentido das coisas
� porque este n�o
se encontra, se cria.
Antoine Saint-Exup�ry
