You are not logged in.
I am doing some oracle (10g)->netezza integrations.
I have the Netezza OLEDB, ODBC and JDBC adapters installed.
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
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?
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?
Can you report a bug on our bugtracker?
Thanks for your support!
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)