What does your code look like? And have you tried using Npgsql instead of
the ODBC driver?
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of pairat@rachada.com
Sent: Saturday, January 07, 2006 4:39 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] The connection is dead
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.15/223 - Release Date: 1/6/2006