Thread: ODBC Dies after Dialup-network reconnects

Hello All,<br /><br /> Here's the problem.. we have clients (MS Access) dialing out to the internet and sending data
toa Postgres server. Everything  works fine until you disconnect the internet and reconnect it. After reconnection to
theinternet no ODBC connections work ("ODBC Call Failed").  If we exit Access and then try it again it works.<br /><br
/>It seems like access or the odbc is caching the socket connections, or maybe pooling the connections/socket.<br /><br
/>Is there any way we can refresh our ODBC connection to Postgres without restarting access?<br /><br /> If any brave
soulwants to look through my odbc log files then let me know and I'll create a test and forward them.<br /><br /> Any
helpis appreciated, <br /><div class="moz-signature">Tom<br /><br /><br /><table border="0" cellspacing="0"
width="50%"><tbody><tr><td>ThomasQuiring</td><td>GSA Computer Services</td></tr><tr><td>Senior Software
Developer</td><td>45Hannover Drive</td></tr><tr><td><a class="moz-txt-link-abbreviated"
href="mailto:tom@gsacomp.com">tom@gsacomp.com</a></td><td>St.Catharines, ON, CANADA</td></tr><tr><td><a
class="moz-txt-link-abbreviated"href="http://www.gsacomp.com">www.gsacomp.com</a></td><td>905.641.5061</td></tr><tr><td
colspan="2">--</td></tr><tr><tdcolspan="2">"Great minds think alike -- Idiots seldom
differ"</td></tr></tbody></table></div>

I'm no expert with PostgreSQL ODBC in particular, but I have never used any
other ODBC driver that could maintain an ODBC connection when the physical
connection was closed.  If you need something like that, I think you will
need to open your own ADO connections in code and close them after each
interaction so they can be reopened cleanly again later.  Whether Access is
helpful as a front-end in this configuration is a good question.

On Thursday, March 18, 2004 9:28 AM, Thomas Quiring [SMTP:tom@gsacomp.com]
wrote:
> Hello All,
>
> Here's the problem.. we have clients (MS Access) dialing out to the
internet and sending data to a Postgres server. Everything  works fine
until you disconnect the internet and reconnect it. After reconnection to
the internet no ODBC connections work ("ODBC Call Failed").  If we exit
Access and then try it again it works.
>
> It seems like access or the odbc is caching the socket connections, or
maybe pooling the connections/socket.
>
> Is there any way we can refresh our ODBC connection to Postgres without
restarting access?
>
> If any brave soul wants to look through my odbc log files then let me
know and I'll create a test and forward them.
>
> Any help is appreciated,
>
> Tom