From: | Claus Scherschel <claus(dot)scherschel(at)arcor(dot)de> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Selecting schemas in ODBC/Win32 |
Date: | 2005-11-09 16:57:26 |
Message-ID: | 43722a76$0$21947$9b4e6d93@newsread2.arcor-online.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi everyone,
I'm developping a scientific database using Postgres 8.0.1. For
testing purposes I set up a basic MS Access frontend connected via ODBC.
This consists of some linked tables only.
Now, with the release of Postgres 8.1 I decided to switch to the new
version. I reconfigured the existing DSN selecting the unicode-version
of the new ODBC drivers coming along with 8.1. Installing and migrating
the database wasn't a problem. But when I try to link some new tables
into the frontend I'm not able to select the public-schema, where my
tables are located.
The ODBC driver shows tables from the information_schema only. Adding a
SET SEARCH_PATH specifing the public-schema explicitly doesn't help.
Neither the ANSI-driver won't do nor creating a new DSN would help.
What's to be done, to have the choice what schema to connect with?
Re-linking existing tables is not a problem at all.
Kind regards,
Claus.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2005-11-09 17:17:11 | 08.00.0102 with UTF8 database causes client encoding mismatch error |
Previous Message | me | 2005-11-09 15:45:20 | Re: 8.1.1: recordset-paging severerly broken! |