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.

 All Forums
 Other Forums
 Other Topics
 want to store incoming mails into database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-13 : 08:23:15
Pravu writes "I am working in a website modification project which is developed by some one and running.The client want customize email system where client can store all the incoming,outgoing and delivery faild mails in the database.The current site is using asp and I also code other modifications in asp(vbscript).
what is the code in asp by which I can do all these jobs?"

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-13 : 09:49:34
Sounds like a real big task, reinventing the wheel, What mail client are you using ?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-14 : 03:29:15
It is easy keep the files in the Server than storing them in table. Then you can retreive them using File System objects. Otherwise you need to make use of image datatype. Read this
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2006-02-14 : 05:52:21
Wow guys. Two totally irrelevant replies, I know you want to add the posts but please try to give some helpful answers.

Pravu, there are a few ways of doing this, depending on how much of the infrastructure you control.

If you are installing a mailserver, check out www.mailenable.com. It will let you run an executable when a mail is receieved or sent, this could insert the mail data into your database.

The other option, is use a POP3 component to check a standard POP3 mailbox and retrieve the mails that way.

Maybe if you gave a bit more background info next time you might get some better answers.



Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-14 : 09:50:22
hi Damian,
I asked what mail client he is using, ....

...we have a solution inhouse, that uses perl and a linux server, it reads the neomail mail client, and sendmail in linux and changes the interface and how it works.

Am not a linux guru, so not sure how he did it, but he says perl gives much more flexibility to the root OS than ASP scripts. Thats why i asked.



But like i said, i think its reinventing the wheel.
Ehi
Go to Top of Page
   

- Advertisement -