Oracle Database Discussions

Hello everyone. I have been trying to get a DBLINK working between Oracle 11.2 & PostgreSQL. We've had a plethora of errors... However, instead of trying to explain them I'm just going to post all of the errors, the trace & all my settings. ALl though first, here is a quick paste of the error I'm getting.
I had to cut off part of the trace for length. But it kinda repeats itself
Thanks in advance for any help.

This is the error we're getting from the Oracle Developer program

SQL> /
select * from ods_md__product@denodo_dblink
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
No query has been executed with that handle {HY000,NativeErr = 1}No query has
been executed with that handle {HY000,NativeErr = 1}
ORA-02063: preceding 2 lines from DENODO_DBLINK

And this is a rough idea of what comes from the trace.

Entered hgopoer at 2012/07/12-16:12:35
hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...
No query has been executed with that handle {HY000,NativeErr = 1}No query has been executed with that handle {HY000,NativeErr = 1}
Exiting hgopoer, rc=0 at 2012/07/12-16:12:35
hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
Exiting hgopars, rc=28500 at 2012/07/12-16:12:35 with error ptr FILE:hgopars.c LINE:556 FUNCTION:hgopars() ID:Preprocess number of columns
hostmstr: 0: HOA After hoxpars
hostmstr: 0: RPC After SQL Bundling



I'm using Oracle for Heterogeneous environments 11.2 on RHEL 5.4
Connecting to Denodo on Windows which uses PostgreSQL drivers
unixODBC 2.2.12
psqlodbc drivers 08.04.0200


odbc.ini


[VDP_acme_DSN]
Description = VDP connection
Driver = postgreSQLDriver
Trace = no
TraceFile = /tmp/trace.log
Debug = no
DebugFile = /tmp/debug.log
Database = aaa_ncnu
Servername = *.*.*.*
UserName = admin
Password = admin
Port = 9996
Protocol = 7.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
LFConversion = Yes
UpdatableCursors = Yes
BoolsAsChar = Yes
UniqueIndex = Yes
ServerType = Postgres
ConnSettings =
UseServerSidePrepare= 0
ByteaAsLongVarBinary= 1
Optimizer = 0
Ksqo = 0

[ODBC]
TraceFile=/tmp/sql.log
Trace=1

odbcinst.ini
[postgreSQLDriver]
Description = PostgreSQL 08.04.0200 driver
Driver = /usr/local/lib/psqlodbcw.so
UsageCount = 1


initVDP_acme_DSN.ora
HS_FDS_CONNECT_INFO = VDP_acme_DSN
HS_FDS_TRACE_LEVEL = DEBUG
#HS_FDS_TRACE_LEVEL = 255
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so
HS_LANGUAGE = american_america.we8mswin1252

#
# ODBC specific environment variables
#
set ODBCINI=/usr/local/etc/odbc.ini


tnsnames.ora
ETLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ETLD)
)
)

VDP_acme_DSN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Localhost)(PORT = 1527))
(CONNECT_DATA =
(SERVICE_NAME = VDP_acme_DSN)
)
(HS=OK)
)

boldlistener.ora*bold*



LISTENER_TG =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1527))
)
SID_LIST_LISTENER_TG =

(SID_LIST =
(SID_DESC =
(SID_NAME = VDP_acme_DSN)
(ORACLE_HOME =/app/oracle/product/11.2/tghome_1 )

(ENV="LD_LIBRARY_PATH=/usr/local/lib:/app/oracle/product/11.2/tghome_1/lib")
(PROGRAM = dg4odbc))
)


I've posted a copy of my oracle trace on pastebin cause of length

http://pastebin.com/2qbgJL03

Same with my ODBC trace

http://pastebin.com/2FU9nRCS