transaction support - Visual Basic .NET

Craig Buchanan

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

Subscribe Reply

841

Gerry O'Brien [MVP]

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

Craig Buchanan

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

Similar topics

13317

4 Transaction Log questions

by: TZoner | last post by:

1) Can one find the location of the 'Transaction Log' at: <Hard Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf? 2) Is it safe to delete it, as SQL will create a new Transaction...

Microsoft SQL Server

5222

Why the transaction log file full

by: Daniel Xiao | last post by:

I have set the initial size of the log file for a database to 1M, the maximum size is unrestricted, and the increase rate is 10%. However, when I attempt to delete thousands of rows, the error is...

Microsoft SQL Server

18276

Cannot shrink the transaction log

by: BashiraInTrouble | last post by:

Hi Friends, I have tried almost everything but I cant seem to shrink the transaction log. Executing DBCC SQLPERF(LOGSPACE) gives me this info: Database Log Size (MB) Log Space Used (%) ...

Microsoft SQL Server

3304

Federated Insert and local update in on transaction not possible

by: Klemens | last post by:

I get SQL30090 reason 18 by trying to do an insert in a federated table and an update in a local table in one transaction Do I have to change some settings to get done or ist this not possible by...

DB2 Database

348

Performing a Transaction in 2 systems

by: Chris Fink | last post by:

I have the need to perform an atomic operation in two systems, a database and an ftp site. The process is two step; 1. insert a row into oracle, 2. delete a file from a remote ftp site. I need to...

C# / C Sharp

1776

Transaction and TypedDataSEt

by: liming | last post by:

Hi, I know it's possible to have transactions with Typed DataSet, but I have yet to find an example of it. For example, I have two typed TableAdapter CommerceDataSet.xsd ...

ASP.NET

2521

atomic transaction

by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:

Hi all, In asp.net, there is an object sqltransaction we can use to garantee the data will be written to database either completely or none will be written into database. I am not sure if there...

ASP / Active Server Pages

2035

Transaction scope question

by: GaryDean | last post by:

I'm using TransactionScope as follows... using TransactionScope myScope = new TransactionScope()) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString =...

ASP.NET

1833

How to make two WCF services in a transaction

by: John Dow | last post by:

I am new to WCF, so please point me to the right direction. I created 2 WCF serivces, each one uses a difference database connection in the back end. Now from the client application, I need to...

.NET Framework

1431

RE: Transaction Error on None-Transaction Query

by: Jialiang Ge [MSFT] | last post by:

Hello Peter, I once came across the same error "ExecuteReader requires the command to have a transaction when the connection assigned? with running two threads talking with the database. There...

C# / C Sharp

7037

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

6904

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7034

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7076

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6732

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5324

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4472

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

2990

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

2976

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET