Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables

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 (view raw or flat)
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

pgsql-odbc by date

Next:From: Chris HooverDate: 2006-05-09 23:29:24
Subject: Terminating Idle Connections
Previous:From: noreplyDate: 2006-05-09 13:48:56
Subject: [ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group