What's new in ODBC Driver for NetSuite 3.1.0
Mar 14, 2024
- Now tokens, secrets and passwords are stored in an encrypted form in the DSN record
- Added metadata cache
- Fixed data reading from some tables
- Fixed connection timeout setting before opening connection
New in ODBC Driver for NetSuite 3.0.2 (Oct 4, 2023)
- Fixed bug with driver license validation for Linked Server in MSSMS
- Fixed bug with reading DATETIMEs columns in Tableau
New in ODBC Driver for NetSuite 3.0.1 (Aug 18, 2023)
- Fixed bug with getting data in DBeaver
- Fixed bug with SQL aggregate functions for MS Access
New in ODBC Driver for NetSuite 3.0.0 (May 17, 2023)
- Added support for API version 2
- Added support for OAuth authentification
- Added support for Custom Lists
- Added native support for LIMIT clause without using local cache
- 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 compatibility with Alteryx
- Fixed bug with SELECT that contains JOIN for Linked Tables in MS Access
New in ODBC Driver for NetSuite 2.4.0 (Nov 18, 2022)
- 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
New in ODBC Driver for NetSuite 2.3.1 (Jan 5, 2022)
- 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
New in ODBC Driver for NetSuite 2.2.2 (Jul 20, 2021)
- Support for "AssemblyBuild" and "AssemblyUnbuild" tables is added
New in ODBC Driver for NetSuite 2.2.1 (Jul 12, 2021)
- MSI installer for deploying through GPO is added
New in ODBC Driver for NetSuite 2.1.2 (Apr 26, 2021)
- Compatibility with SQL Server is improved
- Bug with modifying data using the Linked Server is fixed
New in ODBC Driver for NetSuite 2.1.1 (Dec 9, 2020)
- 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
New in ODBC Driver for NetSuite 2.0.3 (Apr 8, 2020)
- Compatibility with Power Pivot is improved
- Compatibility with Visual Basic is improved
- Compatibility with RStudio is improved
- Bug with fetching by Bookmark is fixed
- Bug with modifying data using SQLSetPos is fixed
New in ODBC Driver for NetSuite 2.0.2 (Jan 20, 2020)
- Connection UTCDates option is added
- Connection RoleID option is added
New in ODBC Driver for NetSuite 2.0.1 (Oct 7, 2019)
- Token-based authentication is supported
- Performance of obtaining metadata is improved
- Support for connection pooling is improved
- Now ODBC driver activation does not require administrator privileges
New in ODBC Driver for NetSuite 1.4.9 (Jan 8, 2019)
- Possibility to force the ODBC 2.x behavior is added
New in ODBC Driver for NetSuite 1.3.8 (Jul 17, 2018)
- Possibility to show used connection string in the connection dialog is added
New in ODBC Driver for NetSuite 1.3.7 (Jun 15, 2018)
- 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
New in ODBC Driver for NetSuite 1.2.6 (Feb 27, 2018)
- Sandbox is supported
- Connection Timeout option is added
- Query Timeout option is added
New in ODBC Driver for NetSuite 1.1.5 (Nov 6, 2017)
- Compatibility with MS Excel 64-bit is improved
New in ODBC Driver for NetSuite 1.1.4 (Oct 24, 2017)
- 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
New in ODBC Driver for NetSuite 1.0.3 (Jun 22, 2017)
- 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
New in ODBC Driver for NetSuite 1.0.2 (Dec 16, 2016)
- Compatibility with Microsoft SQL Server Reporting Services is improved
- Bug when administrator privileges are required is fixed