Bugs item #1000639, was opened at 2006-05-09 15:48
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000639&group_id=1000125
Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables
Initial Comment:
Oracle 10g is not able to read the database table names (all_tables and all_objects, es. select * from
all_tables@hspostgresodbc)from PostgreSQL using PostgreSQL ODBC (v. 08.01.0200). This functionality is essential to be
ableto use Oracle Warehouse Builder and import external database definitions (heterogeneous services).
However, Oracle (SQL*Plus) is able to retrieve records when the table name is stated in the SQL query (es. select *
from“my_table”).
The problem seems to be with the PostgreSQL ODBC because Oracle is able to read schemes from other databases through
ODBC.I’ve done some tests with Access dbs just to be sure that the problem is not with my system (Windows XP SP2).
The problem appears both with ANSI and UNICODE PostgreSQL drivers.
Best regards,
Raoni
----------------------------------------------------------------------
>Comment By: Ludek Finstrle (luf)
Date: 2006-05-09 16:18
Message:
Please, could you try psqlodbc 08.02.0002?
Regards,
Luf
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000639&group_id=1000125
