Devart Forums

Dear users,

Please be informed that as of October 26th, 2022 we are moving our community forum to a new platform available at https://support.devart.com/portal/en/community/. You will keep access to all your posts and information from this forum in a read-only format. Feel free to contact us anytime, our team will gladly assist you.

Devart development team
https://www.devart.com/

We are glad to announce the release of dbExpress Driver version 9.2 for SQL Server with the support for RAD Studio 11 Alexandria Release 2 and Microsoft OLE DB Driver for SQL Server 19.

What is new in this release:

• Added support for RAD Studio 11 Alexandria Release 2
• Added support for Microsoft OLE DB Driver for SQL Server 19
• Added passing the "client_interface_name" parameter to the server in the Direct mode
• Fixed bug with setting a DateTime value before the year 1753 to the parameter
• Fixed bug with the Access Violation failure when reading the Variant fields data
• Fixed bug with committing transaction on SQL Server 2000 in Direct mode

Devart Development Team
https://www.devart.com/dbx/sqlserver/

We are glad to announce the release of dbExpress Driver version 9.1 for SQLite with the support for RAD Studio 11 Alexandria Release 2.

Also, now the Direct mode is based on version 3.39.2 of the SQLite engine.

Devart Development Team
https://www.devart.com/dbx/sqlite/

We are glad to announce the release of dbExpress Driver version 6.0 for InrterBase and Firebird with the support for RAD Studio 11 Alexandria Release 2.

What is new in this release:

• Added support for RAD Studio 11 Alexandria Release 2
• Fixed bug with using CAST in the SQL statement when UseUnicode set to True
• Fixed bug with the growing memory consumption

Devart Development Team
https://www.devart.com/dbx/interbase/

We are glad to announce the release of dbExpress Driver version 5.2 for PostgreSQL Server with the support for RAD Studio 11 Alexandria Release 2.

What is new in this release:

• Added support for RAD Studio 11 Alexandria Release 2
• Added support for the SCRAM-SHA-256-PLUS authentication mechanism
• Added the MultipleConnections connection parameter
• Improved the performance of opening a connection
• Fixed bug with international characters in error messages

Devart Development Team
https://www.devart.com/dbx/postgresql/

Dear users!

We are glad to announce the release of the VirtualDAC 12.2 with the support for RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12.

What's new in this release:

• Added support of standard collations in a SQL statement in the VirtualQuery component
• Added the CloneCursor method for Query and Table components that allows sharing data between datasets
• Improved the performance of exporting to XML

Devart Development Team
https://www.devart.com/virtualdac/

Dear users!

We are glad to announce the release of the SDAC 10.2 with the support for RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12.

What's new in this release:

• Added support for Microsoft OLE DB Driver for SQL Server 19
• Added support for Azure AD authentication support for the Microsoft OLE DB provider
• Added support for the Always On availability group in the Direct mode
• Added support for connection to the Azure database by using the "Redirect" connection policy in the Direct mode
• Added the CloneCursor method for Query and Table components that allows sharing data between datasets
• Improved the performance of exporting to XML
• Fixed bug with committing transaction on SQL Server 2000 in Direct mode
• Fixed bug with restricting the list of procedures using PROCEDURE_TYPE condition in Metadata component
• Fixed bug when a connection string parameter value contains a single quote

Devart Development Team
https://www.devart.com/sdac/

Dear users!

We are glad to announce the release of the PgDAC 7.3 with the support for RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12.

What's new in this release:

• Added support for PostGIS
• Added the CloneCursor method for Query and Table components that allows sharing data between datasets
• Improved TimeZoneOffset support for TPgTimeStamp
• Improved the Truncate method of the TPgLargeObject class
• Improved the performance of exporting to XML
• Fixed bug with executing a SELECT statement via the Execute method of the Query component
• Fixed bug with the Ping method of the Connection component when the MultipleConnections property is set to False
• Fixed bug with the "Record was changed by another user" exception when editing a dataset that contains double precision fields
• Fixed bug with "Invalid TimeStamp string" when the date has YYYY-MM-DD format
• Fixed bug when a connection string parameter value contains a single quote
• Fixed bug with international characters in error messages

Devart Development Team
https://www.devart.com/pgdac/

Dear users!

We are glad to announce the release of the UniDAC 9.3 with the support for RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12.

What's new in this release:

• Added the CloneCursor method for Query and Table components that allows sharing data between datasets
• Added support of standard collations in a SQL statement in the VirtualQuery component
• Improved the performance of exporting to XML
• Fixed bug when a connection string parameter value contains a single quote

SQLServer data provider

• Added support for Microsoft OLE DB Driver for SQL Server 19
• Added support for Azure AD authentication support for the Microsoft OLE DB provider
• Added support for the Always On availability group in the Direct mode
• Added support for connection to the Azure database by using the "Redirect" connection policy in the Direct mode
• Fixed bug with restricting the list of procedures using PROCEDURE_TYPE condition in Metadata component
• Fixed bug with committing transaction on SQL Server 2000 in Direct mode

MySQL data provider

• Fixed bug with "Record changed by another user" error when LockMode <> lmNone and using encryption
• Fixed bug with truncation of milliseconds of DateTime fields in the Dump component
• Fixed bug with posting calculated field

PostgreSQL data provider

• Added support for PostGIS
• Improved TimeZoneOffset support for TPgTimeStamp
• Improved the Truncate method of the TPgLargeObject class is improved
• Fixed bug with executing a SELECT statement via the Execute method of the Query component
• Fixed bug with the Ping method of the Connection component when the MultipleConnections specific option is set to False
• Fixed bug with the "Record was changed by another user" exception when editing a dataset that contains double precision fields
• Fixed bug with "Invalid TimeStamp string" when the date has YYYY-MM-DD format
• Fixed bug with international characters in error messages

