Re: ODBC doesn't gets schemas

Поиск

Список

Период

Сортировка

От	Richard Wesley
Тема	Re: ODBC doesn't gets schemas
Дата	18 июня 2007 г. 14:34:19
Msg-id	DA94022A-8946-469C-96AE-02C7A43EE6F6@gmail.com обсуждение исходный текст
Ответ на	Re: ODBC doesn't gets schemas (Richard Broersma Jr <rabroersma@yahoo.com>)
Список	pgsql-odbc

Дерево обсуждения

On Jun 18, 2007, at 7:44 AM, Richard Broersma Jr wrote:

I am not sure I completely understand your problem, but my experiece is that schema name are
recognized by the ODBC driver. However, in my case I use MS Access, when I use ODBC to link table
from the PostgreSQL server the resolved schema.table names in Access are "schema_table".

We use the OLE DB wrapper for ODBC to talk to the driver and it appears to return both schema and table names. It doesn't set some of the flags (e.g. system tables) but there must be some way to get multi-part names back. MS SQL Server has hierarchical names and it presumably works with Access...

________________________________________________________

Richard Wesley Senior Software Developer Tableau Software

Visit: http://www.trytableau.com/now.html

В списке pgsql-odbc по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: ODBC doesn't gets schemas