From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables |
Date: | 2006-05-09 14:18:39 |
Message-ID: | 20060509141839.5F71D86C4E7@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)hspostgresodbc) from PostgreSQL using PostgreSQL ODBC (v. 08.01.0200). This functionality is essential to be able to 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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Hoover | 2006-05-09 23:29:24 | Terminating Idle Connections |
Previous Message | noreply | 2006-05-09 13:48:56 | [ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables |