Skip to Content

IDT vs. Netezza

I am working on a universe that connects to a Netezza 7 database using an ODBC connection. The 32-bit ODBC system DSN is correctly set up and working on my laptop - currently, it is the only DSN on my laptop and there are no 64-bit DSNs. I can connect to the database fine through Aginity, so I know that my credentials work. However, when I try to create a relational connection to the database (either local or on the server) in the IDT, I see two data source names, neither of which is the DSN that I configured.

How do I find where these are configured so that I can make sure that I can see the connection that I need?

Thanks!

-Dell

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 14, 2018 at 07:36 PM

    I think I just answered my own question - I was in the wrong version of the ODBC Administrator when I configured the connection. It's all working now.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14, 2018 at 06:38 PM

    Did you check the DSN in User DSN or system DSN?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14, 2018 at 07:05 PM

    Another piece of information - if I type/paste in the name of the correct ODBC data source, I get an ODBC error: "The specified DSN contains an architecture mismatch between the driver and application."

    -Dell

    Add comment
    10|10000 characters needed characters exceeded