New in ODBC Drivers: Thread safety, enhanced connection pooling and more

October 7th, 2019

Devart, a vendor of ODBC Drivers for many databases and cloud services, announced the release of new versions of ODBC drivers. Among new features and enhancements are thread safety and improved connection pooling, compatibility with sandboxed applications for macOS, and performance of obtaining metadata.

Our ODBC drivers for ASE, MySQL, Oracle, SQL Azure, SQLite, and SQL Server are now thread-safe. They manipulate shared data structures in a manner that ensures that multiple threads behave properly and are executed concurrently without unintended interaction.

All drivers can now be activated without administrator privileges.

Performance of obtaining metadata was improved in ODBC drivers for cloud applications: Zoho CRM, Salesforce, QuickBooks, and others. The metadata contains information about the database structure: the entity names and their relationships, the names and types of attributes, user constraints, data integrity and storage information.

Connection pooling was improved in all ODBC drivers. In database management systems, a connection pool is a cache of database connections that can be reused when requests to the database are required again. Reusing previously created connections from cache eliminates the need to create new connections, which results in significantly higher performance of executing commands on a database.

Other updates:

  • Improved compatibility with sandboxed applications for macOS
  • InterBase driver got better compatibility with InterBase 6.x, 7.0
  • MailChimp driver now supports the MailChimp API 3.0
  • Token-based authentication was supported in NetSuite driver
  • Oracle 19c database and client were supported in the ODBC driver for Oracle
  • PostgreSQL driver now supports Amazon RDS for PostgreSQL
  • The Direct mode in SQLite driver is now based on the version 3.27.2 of the SQLite engine

The download links for ODBC drivers for databases:

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 InterBase [Download] [Revision History]
ODBC Driver for MongoDB [Download] [Revision History]
ODBC Driver for MySQL [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]

The download links for ODBC drivers for cloud services:

ODBC Driver for BigCommerce [ Download ] [ Revision History ]
ODBC Driver for Dynamics CRM [ 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 ]

If you ever decide to share your feedback or request a new feature, you are welcome to join our forum.

Leave a Comment