ODBC Dies after Dialup-network reconnects
От | Thomas Quiring |
---|---|
Тема | ODBC Dies after Dialup-network reconnects |
Дата | |
Msg-id | 4059DC37.8090704@gsacomp.com обсуждение исходный текст |
Список | pgsql-odbc |
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>
В списке pgsql-odbc по дате отправления: