https://community.qlik.com/t5/Talend-Studio/Netezza-Database-connection-error/m-p/2204340#M5267 I am now able to successfully run a simple job to extract and load tables in netezza. I'm not sure what the solution was, I re-created the job from scratch and it now works, in both tNetezzaInput/Output and ODBC components. Fri, 19 Dec 2008 19:40:19 GMT Anonymous 2008-12-19T19:40:19Z https://community.qlik.com/t5/Talend-Studio/Netezza-Database-connection-error/m-p/2204338#M5265 I'm attempting to connect to a Netezza server, and gettting an error. I've tried both the tNetezzaInput component, and the tJDBCInput connection, both generate the same error. <BR />The error: when I run a simple job to retrieve data: "A connection error has occurred: Invalid - database name" (full text below) <BR />I know that the underlying connection is good, as it is possible to create a new connection, then do "Import Schema" using both Netezza and JDBC options. The Import Schema correctly retreives various tables. <BR />Any ideas? <BR />Exception in component tNetezzaInput_2 <BR />org.netezza.util.PSQLException: A connection error has occurred: Invalid - database name <BR /> at org.netezza.core.PgHandshake.handshake(Unknown Source) <BR /> at org.netezza.core.PgHandshake.connect(Unknown Source) <BR /> at org.netezza.jdbc1.AbstractJdbc1Connection.handshake(Unknown Source) <BR /> at org.netezza.jdbc1.AbstractJdbc1Connection.openConnection(Unknown Source) <BR /> at org.netezza.Driver.getConnection(Unknown Source) <BR /> at org.netezza.Driver.connect(Unknown Source) <BR /> at java.sql.DriverManager.getConnection(Unknown Source) <BR /> at java.sql.DriverManager.getConnection(Unknown Source) <BR /> at testjava.testnetezza_0_1.testnetezza.tNetezzaInput_2Process(testnetezza.java:888) <BR /> at testjava.testnetezza_0_1.testnetezza.runJobInTOS(testnetezza.java:1547) <BR /> at testjava.testnetezza_0_1.testnetezza.main(testnetezza.java:1459) Sat, 16 Nov 2024 14:07:09 GMT https://community.qlik.com/t5/Talend-Studio/Netezza-Database-connection-error/m-p/2204338#M5265 Anonymous 2024-11-16T14:07:09Z https://community.qlik.com/t5/Talend-Studio/Netezza-Database-connection-error/m-p/2204339#M5266 Hello <BR />Can you connect to Netezza in metadata? <BR />Best regards <BR /> <BR /> shong Fri, 19 Dec 2008 03:16:13 GMT https://community.qlik.com/t5/Talend-Studio/Netezza-Database-connection-error/m-p/2204339#M5266 Anonymous 2008-12-19T03:16:13Z https://community.qlik.com/t5/Talend-Studio/Netezza-Database-connection-error/m-p/2204340#M5267 I am now able to successfully run a simple job to extract and load tables in netezza. I'm not sure what the solution was, I re-created the job from scratch and it now works, in both tNetezzaInput/Output and ODBC components. Fri, 19 Dec 2008 19:40:19 GMT https://community.qlik.com/t5/Talend-Studio/Netezza-Database-connection-error/m-p/2204340#M5267 Anonymous 2008-12-19T19:40:19Z