weird Access problem
От | Louis Bertrand |
---|---|
Тема | weird Access problem |
Дата | |
Msg-id | Pine.BSO.4.10.9911220134090.19087-100000@tronix.bertrandtech.on.ca обсуждение исходный текст |
Список | pgsql-interfaces |
Hello all, I connect to a postgresql database from MS Access and I see some weird things in the postgresql log in C:\psqlodbc_XXX.log. I am using an Access form to enter data into a table, and the sql log has these insane long lines with repeated OR terms: conn=43911292, query='SELECT "SystemID","MailingListID","SystemType" FROM "Systems" WHERE "SystemID" = 'system5' OR "SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" = 'System34'' [ fetched 2 rows ] Access freezes up (Task not responding, ctrl-alt-del > "End task" works) if I keep working after this starts happening. Using Access97 SR-1 on Win95 with iodbc 6.40.0007. The tables in Access are "linked" to those in pgsql via a system DSN. PostgreSQL is running on OpenBSD 2.6. Is this a problem with Access or with the way I'm using the connectivity? I'm not a guru; I'm just trying to set up a simple demo and I'd rather it didn't crash while I'm running it. Thanks--Louis <louis@bertrandtech.on.ca> Louis Bertrand http://www.bertrandtech.on.ca/ Bertrand Technical Services, Bowmanville, ON, Canada OpenBSD: Secure by default. http://www.openbsd.org/
В списке pgsql-interfaces по дате отправления: