Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
u4cast
Starting Member
16 Posts |
 Posted - 2004-02-19 : 06:21:44
|
| Hi guys - I'm building a SQL email solution and I've got a design and I want to know what you guys think of it. Plus I need a suggestion for an SMTP mail server. Here's what I'm thinking -1. SQL server 2000 backend2. Out going emails will be created and put into a queueing table by SQL3. A program using AspEmail COM component will use ADO to pull the emails off the server and send using an SMTP server. The program will sit on the same machine as the server to reduce network traffic. 4. Incoming emails will be handled by another program using AspEmail and will be written with ADO directly into an incoming email queue table on SQL server.5. A SQL job will pick up the incoming emails and process them.I've got the locking and processing sussed but need some advice about the overall structure and the components I've chosen. Any ideas?For info - this needs to cope with 500,000 emails in per day and the same out. Initially anyway. The emails do not need to be kept once the database has been populated. Out going emails also do not need keeping. The incoming and outgoing mail will probably run on different machines.Can anyone suggest a reliable SMTP server for step 3?I know this is a big question but any comments would really be appreciated. This is key to the success of my company. Thanks,Paul |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-02-19 : 06:31:45
|
I think it's a GREAT IDEASo good that I wrote an article on it a few years ago  http://www.sqlteam.com/item.asp?ItemID=5908As an SMTP server, you can just use the one with IIS. Or if you need extra features, take a look at www.mailenable.comDamian |
 |
|
|
u4cast
Starting Member
16 Posts |
Posted - 2004-02-19 : 06:46:00
|
 LOL - now I remember where the idea came from! Thanks! The IIS server will do the trick I think.Any ideas about populating an incoming queue quickly? I'm no email expert so any advice would be useful. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-02-19 : 06:52:38
|
| Depends what you are trying to send, and how much is tokenised. Maybe if you give some more details.Damian |
|
|
|
u4cast
Starting Member
16 Posts |
Posted - 2004-02-19 : 07:03:57
|
| The stuff coming back in will be an XML string of less than 5K in the body of an email. The only thing the server needs to do is receive the email. Something needs to write the body of the email straight into a table and if that's successful then remove the email.thanks Merkin |
|
|
|
kreg
Starting Member
7 Posts |
Posted - 2006-02-23 : 20:44:10
|
| Looking for some help. I am trying to use CDONTS and SMTP-IIS (W2k)from my webserver. Everything appears to be working with the HUGE exception that all mail gets stuck in the mail queue. Event viewer indicates "An internal DNS error caused a failure to find the remote server"... My ISP has been no help..Any help is appreciated. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-02-23 : 23:14:50
|
| Well it's definitely a server config problem. Without knowing how your servers are configured it's hard to help, but that error message sounds like a good start.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|
|
Email solution?