ODBC Dies after Dialup-network reconnects

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


Thomas QuiringGSA Computer Services
Senior Software Developer45 Hannover Drive
tom@gsacomp.comSt. Catharines, ON, CANADA
www.gsacomp.com905.641.5061
--
"Great minds think alike -- Idiots seldom differ"

В списке pgsql-odbc по дате отправления: