<!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 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.<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>