postdrv ODBC driver problems
От | Ben Gunter |
---|---|
Тема | postdrv ODBC driver problems |
Дата | |
Msg-id | 36DCB277.498738E0@alef.gcsu.edu обсуждение исходный текст |
Список | pgsql-interfaces |
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
В списке pgsql-interfaces по дате отправления: