connection woes
От | Steven Backman |
---|---|
Тема | connection woes |
Дата | |
Msg-id | 6.2.1.2.2.20050215092543.04db7068@pop.earthlink.net обсуждение исходный текст |
Список | pgsql-odbc |
We have a MS Access 2000 database connecting to psgl 7.4.5 database over the Internet using ODBC 7.03.02.00 drivers. The connection works sometimes and then fails sporadically and unpredictably. When it fails, it could be just opening a table or it could be in a bound form. When it fails, we sometimes get an ODBC connection error. Sometimes, the table opens up with each cell filled with #delete#. I'm looking for some general troubleshooting guidelines. What makes this frustrating is that we have other experience using essentially the same techniques that have much greater stability. We are reasonably proficient with both pg and Access in general, and have naive to moderate experience, but until now good luck with the odbc drivers. I could say more about what we have checked or have suspected. Bandwidth? Table relations? Presence of text/memo fields? nature of ID fields? For initial post, I think I will just see what pops up. Very frustrating.
В списке pgsql-odbc по дате отправления: