From: Ben Gunter <bgunter@alef.gcsu.edu>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: postdrv ODBC driver problems
Date: Tue, 02 Mar 1999 22:54:31 -0500
Message-ID: <36DCB277.498738E0@alef.gcsu.edu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bgunter@alef.gcsu.edu
Subject: Re: postdrv ODBC driver problems
In-Reply-To: <36DCB277.498738E0@alef.gcsu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox