Postgres Pro
Downloads
Home   >   mailing lists

ODBC Driver problem - Mailing list pgsql-odbc

From anthony.caduto@micorp.com
Subject ODBC Driver problem
Date
Msg-id OF27D84DF9.C563CBF7-ON86256F1D.00599433-86256F1D.005A1361@micorp.com
Whole thread Raw
List pgsql-odbc
Tree view

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

pgsql-odbc by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: basic questions with odbc and visual basic.
Next
From: "Merlin Moncure"
Date:
Subject: Re: ODBC Driver problem