What does your code look like? And have you tried using Npgsql instead of the ODBC driver? -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of pairat@xxxxxxxxxxx Sent: Saturday, January 07, 2006 4:39 AM To: pgsql-general@xxxxxxxxxxxxxx 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
