Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Below are four Netezza drivers that are available for Netezza 6.0.8. I installed the second one on Windows Server 2008, and it placed it into the system32 folder (64 bit folder). However, when I set up the System tab ODBC drivers, and used the same configuration and credentials that I use on Windows XP, the connection test failed.

Do I need to do something special on Windows Server to get the Netezza driver working? Or perhaps I installed the incorrect driver? Does anyone know the difference between these?

enter image description here

enter image description here

share|improve this question

1 Answer 1

[Not really an answer as I'm just stating the obvious but I don't have enough rep to comment.]

The four driver files are the ODBC driver, the JDBC driver, and the 32 and 64-bit OLEDB drivers. The ODBC driver is of course the correct one but there's a small check box in one of the installer dialogs which allows you to choose 32-bit and/or 64-bit. Did you select the correct one?

I've just tried this on Windows Server 2012 and Windows 7 and both work exactly the same for me without any extra steps. The driver I have is called nsqlodbc.dll, version 7.0.0.27274, in C:\Windows\System32 (and I also have a 32-bit version in C:\Windows\SysWOW64). I can connect from both the 32-bit and 64-bit ODBC Data Source Administrator tools although I got my password wrong several times so that's certainly worth checking.

Have you also checked that the advanced options are the same, SSL for instance?

Possibly there's a security setting on your Server box that's preventing the connection but on 2012 Server there didn't appear to be anything by default.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.