| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-02-03 : 08:02:26
|
| Windows 2003 has dropped support for CDONTS, so I've got to rewrite the SQL VBscript job which has served us well for several years sending email queued in the database.Before I rewrite this job using CDOSYS has anyone found a more debuggable package that could be used to send queued email (other than a SQL job?). Maybe an ASP or .NET script that can run as an autonomous job outside of SQL?Sam |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-02-03 : 08:10:25
|
| There is a great open source .NET mail component called OpenSmtp.NET at http://sourceforge.net/projects/opensmtp-net/I've used it to implement mail queues for a few clients. How much code do you feel like writing ?Damian |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-02-03 : 08:23:16
|
| Why do you ask? (not much of course) |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-02-03 : 08:43:53
|
| Just coz it's not a full solution, but it's a good component.Damian |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-02-03 : 08:48:24
|
| Have you used this component to read a recordset of email from a database and send it via SMTP? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-02-03 : 08:54:46
|
| You bet, it works very well. I've used it to send mailouts to a list of 20000 subscribers.Damian |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-02-03 : 08:59:10
|
| As a scheduled job? Or something invoked by an operator? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-02-03 : 09:04:52
|
| In this case, it was inside an ASP.NET application, every minute the application launched a thread to check the queue and send out mails.It would work just as well inside a windows scheduled task.Damian |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-02-03 : 09:17:42
|
| I tried to do something like that a year ago and funked out on the "launch a thread" part.Would make a good paper if you wanted to take the time to post a solution. |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-02-03 : 09:18:56
|
| This supports Chinese and Japanese ala NVARCHAR? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-02-03 : 09:22:44
|
| I should do an article with it, that could be cool.Mail me if you want to see it and I'll pull out the client sensitive bits and give you something you can work with.Damian |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-02-10 : 02:13:38
|
| Only just got to this Sam. Responded to your CDOSYS post in Scripts that we use EasyMail Objects. We have a "bulk mailing tool" that frequently sends more than 100,000 emails in a batch.Its just a COM object, as such.www.quiksoft.comKristen |
|
|
|
|
Implementing new email