topic Re: [resolved] Cannot connect using Netezza driver in Talend Studio

[resolved] Cannot connect using Netezza driver

Anonymous — Sat, 16 Nov 2024 13:39:45 GMT

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

Re: [resolved] Cannot connect using Netezza driver

Anonymous — Tue, 01 Dec 2009 16:50:13 GMT

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

Re: [resolved] Cannot connect using Netezza driver

Anonymous — Wed, 02 Dec 2009 05:41:00 GMT

Hello
Can you report a bug on our bugtracker?
Thanks for your support!
Best regards

shong

Re: [resolved] Cannot connect using Netezza driver

Anonymous — Wed, 02 Dec 2009 09:11:53 GMT

Done - Issue 10407 raised

Re: [resolved] Cannot connect using Netezza driver

Anonymous — Fri, 04 Dec 2009 16:03:28 GMT

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)

Re: [resolved] Cannot connect using Netezza driver

PDublish1651071668 — Wed, 27 Apr 2022 15:14:19 GMT

I am trying to connect Netezza and getting same issue: Connection failure. You must change the database settings

However, Installing supportive nzjdbc driver, not resolved issue.

Please help me what extra jar files should I add to resolve it.