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/
