By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,263 Members | 1,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,263 IT Pros & Developers. It's quick & easy.

transaction support

P: n/a
i'd like to pull messages from a POP3 server and store them in a database.
What mechanisms are there to treat this process like a transaction?

thanks,

craig
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Just curious as to why you might want to wrap this in a transaction.

By default, with POP3 servers, when you download messages, they will not be
deleted from the server until the command is given from the client. In
other words, if you attempt to D/L you mail from a POP3 server the
connection craps out before all the mail is D/L, the messages that you have
D/L thus far, are still on the server.

Therefore, in your app, you can verify that you have all of the mail D/L
according to the headers etc that you queried from the server. When that is
verified, then you can send the delete command to the server from your app.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)


"Craig Buchanan" <so*****@microsoft.com> wrote in message
news:eM**************@TK2MSFTNGP15.phx.gbl...
i'd like to pull messages from a POP3 server and store them in a database.
What mechanisms are there to treat this process like a transaction?

thanks,

craig

Nov 21 '05 #2

P: n/a
good point. thanks for the clarity.

craig

"Gerry O'Brien [MVP]" <gerry dot obrien at gmail dot com> wrote in message
news:OA**************@TK2MSFTNGP15.phx.gbl...
Just curious as to why you might want to wrap this in a transaction.

By default, with POP3 servers, when you download messages, they will not
be deleted from the server until the command is given from the client. In
other words, if you attempt to D/L you mail from a POP3 server the
connection craps out before all the mail is D/L, the messages that you
have D/L thus far, are still on the server.

Therefore, in your app, you can verify that you have all of the mail D/L
according to the headers etc that you queried from the server. When that
is verified, then you can send the delete command to the server from your
app.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)


"Craig Buchanan" <so*****@microsoft.com> wrote in message
news:eM**************@TK2MSFTNGP15.phx.gbl...
i'd like to pull messages from a POP3 server and store them in a
database. What mechanisms are there to treat this process like a
transaction?

thanks,

craig


Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.