My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Linux x86-64


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'


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.