Re: ODBC Driver problem - Mailing list pgsql-odbc

From Merlin Moncure
Subject Re: ODBC Driver problem
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A74CF@Herge.rcsinc.local
Whole thread Raw
In response to ODBC Driver problem  (anthony.caduto@micorp.com)
Responses Re: ODBC Driver problem
List pgsql-odbc
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

pgsql-odbc by date:

Previous
From: anthony.caduto@micorp.com
Date:
Subject: ODBC Driver problem
Next
From: anthony.caduto@micorp.com
Date:
Subject: Re: ODBC Driver problem