Client drivers

When loading data with a COPY or prepared statement for an INSERT, SQLGetDiagRec() now returns the diagnostic information for the first 50 failures.

ODBC: Improved row error reporting

When loading data with a COPY or prepared statement for an INSERT, SQLGetDiagRec() now returns the diagnostic information for the first 50 failures. Previously, SQLGetDiagRec() only returned the diagnostic information for the first failure.

For details, see Tracking load status (ODBC).

ADO.NET: Linux and macOS support

The ADO.NET driver is now available on NuGet.org for all platforms: Windows, Linux, and macOS. To use it, you must first install .NET Core 3.1+ (.NET 6.0 recommended).

Cross-platform support for this driver also brings the following changes for the ADO.NET client driver 23.3.0 and above:

  • Logging is now configured with Vertica.Data.dll.config, rather than with HKEY_LOCAL_MACHINE\SOFTWARE\Vertica\ADO.NET\Driver in the Windows registry. Existing configurations in HKEY_LOCAL_MACHINE\SOFTWARE\Vertica\ADO.NET\Driver are automatically migrated to Vertica.Data.dll.config. For details, see Log properties.
  • To use the driver, you can now reference it in your project, rather than registering it in .NET Core. For details, see Installing the ADO.NET client driver.
  • Kerberos is currently only supported on Windows.

For installation and usage details, see Installing the ADO.NET client driver.