Trouble connecting through NAT-Router

From: postgresql(at)thomasbache(dot)de
To: pgsql-odbc(at)postgresql(dot)org
Subject: Trouble connecting through NAT-Router
Date: 2006-03-03 11:32:24
Message-ID: 20060303113224.DCF3E6EC074@mx01.asacom.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm facing a strange problem for some time now and still don't know a
fix. The trouble is with clients behind a NAT-Router. I connect with MS
Access 2000 using the 07.03.0200 ODBC driver, PG is running on linux in
version 7.3 and 8.0.1. Now this works fine for an unspecifiable amount
of time (sometimes 2 seconds, sometimes 8 hours). Suddenly the
connection to the database server breaks up - the forms in Access show
#name?, every query returns an exception.
On a really old router I found an option called "TCP Masquerading
Timeout" and playing with it seemed to have an influence on the
phenomenon.

My assumption now is: if the tcp-connection breaks up because the router
doesn't have enough memory for all the connections, the driver does not
reconnect to the database server. Actually this seems quite unrealistic
to me, but what is actually going on?

Thanks for help,
Tom

Browse pgsql-odbc by date

  From Date Subject
Next Message Theerasak Maneeneim 2006-03-03 23:39:08 ODBC - Recordset missing value when i migrate to postgresql 8.1
Previous Message Patrick Donelan 2006-03-03 10:56:01 Re: Visual Studio Query Builder filter