Kurt Roeckx wrote:
> When I'm using a table with capitals from excel or something,
> using microsoft query, I get an error that the relation
> "public"."table" doesn't exist.
> I noticed that I got simular errors when I didn't put quotes
> around the name of the table. I assume it's the same problem
> When I rename the table/column to lower case it works.
> Is this a problem in the ODBC driver, or in microsoft query?
Maybe the latter. For example if there's a table named
"AbC", MS query issues a command like 'select ...
from AbC' whereas MS Access issues a double-quoted query
like 'select ... from "AbC"'.
> If the later, can it be fixed in the ODBC driver?
How can we fix it without affecting existent applications
which use the driver ?
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2002-12-17 00:31:53|
|Subject: Re: Max LongVarChar|
|Previous:||From: terry||Date: 2002-12-16 21:31:00|
|Subject: Re: Version numbers and downloads|