ODBC Driver for Zoho CRM Revision History

3.2.0 16-Apr-26

  • Improved compatibility with Attunity Qlik Replicate
  • Improved compatibility with the PDO_ODBC PHP extension
  • Improved compatibility with Node.js
  • Fixed an issue with parsing a connection string when its value contained a sequence of SQL comment characters

3.1.0 10-Nov-25

  • Added support for the Canada data center
  • Added support for the Saudi Arabia data center
  • Improved compatibility with Node.js
  • Improved compatibility with Tableau
  • Improved compatibility with Vectorworks

3.0.0 14-Apr-25

  • Added support for API version 4
  • Improved compatibility with Microsoft Query
  • Resolved an issue with data import into Microsoft Excel
  • Fixed an issue with editing File DSN

2.9.0 12-Nov-24

  • Added support for Canadian data center
  • Fixed bug with re-activation ODBC driver via another Windows user

2.8.1 28-Mar-24

  • Fixed the issue when establishing a connection with a connection string that contains unsupported parameters

2.8.0 14-Mar-24

  • Now tokens and passwords are stored in an encrypted form in the DSN record
  • Added metadata cache
  • Fixed bug when updating fields with '." in the name
  • Fixed connection timeout setting before opening connection

2.7.1 03-Oct-23

  • Fixed bug with driver license validation for Linked Server in MSSMS
  • Fixed bug with reading DATETIMEs columns in Tableau

2.7.0 17-Aug-23

  • Added support for Japanese Data Center
  • Fixed bug with getting data in DBeaver
  • Fixed bug with SQL aggregate functions for MS Access

2.6.0 15-May-23

  • Added the Query API connection string parameter
  • Added support for SQL_ATTR_MAX_ROWS attribute
  • Improved compatibility with Linked Server in SQL Server
  • Improved compatibility with Visual Basic in Visual Studio
  • Improved MS Access linked tables support
  • Improved compatibility with Alteryx
  • Fixed bug with SELECT that contains JOIN for Linked Tables in MS Access
  • Fixed bug with retreving UTC time

2.5.0 17-Nov-22

  • Improved compatibility with Linked Server in SQL Server 2019
  • Improved compatibility with Tableau Prep Builder
  • Improved compatibility with Crystal Reports
  • Fixed bug when a connection string parameter value contains a single quote
  • Fixed an issue with adding DSN in PowerShell
  • Fixed an issue with rows deleting

2.4.1 05-Jan-22

  • Added support for Windows 11
  • Improved compatibility with FICO Mosel
  • Improved compatibility with FileMaker
  • Improved support for an ODBC installer on Windows 2000
  • Fixed an issue with updating date and time fields in MS Access

2.3.2 20-Jul-21

  • Support for the "Converted" field in the "Leads" table is added

2.3.1 08-Jul-21

  • MSI installer for deploying through GPO is added

2.2.1 23-Apr-21

  • The NonApprovedRecords option is supported
  • Compatibility with SQL Server is improved
  • Bug with modifying data using the Linked Server is fixed
  • Bug with "The module name 'Activities' seems to be invalid" is fixed

2.1.1 07-Dec-20

  • Now Web Authentication uses the default browser instead of Internet Explorer
  • Zoho authentication using "com.au" domain is added
  • The ReturnForeignKeys connection option to significantly improve performance is added
  • Compatibility with Visual Studio is improved
  • SQLProcedures now returns an empty recordset instead of an error
  • SQLProcedureColumns now returns an empty recordset instead of an error

2.0.5 08-Apr-20

  • Compatibility with Power Pivot is improved
  • Compatibility with Visual Basic is improved
  • Compatibility with RStudio is improved
  • Bug with modifying data using SQLSetPos is fixed
  • Bug with fetching by Bookmark is fixed

2.0.4 31-Jan-20

  • Deprecated API 1.0 support ended

2.0.3 20-Jan-20

  • Connection UTCDates option is added
  • Zoho authentication using different domains is added
  • Bug with fetching data from the Events table is fixed

2.0.2 04-Oct-19

  • Performance of obtaining metadata is improved
  • Support for connection pooling is improved
  • Now ODBC driver activation does not require administrator privileges

2.0.1 08-Jan-19

  • Zoho CRM version 2.x is supported
  • OAuth authentication is supported
  • Possibility to force the ODBC 2.x behavior is added

1.4.10 16-Jul-18

  • Possibility to show used connection string in the connection dialog is added

1.4.9 14-Jun-18

  • Possibility to return String Types as Ansi or Unicode is added
  • Compatibility with MS Access is improved
  • Compatibility with Tableau is improved
  • Compatibility with Omnis Studio is improved
  • Compatibility with Power Pivot is improved
  • Compatibility with DBeaver is improved
  • Domain selection is added

1.3.8 26-Feb-18

  • Connection Timeout option is added
  • Query Timeout option is added

1.2.7 06-Nov-17

  • Compatibility with MS Excel 64-bit is improved

1.2.6 23-Oct-17

  • Compatibility with SAS JMP is improved
  • Compatibility with MS Power Query is improved
  • OUTER JOIN macros in SQL queries are supported
  • DateTime macros in SQL queries are supported
  • Scalar function macros in SQL queries are supported

1.1.5 22-Jun-17

  • Compatibility with Adobe ColdFusion is improved
  • Several issues with data modification in Microsoft SQL Server Management Studio are resolved
  • Now "." is a decimal separator for numbers with floating point by default
  • Bug with "&" symbol in string constants is fixed

1.1.4 29-Nov-16

  • Compatibility with Microsoft SQL Server Reporting Services is improved
  • Bug when administrator privileges are required is fixed

1.1.3 26-Oct-16

  • Compatibility with MS Visual Studio is improved
  • Compatibility with MS FoxPro is improved
  • Compatibility with MapInfo is improved
  • Compatibility with Libre Office is improved
  • Compatibility with Qlik is improved
  • Compatibility with Delphi & C++Builder is improved
  • MS Access linked tables support is improved

1.0.2 03-Aug-16

  • License validation is fixed

1.0.1 08-Jul-16

  • Initial release of ODBC Driver for Zoho CRM
  • Windows 32-bit is supported
  • Windows 64-bit is supported