Driver, provider, and appliance software compatibility
The table in this topic shows the compatibility between the IBM® Netezza® driver or provider versions and the Netezza appliance software versions.
The appliance software versions and the driver and provider versions that are shown are baseline versions. To ensure up-to-date capability, always check the Netezza site for the latest version. Different driver and provider and Netezza software versions might have different available functions, so you might need to change your driver or provider version or software version to take advantage of more features.
| Implementation | Netezza driver or provider | Netezza appliance software |
|---|---|---|
| ODBC |
7.0.x
7.1.x 7.2.x |
5.0.x, 6.0.x, 7.0.x, 7.1.x, 7.2.x
6.0.x, 7.0.x, 7.1.x, 7.2.x 7.0.x, 7.1.x, 7.2.x |
| JDBC |
7.0.x
7.1.x 7.2.x |
5.0.x, 6.0.x, 7.0.x, 7.1.x, 7.2.x
6.0.x, 7.0.x, 7.1.x, 7.2.x 7.0.x, 7.1.x, 7.2.x |
| OLE DB |
7.0.x
7.1.x 7.2.x |
5.0.x, 6.0.x, 7.0.x, 7.1.x, 7.2.x
6.0.x, 7.0.x, 7.1.x, 7.2.x 7.0.x, 7.1.x, 7.2.x |
| .NET |
7.2.1 and later |
7.2.1.x and later
|
If you have a more recent driver and you must connect to a system that runs an older Netezza release, a set query returns an error if the Netezza system does not support the field that is being set.