Hi, I am doing some oracle (10g)->netezza integrations. I have the Netezza OLEDB, ODBC and JDBC adapters installed. TOS 3.2.2.r33000 I can connect to both Oracle or Netezza from TOS without problems using ODBC DSNs.
If I try to connect to Netezza using the Netezza driver with credentials that work in both ODBC and Aginity I get: Connection failure. You must change the database settings under Details>> I get org.netezza.Driver
FWIW I also find I cannot connect to Oracle OR Netezza using generic JDBC although I can connect to a localhost ORCL instance without problems. If I run nzjdbc.jar to run a config I can connect OK to the Netezza server. Any ideas why I cannot get TOS to talk natively (?) to Netezza or how I can debug the JDBC connections? BTW do we need a standard Netezza tag on the forums? T
Resolved after ticket raised - appears to be a combination of nzjdbc.jar version conflict (less likely) and lack of nzjdbc.jar in a lib/java folder (which had not been created by the installer)
I have also now written a simple JDBC test harness in Java and run it to determine that I can connect to Netezza OK independently of TOS and it works fine.
So the problem remains - how come TOS cannot make the JDBC connection?
T
Resolved after ticket raised - appears to be a combination of nzjdbc.jar version conflict (less likely) and lack of nzjdbc.jar in a lib/java folder (which had not been created by the installer)
