Oracle Database Discussions

Hi,

I am trying to access a postgresql dataface with dg4odbc but I am facing some issue.

I can connect from isql and get table result but when I try to do the same from oracle, I got an issue...

Any help is welcome...

Thx

François

Connection with ISQL

isql Aquiweb

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL> select count(*) from role;

+---------------------+

| count               |

+---------------------+

| 17                  |

+---------------------+

SQLRowCount returns 1

1 rows fetched

Connection from sqlplus:

SQL> select count(*) from "role"@PG_LINK;

select count(*) from "role"@PG_LINK

                            *

ERROR at line 1:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

ORA-02063: preceding line from PG_LINK

Herer are my config files:

initPG_link.ora

HS_FDS_CONNECT_INFO = Aquiweb
HS_FDS_TRACE_LEVEL = 255

HS_FDS_SHAREABLE_NAME = /usr/lib64/unixODBC_23/libodbcpsql.so

set ODBCINI=/etc/unixODBC_23/odbc_23.ini
set ODBCINSTINI=/etc/unixODBC_23/odbcinst_23.ini

my ODBC_23.ini

[Aquiweb]

Description         = Test to Postgres

Driver              = PostgreSQL

Database            = aquiweb

Servername          = 128.1.10.50

UserName            = mecar

Password            =XXXXX

Port                = 5432

Protocol            = 9.3

ReadOnly            = No

RowVersioning       = No

ShowSystemTables    = No

ConnSettings        =

Trace = 2

TraceFile = /var/log/PostgreSQL_test_trace.log

Debug = 0

DebugFile = /var/log/PostgreSQL_test_debug.log

my odbcinst_23.ini file

[PostgreSQL]

Description=PostgreSQL driver

Driver64=/usr/lib64/unixODBC_23/libodbcpsql.so

FileUsage=1

The oracle log

Oracle Corporation --- FRIDAY FEB 19 2016 16:41:24.071

Heterogeneous Agent Release

11.2.0.2.0

Oracle Corporation --- FRIDAY FEB 19 2016 16:41:24.071

  Version 11.2.0.2.0

Entered hgogprd

HOSGIP for "HS_FDS_TRACE_LEVEL" returned "255"

Entered hgosdip

setting HS_OPEN_CURSORS to default of 50

setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"

setting HS_FDS_RECOVERY_PWD to default value

setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG

setting HS_IDLE_TIMEOUT to default of 0

setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"

setting HS_NLS_NCHAR to default of "AL32UTF8"

setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"

setting HS_FDS_DATE_MAPPING to default of "DATE"

setting HS_RPC_FETCH_REBLOCKING to default of "ON"

setting HS_FDS_FETCH_ROWS to default of "100"

setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"

setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"

setting HS_FDS_PROC_IS_FUNC to default of "FALSE"

setting HS_FDS_MAP_NCHAR to default of "TRUE"

setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"

setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"

setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"

setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"

setting HS_FDS_QUERY_DRIVER to default of "TRUE"

setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"

Parameter HS_FDS_QUOTE_IDENTIFIER is not set

setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"

setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"

setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"

Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION

setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"

setting HS_FDS_DELAYED_OPEN to default of "TRUE"

setting HS_FDS_WORKAROUNDS to default of "0"

Exiting hgosdip, rc=0

ORACLE_SID is "PG_LINK"

Product-Info:

  Port Rls/Upd:2/0 PrdStat:0

  Agent:Oracle Database Gateway for ODBC

  Facility:hsa

  Class:ODBC, ClassVsn:11.2.0.2.0_0008, Instance:PG_LINK

Exiting hgogprd, rc=0

hostmstr: 0: HOA After hoagprd

hostmstr: 0: HOA Before hoainit

Entered hgoinit

HOCXU_COMP_CSET=1

HOCXU_DRV_CSET=2

HOCXU_DRV_NCHAR=873

HOCXU_DB_CSET=2

HS_LANGUAGE not specified

LANG=en_US.UTF-8

HOCXU_SEM_VER=112000

Entered hgolofn at 2016/02/19-16:41:24

HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/unixODBC_23/libodbcpsql.so"

Entered hgolofns at 2016/02/19-16:41:24

libname=/usr/lib64/unixODBC_23/libodbcpsql.so, funcname=SQLAllocHandle

peflerr=6520, libname=/usr/lib64/unixODBC_23/libodbcpsql.so, funcname=SQLAllocHandle

hoaerr:28500

Exiting hgolofns at 2016/02/19-16:41:24

Failed to load ODBC library symbol: /usr/lib64/unixODBC_23/libodbcpsql.so(SQLAllocHandle)

Exiting hgolofn, rc=28500 at 2016/02/19-16:41:24

Exiting hgoinit, rc=28500 with error ptr FILE:hgoinit.c LINE:417 FUNCTION:hgoinit() ID:Loading ODBC aray of function ptrs

hostmstr: 0: HOA After hoainit

RPC Calling nscontrol(0), rc=0

hostmstr: 0: RPC Before Exit Agent

hostmstr: 0: HOA Before hoaexit

Entered hgoexit

HS Gateway: NULL connection context at exit

Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:110 FUNCTION:hgoexit() ID:Connection context

hostmstr: 0: HOA After hoaexit

hostmstr: 0: RPC After Exit Agent