Client Driver and Server Version Compatibility
Usually, each version of the Vertica server is compatible with previous versions of client drivers. This compatibility lets you upgrade your Vertica server without having to immediately upgrade your client software. Occasionally, however, individual features of a new server version might be unavailable through older drivers.
The following sections summarize compatibility of each recent version of client drivers with Vertica server versions.
Forward Compatibility
| Client | Client Driver Version | Compatible Server Versions |
|---|---|---|
| All Clients |
6.1.x |
6.1.x, 7.0.x, 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x, 10.0.x |
| 7.0.x | 7.0.x, 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x, 10.0.x | |
| 7.1.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x, 10.0.x | |
| 7.2.x | 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x, 10.0.x | |
| 8.0.x | 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x, 10.0.x | |
| 8.1.x | 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x, 10.0.x | |
| 9.0.x | 9.0.x, 9.1.x, 9.2.x, 9.3.x, 10.0.x | |
| 9.1.x | 9.1.x, 9.2.x, 9.3.x, 10.0.x | |
| 9.2.x | 9.2.x, 9.3.x, 10.0.x | |
| 9.3.x | 9.3.x, 10.0.x | |
| 10.0.x | 10.0.x |
FIPS 140-2 Compatibility
| Client | Client Driver Version | Compatible Server Versions |
|---|---|---|
| FIPS-enabled ODBC | 8.0.x | 8.0.x, 8.1.x |
| FIPS-enabled ODBC | 8.1.x | 8.0.x, 8.1.x |
| FIPS-enabled ODBC | 9.0.x | 8.0.x, 8.1.x, 9.0.x |
| FIPS-enabled ODBC | 9.1.x | 8.0.x, 8.1.x, 9.0.x, 9.1.x |
| FIPS-enabled JDBC | 8.1.x | 8.1.x |
| FIPS-enabled JDBC | 9.0.x | 8.1.x, 9.0.x |
| FIPS-enabled JDBC | 9.1.x | 8.1.x, 9.0.x, 9.1.x |
| FIPS-enabled JDBC | 9.2.x | 8.1.x, 9.0.x, 9.1.x, 9.2.x |
| FIPS-enabled JDBC | 9.3.x | No support. If you need FIPS support, install or stay on 9.2.x |
| FIPS-enabled JDBC | 10.0.x | No support. If you need FIPS support, install or stay on 9.2.x |
Backward Compatibility
ODBC client
| Client | Client Driver Version | Compatible Server Versions |
|---|---|---|
| ODBC (backwards compatibility) | 8.1.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x |
| ODBC (backwards compatibility) | 9.0.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x |
|
ODBC (backwards compatibility) |
9.1.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x |
|
ODBC (backwards compatibility) |
9.2.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x |
| ODBC (backwards compatibility) | 9.3.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x |
JDBC/ADO.NET clients
| Client | Client Driver Version | Compatible Server Versions |
|---|---|---|
|
JDBC and ADO.NET (backwards compatibility) |
9.1.1 | 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x |
|
JDBC and ADO.NET (backwards compatibility) |
9.2.x | 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x |
|
JDBC and ADO.NET (backwards compatibility) |
9.3.x | 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x |
|
JDBC and ADO.NET (backwards compatibility) |
10.0.x | 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x |