Skip site navigation (1) Skip section navigation (2)

ODBC Dies after Dialup-network reconnects

From: Thomas Quiring <tom(at)gsacomp(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC Dies after Dialup-network reconnects
Date: 2004-03-18 17:28:23
Message-ID: 4059DC37.8090704@gsacomp.com (view raw or flat)
Thread:
Lists: pgsql-odbc
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
Hello All,<br>
<br>
Here's the problem.. we have clients (MS Access) dialing out to the
internet and sending data to a Postgres server. Everything&nbsp; works fine
until you disconnect the internet and reconnect it. After reconnection
to the internet no ODBC connections work ("ODBC Call Failed").&nbsp; 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 soul wants to look through my odbc log files then let me
know and I'll create a test and forward them.<br>
<br>
Any help is appreciated, <br>
<div class="moz-signature">Tom<br>
<br>
<br>
<table width="50%" cellspacing="0" border="0">
  <tbody>
    <tr>
      <td>Thomas Quiring</td>
      <td>GSA Computer Services</td>
    </tr>
    <tr>
      <td>Senior Software Developer</td>
      <td>45 Hannover Drive</td>
    </tr>
    <tr>
      <td><a class="moz-txt-link-abbreviated"
 href="mailto:tom(at)gsacomp(dot)com">tom(at)gsacomp(dot)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>
      <td colspan="2">"Great minds think alike -- Idiots seldom differ"</td>
    </tr>
  </tbody>
</table>
</div>
</body>
</html>



Attachment: unknown_filename
Description: text/html (1.8 KB)

pgsql-odbc by date

Next:From: Steve JorgensenDate: 2004-03-18 20:51:30
Subject: Re: ODBC Dies after Dialup-network reconnects
Previous:From: Nick TexidorDate: 2004-03-18 13:36:17
Subject: Data Access Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group