Dg4odbc Connection To Netazza Gives Error HY000 NativeErr = 33 (Doc ID 1402484.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Linux x86-64
***Checked for relevance on 12-Aug-2013***

Symptoms


Trying to set up Database Gateway for ODBC  (DG4ODBC) 11.2 connection to a Netezza database gives the following error on a select -

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
Server and/or port attributes are empty {HY000,NativeErr = 33}
ORA-02063: preceding 2 lines from TEST_GATEWAY


The NZODBCSQL utility using the same driver and odbc.ini file gives a successful connection -

NZODBCSQL - program to test Netezza ODBC driver

Usage : <exe> <DSN> [Max-rows]
1 - Data Source Name - mandatory
2 - Maximum rows to display - optional; default 100
Type 'quit' or '\q' or CTRL-D or ENTER at the prompt to quit
NOTE: Max 100 rows are displayed (for selects)

Driver version : 'Release 6.0.3 (P-2) [Build 18503]'
NPS version : '06.00.0003 Release 6.0.3 (P-3) [Build 19720]'
Database : 'ABCD'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms