Oracle 20c, PostgreSQL 13, and SQL Server 2019 were supported in respective ODBC drivers.
We are pleased to announce the release of new versions of our ODBC drivers, with the most notable updates coming for the Oracle connector — now you can secure your connection to Oracle Database in the Direct mode with TLS, SSH, or HTTPS.
Support for the Pipe, Secure Pipe, and Secure TCP protocols was added to the ODBC driver for NexusDB.
A few connection options were added to the ODBC driver for SQLite: the Connect Mode, Journal Mode, Locking Mode, and Synchronous options. The Connect Mode option defines whether a database will be opened for reading and writing, or for reading only. Journal Mode sets the journal mode for databases associated with the opened connection. Locking Mode defines the database locking mode (exclusive or normal), and the Synchronous option sets the database synchronization mode when writing to disk.
The ODBC driver for xBase now supports native dBase functions in SQL statements and has two additional options for accessing DBF files that contain corrupted data — AllFieldsAsNullable and IgnoreBrokenTables. The former option is used to open tables that have records with null values in non-nullable columns, and the latter option skips corrupted tables in a directory.
A new option, ReturnForeignsKeys, was added to all cloud drivers. With this option, the drivers are able to access cloud data much faster because they don’t have to return foreign keys. Retrieving metadata about foreign key constraints is a time-consuming operation, and many third-party tools request this information even when they do not actually need it. Thus, disabling the option by default reduces the time for passing data back and forth. Also, compatibility with Visual Studio was improved in all cloud drivers.
Drivers for the following cloud services, which use web authentication, now open the authentication form in the default browser instead of Internet Explorer: FreshBooks, Google BigQuery, QuickBooks, Zoho CRM.
Two stored procedures were added to the ODBC driver for Dynamics 365, “associate” and “disassociate”. They are intended to update data in tables using stored procedures in a situation where Dynamics doesn’t allow updating data directly with the UPDATE statement.
You are welcome to download the new versions. Please let us know what other features you’d like to see in our drivers.