Secure Connections to Oracle, Faster Access to Cloud Data, and Other Updates in ODBC Drivers

December 10th, 2020

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.

ODBC Driver for Amazon Redshift [Download] [Revision History]
ODBC Driver for ASE [Download] [Revision History]
ODBC Driver for Firebird [Download] [Revision History]
ODBC Driver for Google BigQuery [ Download ] [ Revision History ]
ODBC Driver for InterBase [Download] [Revision History]
ODBC Driver for MongoDB [Download] [Revision History]
ODBC Driver for MySQL [Download] [Revision History]
ODBC Driver for NexusDB [ Download ] [ Revision History ]
ODBC Driver for Oracle [Download] [Revision History]
ODBC Driver for PostgreSQL [Download] [Revision History]
ODBC Driver for SQLite [Download] [Revision History]
ODBC Driver for SQL Azure [Download] [Revision History]
ODBC Driver for SQL Server [Download] [Revision History]
ODBC Driver for xBase [Download] [Revision History]
ODBC Driver for BigCommerce [ Download ] [ Revision History ]
ODBC Driver for Dynamics 365 [ Download ] [ Revision History ]
ODBC Driver for FreshBooks [ Download ] [ Revision History ]
ODBC Driver for Magento [ Download ] [ Revision History ]
ODBC Driver for MailChimp [ Download ] [ Revision History ]
ODBC Driver for NetSuite [ Download ] [ Revision History ]
ODBC Driver for QuickBooks [ Download ] [ Revision History ]
ODBC Driver for Salesforce [ Download ] [ Revision History ]
ODBC Driver for Salesforce MC [ Download ] [ Revision History ]
ODBC Driver for SugarCRM [ Download ] [ Revision History ]
ODBC Driver for Zoho CRM [ Download ] [ Revision History ]
Leave a Comment