Inbox message how to store in database

Question

Inbox message how to store in database

vinaseetha87

SSC Veteran

Points: 268
More actions
September 20, 2011 at 12:36 am

#390437

I have create a website.the customer send the query in my mail that query how to store in database.
I want to read the inbox message ,that message how to store in database.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

it really depends on what mail system you are using, for exchange 2010 you can use the webservice to get the mail message and then store this in your database. Other mail services 'should' have similar apis/web services.

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 2

You may look at SQLMail option. (Am not talking about DBMail).

There are system procedures to read the data of inbox mails.Please google out it been long time that worked on it.

Lowell SSC Guru Points: 323518 More actions · Answer 3

vinaseetha87 (9/20/2011)
I have create a website.the customer send the query in my mail that query how to store in database.
I want to read the inbox message ,that message how to store in database.

you'll have to write something in a programming language to connect to the mail server, get the list of messages, read the messages, optionally send the delete command for the messages, and then do something, like put the data in your database.

SQL Server does not have the ability, natively, to read a mailbox full of emails. there's lots of examples on the web on how to do this in .NET, let us know what you've tried. you could build something outside of SQL, and have it enter the data on a scheduled task, or call that program as a CLR or from xp_cmdshell.

i'd recommend the scheduled task route.

it would be a lot easier to use a web pages form submission to store the data, instead of the round about way you're thinking of with an email box.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 4

sqlzealot-81 (9/20/2011)
You may look at SQLMail option. (Am not talking about DBMail).
There are system procedures to read the data of inbox mails.Please google out it been long time that worked on it.

Please refer this link...

http://msdn.microsoft.com/en-us/library/ms177418.aspx

crazy4sql SSCoach Points: 19590 More actions · Answer 5

vinaseetha87 (9/20/2011)
I have create a website.the customer send the query in my mail that query how to store in database.
I want to read the inbox message ,that message how to store in database.

Just a work-around only, Create a shared folder and tell the user to put the query in a txt file named with username. Schedule a job to import the data from the txt file and read it.

----------
Ashish

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 6

I agree with Lowel , the correct approach would be log all queries in the database via a normal procedure call from a query webapge with text boxes. Routing queries via email is not a scalable and long term solution.

Security is another issue.

CLR is the way to go . I wouldn't suggest SQL Mail on a higher enviornment.

Jayanth Kurup[/url]

steveb. SSC-Forever Points: 46733 More actions · Answer 7

i would avoid SQLmail especially since you are runnig SQL 2008.

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 8

Jayanth_Kurup (9/20/2011)
Security is another issue.
CLR is the way to go . I wouldn't suggest SQL Mail on a higher enviornment.

Could you please let me know the issues that youi look for, for my understanding plz?

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 9

steveb. (9/20/2011)
i would avoid SQLmail especially since you are runnig SQL 2008.

Why is this? It is a deprecated feature for future versions. However it works in 2008 R2 as far as I know. Could you please explain the same for my understanding again?

steveb. SSC-Forever Points: 46733 More actions · Answer 10

sqlzealot-81 (9/20/2011)
steveb. (9/20/2011)
i would avoid SQLmail especially since you are runnig SQL 2008.
Why is this? It is a deprecated feature for future versions. However it works in 2008 R2 as far as I know. Could you please explain the same for my understanding again?

because it uses MAPI to communicate with the mail server, which requires outlook to be installed on the SQL server (not really a great idea) and service broker to be enabled. Basically it just acts as a wrapper for the MAPI calls and there are much cleaner ways to use this interface (if required) by using an application language as had been suggested.

DBmail uses SMTP which is fast and efficent.

Lowell SSC Guru Points: 323518 More actions · Answer 11

from the link that was posted, i also noticed you cannot use SQLMail with 64 bit SQL.

it's kind of hard to not use 64 bit with anything that's reasonably new hardware.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 12

http://www.sans.org/reading_room/whitepapers/application/sql-server-email-vulnerability-issues-prevention-strategies_1219

Jayanth Kurup[/url]

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 13

Thanks you for all for replies with the great explanations!!! I buy it!!!