Re: Problems with ODBC and Access

Hi,

1) I suggest you try another version of the driver, such as:

ODBC 7.03.02.08
or
ODBC 7.03.02.09

I use version 08, and never had any kind of problem with it.

You can also try the 8.XX.XX.XX version, I'm sure.

2) Update the MDAC of your computer.

http://msdn.microsoft.com/data/Default.aspx

MDAC 2.8 works fine for me, from NT 4 to XP...

3) Check also your ODBC Timeout. I set it to 0 all the time:

-----
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC]
"ConnectionTimeout"=dword:00000000
-----

or

-----
REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC]
"ConnectionTimeout"=dword:00000000
-----

4) Finally, make sure that you refresh your linked tables when you make a change in the database. If you do not do it, results are sometimes unpredictable, but I noticed in practice that it depends on a number of factors, such as the OS used...

Your results are welcome!

Hope it will help.

Philippe Lang
Attik System

-----Message d'origine-----
De : pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Michelle Murrain
Envoyé : mardi, 15. février 2005 19:14
À : pgsql-odbc(at)postgresql(dot)org
Cc : Steve Backman
Objet : [ODBC] Problems with ODBC and Access

Hi All,

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.

Thanks for any tips, experience, suggestions.

Michelle

Michelle Murrain
mmurrain at dbdes.com
617-248-0007
952-674-7253 fax
Page: pageme(at)murrain(dot)net
AIM:pearlbear0 ICQ:129250575
Yahoo:michelle_murrain MSN:michelle(at)murrain(dot)net
Jabber: pearlbear(at)transactim(dot)net

In separateness lies the world's great misery; in compassion lies the world's true strength. -- Buddha

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings