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