InterBase data provider

• Improved support for TIME/TIMESTAMP WITH TIME ZONE data types
• Added support for EXTENDED TIME/TIMESTAMP WITH TIME ZONE data types
• Added support for working with time zone data types when clients don't have the ICU library
• Added support for The isc_dpb_session_time_zone, isc_dpb_set_bind, isc_dpb_decfloat_round, and isc_dpb_decfloat_traps DPB
• Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using "UPDATE OR INSERT" batch operations
• Fixed bug with using CAST in the SQL statement when UseUnicode set to True
• Fixed bug with reading GUID data of stored procedure in using the AsGuid property
• Fixed bug with processing GUID data in using in parameter
• Fixed bug with working with the transaction when LockMode <> lmNone
• Fixed bug with using the TUniAlerter component in WebBroker applications
• Fixed bug with "Invalid variant type" error when the DMLRefresh property is set to True

SQLite data provider

• Now the Direct mode is based on version 3.39.2 of the SQLite engine
• Fixed bug with mapping table columns of non-standard types to fields of the ftMemo type
• Fixed bug with mapping table columns of integer types to string fields

DBF data provider

• Added support for VisualFoxPro CANDIDATE indexes

NexusDB data provider

• Added support for NexusDB 4.60.01
• Added option to set Remote Thread Priority

MS Access data provider

• Fixed bug with processing UUID fields

Devart Development Team
https://www.devart.com/unidac/

Dear users!

We are glad to announce the release of the ODAC 12.2 with the support for RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12.

What's new in this release:

• Added the CloneCursor method for Query and Table components that allows sharing data between datasets
• Improved the performance of exporting to XML
• Fixed bug when a connection string parameter value contains a single quote

Devart Development Team
https://www.devart.com/odac/

Dear users!

We are glad to announce the release of the MyDAC 11.2 with the support for RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12.

What's new in this release:

• Added the CloneCursor method for Query and Table components that allows sharing data between datasets
• Improved the performance of exporting to XML
• Fixed bug with "Record changed by another user" error when LockMode <> lmNone and using encryption
• Fixed bug with truncation of milliseconds of DateTime fields in the Dump component
• Fixed bug with posting calculated field
• Fixed bug when a connection string parameter value contains a single quote

Devart Development Team
https://www.devart.com/mydac/

Dear users!

We are glad to announce the release of the LiteDAC 5.2 with the support for RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12.

What's new in this release:

• Added the CloneCursor method for Query and Table components that allows sharing data between datasets
• Improved the performance of exporting to XML
• Fixed bug with mapping table columns of non-standard types to fields of the ftMemo type
• Fixed bug with mapping table columns of integer types to string fields
• Fixed bug when a connection string parameter value contains a single quote

Also, now the Direct mode is based on version 3.39.2 of the SQLite engine.

Devart Development Team
https://www.devart.com/litedac/

Dear users!

We are glad to announce the release of the IBDAC 8.2 with the support for the RAD Studio 11 Alexandria Release 2, Lazarus 2.2.2, iOS 15, and Android 12.

What's new in this release:

• Added the CloneCursor method for Query and Table components that allows sharing data between datasets
• Added support for working with time zone data types when clients don't have the ICU library
• Added support for the isc_dpb_session_time_zone, isc_dpb_set_bind, isc_dpb_decfloat_round, and isc_dpb_decfloat_traps DPB
• Added support for EXTENDED TIME/TIMESTAMP WITH TIME ZONE data types
• Improved support for TIME/TIMESTAMP WITH TIME ZONE data types
• Improved the performance of exporting to XML
• Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using "UPDATE OR INSERT" batch operations
• Fixed bug with using CAST in the SQL statement when UseUnicode is set to True
• Fixed bug with reading GUID data of stored procedure in using the AsGuid property
• Fixed bug with processing GUID data in using "in" parameter
• Fixed bug with working with the transaction when LockMode <> lmNone
• Fixed bug with using the TIBCAlerter component in WebBroker applications
• Fixed bug with "Invalid variant type" error when the DMLRefresh property is set to True
• Fixed bug with reading BLOBs when the CacheBlobs property is set to False and the UseUnicode property is set to True
• Fixed bug when a connection string parameter value contains a single quote

Devart Development Team

https://www.devart.com/ibdac/

Dear users,

We are glad to inform you that a big update of dbForge Studio for SQL Server, dbForge SQL Complete, and dbForge SQL Tools has been rolled out. This update delivers support for SQL Server 2022 Community Technology Preview 2.1 (CTP 2.1) alongside extended keyword suggestions and newly supported syntax constructs.

To learn more about it, please refer to our blog post.

Availability

Feel free to download dbForge products for SQL Server from our website and check the new features and improvements in action:
Download dbForge Studio for SQL Server
Download dbForge SQL Complete
Download dbForge SQL Tools

Devart Development Team
https://www.devart.com/dbforge/

Dear users,

We are glad to inform you that a big update of dbForge Studio for SQL Server, dbForge SQL Complete, and dbForge SQL Tools has been rolled out. This update delivers support for SQL Server 2022 Community Technology Preview 2.1 (CTP 2.1) alongside extended keyword suggestions and newly supported syntax constructs.

To learn more about it, please refer to our blog post.

Availability

Feel free to download dbForge products for SQL Server from our website and check the new features and improvements in action:
Download dbForge Studio for SQL Server
Download dbForge SQL Complete
Download dbForge SQL Tools

Devart Development Team
https://www.devart.com/dbforge/