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
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
Thanks for any tips, experience, suggestions.
mmurrain at dbdes.com
In separateness lies the world's great misery; in compassion lies the
world's true strength. -- Buddha
pgsql-odbc by date
|Next:||From: Joost Kraaijeveld||Date: 2005-02-15 18:19:35|
|Subject: Re: Bug in ODBC driver 08.00.0004 and stored procedure|
|Previous:||From: Steven Backman||Date: 2005-02-15 14:28:32|
|Subject: connection woes|