The connection is dead

pairat@xxxxxxxxxxx · 7 Jan 2006 02:39:16 -0800

Hi,

I'm running PostgreSQL 8.1.1 on the WindowsXP box with following
information:

1. Programming Language C# MS .NET Framework
2. ADO NET connection through PostgresODBC
3. Using "Connection.BeginTransaction(IsolationLevel.ReadCommitted) and
Transaction.Commit to update database.
4. Update record by record.
5. There is no problem if the records is less than 1000 records.
6. If records is over 1000 records, I got the error message "The
connection is dead".

How can I configure the PostgreSQL 8.1.1 to handle it.

Thank you for any suggestion.

Pairat