Access 2002/PostgreSQL ODBC Inactivity
От | Alan R. Johns |
---|---|
Тема | Access 2002/PostgreSQL ODBC Inactivity |
Дата | |
Msg-id | NEBBJIECOLDILFFDGNMNOEHDCPAA.alan@graphicsuniversal.com обсуждение исходный текст |
Список | pgsql-odbc |
This issue has been discussed briefly before: Using Access 2002 with PostgreSQL ODBC v7.2.3 (or any version for that matter) after a period of inactivity, Access will crash with either: "Faulting application msaccess.exe, version 10.0.4302.0, faulting module unknown, version 0.0.0.0, fault address 0x0000176d." OR When you try to close the forms you'll get an endless "This action will reset the current code in break mode.". The only way out of Access is to terminate the process. I've been continuing to research this problem. I found some messages from people using MySQL ODBC having the exact same problem. One guy suggested changing the ODBC connection timeout in the registry: Go to : [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC] Set: ConnectionTimeout = 0 0 means never disconnect. I know this is probably not a recommended setting, but it has solved my problem thus far. The default registry setting is 600 (10 minutes). I experimented setting it to 10 seconds and turning on CommLog and Mylog in the ODBC driver. After approximately one minute of inactivity, I was almost guaranteed Access would crash. This seems to be the key to what causes Access 2002 to crash. When Access drops the connection with the server and then tries to reestablish it (when activity resumes), it inevitably crashes. I've attached a small portion of the commlog, but it really just shows nothing more than the ODBC driver reestablishing the connection and returning 10 rows. MyLog shows nothing out of the ordinary either. Another possible solution is to lower the ODBC Refresh Interval (Options-Advanced) to a number lower than the registry's connect timeout. However, I have STILL had Access crash on me in this situation. Obviously, Access is the problem here. I'm not suggesting there is anything wrong with the PostgreSQL ODBC driver. I'm just trying to provide some information for others who may run into this problem. BTW: I'm using the latest Office XP SP2 for Access. The OS doesn't seem to matter. I've seen it crash on Win98, 2000 SP2, and XP SP1. Access 2000 does not seem to have this problem at all. I'd be happy to downgrade to 2000, but I've already created my app with many of the enhanced printing functions in 2002. Anyone else have any other suggestions? (Besides getting rid of Access <G>) -Alan
Вложения
В списке pgsql-odbc по дате отправления: