I'm currently working on configuring Information Server to work with Netezza. Just trying to start with a simple
![Laughing :lol:](./images/smilies/icon_lol.gif)
I have installed the Netezza 4.5.0 ODBC drivers to the following location :
Code: Select all
/as_edw_wwt03/Netezza/npsclient450
Code: Select all
drwxr-xr-x 2 dsadm irm 4096 May 14 18:06 .
drwxrwxr-x 9 dsadm irm 256 Sep 29 21:21 ..
-r--r--r-- 1 dsadm irm 7151 May 14 17:27 ODBC_README
-rwxr-xr-x 1 dsadm irm 2612133 May 14 17:56 libnzodbc.a
-rwxr-xr-x 1 dsadm irm 16120933 May 14 17:56 libnzodbcT_I_U16.so
-rwxr-xr-x 1 dsadm irm 16120231 May 14 17:56 libnzodbcT_I_U32.so
-rwxr-xr-x 1 dsadm irm 16118506 May 14 17:56 libnzodbcT_I_U8.so
-rwxr-xr-x 1 dsadm irm 227178 May 14 17:56 libnzodbcT_L9_U16.so
-rwxr-xr-x 1 dsadm irm 227274 May 14 17:56 libnzodbcT_L9_U32.so
-rwxr-xr-x 1 dsadm irm 224415 May 14 17:56 libnzodbcT_L9_U8.so
lrwxrwxrwx 1 dsadm irm 11 Sep 29 21:21 libnzsqlodbc3.so -> libnzodbc.a
lrwxrwxrwx 1 dsadm irm 20 Sep 29 21:21 libnzsqlodbc3_64bit.so -> ../lib64/libnzodbc.a
-r--r--r-- 1 dsadm irm 76 May 14 18:06 nzjdbc.ini
-rwxr-xr-x 1 dsadm irm 225319 May 14 18:06 nzjdbc3.jar
-r--r--r-- 1 dsadm irm 778 May 14 17:27 odbc.ini.sample
-r--r--r-- 1 dsadm irm 422 May 14 17:27 odbcinst.ini.sample
Code: Select all
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:/as_edw_wwt03/Netezza/npsclient450/lib/:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:$ASBHOME/app
s/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc:$ORACLE_HOME/lib32:$LIBPATH
export LIBPATH
Code: Select all
[netezza_poc]
Driver=/as_edw_wwt03/Netezza/npsclient450/lib/libnzsqlodbc3.so
Description=NetezzaSQL ODBC
ServerName=brkcla01-odbc
PortNumber=5480
Database=navistar
Username=admin
Password=password
ReadOnly=false
ShowSystemTables=false
LegacySQLTables=false
LoginTimeout=0
QueryTimeout=0
DateFormat=1
NumericAsChar=false
SQLBitOneZero=false
StripCRLF=false
securityLevel=preferredUnSecured
caCertFile =
Here is the entry in the uvodbc.config file:
Code: Select all
<netezza_poc>
DBMSTYPE = ODBC
Here is the output of the "example" ODBC test executable in the branded_odbc directory:
Code: Select all
brksvx41a:/as_edw_wwt03/IBM/InformationServer/Server/branded_odbc/example>example
example DataDirect Technologies, Inc. ODBC Example Application.
Enter the data source name : netezza_poc
Enter the user name : admin
Enter the password : password
SQLSTATE = HY000
NATIVE ERROR = 33
MSG = Server and/or port attributes are empty
SQLConnect: Retrying Connect.
SQLSTATE = HY000
NATIVE ERROR = 33
MSG = Server and/or port attributes are empty
SQLConnect: Retrying Connect.
SQLSTATE = HY000
NATIVE ERROR = 33
MSG = Server and/or port attributes are empty
SQLConnect: Retrying Connect.
brksvx41a:/as_edw_wwt03/IBM/InformationServer/Server/branded_odbc/example>
I would be greatful to anyone who can add a new perspective on this case. I've been working with both IBM and Netezza, but no answer yet. I have tried all possible combinations of Server/Servername/ServerName and Port/Portnumber/PortNumber as well to insure that it's not just a simple variable name problem.
Thanks for your time and help,
Steve
P.S. Who's going to be the first to reply with an answer that will force me to become a premium member
![Cool 8)](./images/smilies/icon_cool.gif)