Thread: ODBC Driver problem
Hi,
I just installed the latest ODBC driver and it seems to be missing support for Postgresql 7.3 and up schemas (table namespaces)
I have a MS Access 97 app I would like to link a table to on my postgres server, but for whatever reason the odbc driver only brings back tables to select from the public schema
In Access I see:
public.mytable1
public.mytable2
I have several other schemas defined on my server and would really like to keep the data in the schemas since it makes organizing them much easier.
Shouldn't the ODBC driver be bringing back all the tables, not just those defined in public?
If anyone knows a way around this other than fixing the ODBC driver please let me know.
Thanks,
Tony Caduto
Senior Programmer/Analyst
M&I Trust and Investment Management
Hi, I just installed the latest ODBC driver and it seems to be missing support for Postgresql 7.3 and up schemas (table namespaces) [...] I had a similar problem when I installed the odbc driver from the postgresql 8.0 msi installation package. I downgraded to the latest stable odbc version on the project website and that fixed the problem. If you don't want to downgrade, one workaround that may or may not help is to have the odbc driver set the schema path when the driver connects. i.e. in odbc options put set search_path = s1, s2 where you can enter command connect string. Merlin
Hi,
The search path thing works :-)
Did you download the driver from the Gborg site or the postgresql.org site?
Thanks
Tony Caduto
Senior Programmer/Analyst
M&I Trust and Investment Management
| "Merlin Moncure" <merlin.moncure@rcsonline.com> Sent by: pgsql-odbc-owner@postgresql.org 09/28/2004 11:28 AM |
|
Hi,
I just installed the latest ODBC driver and it seems to be missing
support for Postgresql 7.3 and up schemas (table namespaces)
[...]
I had a similar problem when I installed the odbc driver from the
postgresql 8.0 msi installation package. I downgraded to the latest
stable odbc version on the project website and that fixed the problem.
If you don't want to downgrade, one workaround that may or may not help
is to have the odbc driver set the schema path when the driver connects.
i.e. in odbc options put
set search_path = s1, s2
where you can enter command connect string.
Merlin
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
> Did you download the driver from the Gborg site or the postgresql.org site? Gborg. Merlin