Thread: [ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables
[ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables
From
Date:
Bugs item #1000639, was opened at 2006-05-09 13: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 ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000639&group_id=1000125