After version 0.95 of PgAccess was released (thanks so much for the
quick response!), I figured my problems with character case were
resolved. Unfortunately, I tried to use the ODBC driver with MS Excel
97, and encountered the same problem. Tables with mixed case field
names gave me errors, and tables with all lower case field names worked.
MS Query could see the table fine (named "Present") and reported the
names of the fields fine ("First Name" and "Last Name"), but it failed
when I actually executed the query. It said: func_get_detail: no such
attribute or function "lastname".
This looks like the same problem I was having with PgAccess. Am I
missing something?
I'm using version 6.40.0004 of the ODBC driver, and PostgreSQL 6.4.2.
I'm sorry I don't have the logs right now. I can't get to the machines
I use Windows on until tomorrow. It shouldn't be too difficult to
recreate the error if you want to look into it. Just try to access a
table that uses mixed case field names and/or spaces. If you still want
to see the logs, let me know; I'll try to send them tomorrow.
Thanks,
Ben