• Findkey in Cloned DataSet work?

  Hello, I would like to confirm a question. Does the FindKey method work on a cloned dataset? In my tests, it does not work. In the IBDAC documentation, a restriction is that the cloned dataset does not allow the use of filters. Is the fact that FindKey

• dbForge Studio for SQL Server Features Question and Feature Request

  I was looking at dbForge Data Compare tool and came across the Compare Bundle and dbForge Studio. My question is, am I losing any features from the standalone SQL Complete (currently use Standard), Schema Compare (currently use a competing product but

• scroll problem in table editor

  hi, as for me something wrong with panel scrolling in table editor also good place for field comment is main column list rather column property. It's only my opinion of course. Thank you

• Connect to MySQL with SSL and validate server certificate

  Hello I'm working with an Amazon RDS MySQL instance, and i'm sucessfully connecting to my db even when i'm providing a wrong certificate in MySqlConnection.SslOptions.CACert I only have CA certificate, no client certificate. How should I force the verification

• MyDAC login problems

  I am using MyDAC 12.4.0 with Delphi 10.2 Using MyConnection1 and Myconnection Dialog Anytime there is a login mistake, wrong password or user, the second attempt throws the flowing error: assertion failure "d:\jenkins\workspace\DAC\MyDAC\Delphi\Dac\Common\Source\CRVioTcpSSL.pas"

• Newer Version of SQL Complete Breaks Stream Deck Macros

  Using SSMS 20.2. Stream Deck https://www.elgato.com/ca/en/s/welcome-to-stream-deck is a piece of hardware or an app that hooks up to your PC and provides extra macro keys. I have text strings assigned to some of these macro keys. Until SQL Complete v7.0.362

• .NET 9 - Devart.Data.Oracle.EfCore - NullReferenceException

  Hi, On EFCore 9, with today driver v10.4.191.9, many operators are failing with this error : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression.PushdownIntoSubqueryInternal(Boolean

• dotConnect for MySQL parses sbyte incorrectly

  Hello, I've recently bought dotConnect for MySQL and this is the first problem. All versions are current, .NET 8 with EF Core 9 and Devart's 9.4.191.9 My database has some columns that are tinyint in MySQL, which has the range -128...127. dotConnect's

• dac290.bpl and pgdac290.bpl not compiled into exe

  hello one and all, I'm getting back into Delphi, 12 right now, after last use with XE2. I started with 1 in 1995. anyway, I am evaluating PgDAV for direct connection into psql. when I copy and run the exe unto a native win11 machine and run it, the message

• MyDAC MyConnection ignores Password

  In various circumstances, the TMyConnection "Password" field doesn't seem to work properly. 1. In the Delphi Object Inspector, right after I enter a password into the Password field, if I then set Connected to True, a connect dialog pops up with the Password

• Table names always renamed as lowercase versus PascalCase

  Is there a way to turn off this automatic table renaming to lowercase? When creating or modifying tables in dbForget Studio for MySQL v10.1.165, it always renames my tables as lowercase or camelCase. Our coding standards are PascalCase, which is causing

• invalid bytes count error - DotConnect for Oracle

  Hi, we moved from Oracle 12c to 19c and upgraded Devart.Data.Oracle to 10.0.0.0 and to Devaty.Data.Oracle EntirtE6 and we getting that error invalid bytes count right at the start up, during getting user profiles from database. What can be a reason for

• Computer crashes when opening SSMS

  The two members of my team (including myself), who have dbForge SQL Complete installed, are having issues with our computers crashing every time we open SSMS 20.2. Since it's happening just to the two of us with dbForge, we're suspecting that it's the

• Passing parameters to TUniStoredProc without SELECT privilege

  Hello. I have MySQL database with some of the stored procedures for accessing data in it. The only global privilege enabled is EXECUTE, others are disabled. I'm trying to call a stored procedure in MySQL database with the help of TUniStoredProc using

• Update SQLite Direct ?

  Hello, Any ideas why you don't update the SQLite direct to the latest version ? Thank you

• How to get entire BLOB content with dbExpress

  I have a Firebird 3.x database with UTF8 characters, connected with Devart dbExpress from a Delphi Intraweb program and cannot get it to display more than one character of a BLOB memo field. Presumably I need to set something different when connecting

• MyDAC and SDAC question

  I am trying to retrieve data from MS SQL Server (about 40000 records) and copy them to TDictionary as fast as possible. My problem is that it is slow and some setting changes give strange results. What I do is: 1. I open TMSQuery object MSQArt, it takes

• MyDAC Bug 12.4.0

  I just switched to the new release and re-compiled my projects. Now I get this error, when I start my program: assertion failure "d:\jenkins\workspace\DAC\MyDAC\Delphi\Dac\Common\Source\CRVioTcpSSL.pas"

• The keyword "then" causes inserting ifthen snippet

  Hi, "then" keyword causes to inserting "ifthen" snippet dbforge for oracle 6.0.85

• SSMS Results Grid > copy as Excel format

  The "Copy Data As" results grid options have been very useful for years, but one extra thing would still be super nice to have: "Copy As Excel". I'm sure everyone has seen issues with data types when copying directly from SSMS into Excel, often changing

• no prompts for package procedure parameters

  dbforge for oracle 6.0.85 and prev

• memory !!

  Hi, dbborge for oracle 6.0.85 something wrong with memory consumption and this is not related to large dataset suddenly dbforge was freezing for some minutes and i needed to kill process i have catched same case two times , previous version dbforge have

• how to specify the version of sql server used when generating synchronization script

  My Sql Server install is 2019. When I generate a synchronization script, I need to specify that the script generated works with Sql Server 2014 (other sql installs on different computers). I am currently using dbForge Schema Compare for Sql Server Professional

• Unitable isindex and lookup do not work

  Hello, i am using a UniDac UniTable to access a SQL server database. To view the structure of the table i need to know which fields are index fields and which ones are lookup connections. The tunitable has two properties which should give this information:

• UniDAC 10.3.2 - Returning - Firebird 4 / Firebird 5

  With 10.1.0 “Added support for multiple rows being returned by DML with the RETURNING clause” was introduced. I have now noticed that in a query with returning with Firebird 4 the returning is in the params (fields empty) and with Firebird 5 in the fields

• UniDAC 10.4 Source Installation

  Hi, I am trying to use Make.bat using Make.bat Delphi WIN32 but get the error: Embarcadero Delphi for Win32 compiler version 36.0 Copyright (c) 1983,2025 Embarcadero Technologies, Inc. odbcprovider290.dpk(28) Fatal: E2225 Never-build package 'rtl' must

• How to place an image in the background of a report and have the data visible on the image?

  Hello, I'm trying out dbForge Studio for SQL Server and want to place a background image on the entire report page. I'm using the image object to insert the image I need, but when I place it in the background and add fields over the image, they don't

• no possibility to reset check box "not null" in table editor

  Hi,scenario: 1 open table editor - ok 2 add new field - ok 3 set "not null" check box - ok 4 jump to another field - ok 5 return to my new field - ok 6 try to reset "not null" check box - ok 7 jump to another field - fiasco - "not null" check box return

• document outline break down

  this line break down document outline dbforge for oracle 6.0.85

• Prevent ODAC from appearing in Delphi main menu

  Hello, After I install ODAC components into Delphi, "ODAC" is inserted into Delphi's main menu. Is there a way to prevent (or remove) this? Thanks John Dorlon

• Delphi 12.3 64bit-IDE support

  Hi when can we expect the design-time controls for the 64bit IDE of Delphi 12.3 for the Delphi Data components ? Kind regards, Erik

• ORA-00918: column ambiguously defined for paging mode (

  hi, i got error while getting next page of query result. for first page i have warning - it's Ok. but for next page i have ERROR 1 ORA-00918: column ambiguously defined SQL3.sql 3 8 Yes, i really have repeating column names, but without paging or for

• header of tab sometimes not in visible position !!!

  Hi, sometimes the tab header is not in visible position after opening new tab and need to scroll tabs for finding it.

• 'relation "__EFMigrationsHistory" already exists' when running multiple migration sets

  Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. The application has multiple modules with migrations for module-specific entities and all migrations are applied to the same database.

• [PgDAC] Error when executing SQL Query in table with blob files

  Hi there, hope you'll ok. I recently started using PgDAC for queries that works with blob files, especially using the "execute" command of PostgreSQL (version 16). When i execute the query, i'm getting the following error: "ERROR: Assertion failure (D:\Jenkins\workspace\DAC\PgDAC\Delphi\Dac\PostgreSql\Source\PgSQLProtocol.pas,

• TScFTPClient 'FTP server error occurred: TLS required, configure with AUTH first.'

  Get the EScFTPError 'FTP server error occurred: TLS required, configure with AUTH first' FFtpClient.TLSMode := tmRequireExplicitTLS FFtpClient.SSLOptions.IgnoreServerCertificateConstraints := true; FFtpClient.SSLOptions.IgnoreServerCertificateInsecurity

• Sqlite support to Microsoft Visual Studio Community 2022 (ARM 64-bit)

  I'm using Microsoft Visual Studio Community 2022 om a macbook pro M4. Everything work just fine except dotConnect for SQlite. Using latest version 6.4.190 Getting error when try to open SQLiteConnection in debug mode. Application is running fine standalone.

• TScSMTPClient for dummies

  Hi, I am playing a little around with ScSMTPClient and was able to send mails. I am currently failing to get/receive an errror when using an non existing adress no matter wether used as a from or to address. Am I right that this is probably related to

• SQL Complete Execution History Import

  Is there a way to move over query execution history from one computer to another?

• Any plans to create an ODBC driver for Xero?

  Hi Just wondering if there is any plans in the works to create an ODBC driver for the Xero platform?

• Next Page

• Most Discussed Topics

• The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.

  I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created

• Invalid Typecast exception on Insert/Update blobs

  Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++

• Virus scanner alarm - Trojan found

  Hello, this morning I received an update message for the installed test version of SQLTools. After downloading the sqltoolsent.exe file from the download area at devart, I started the installation. Unfortunately, I received the following messages from

• Sql Complete v2025.1.134 won't switch to express license

  I updated to v2025.1.134 for SSMS 21 but somehow my Express license was reset and I'm now back in the "Enterprise" license trial mode. The previous solution of setting HKEY_CURRENT_USER\Software\Devart\dbForge SQL Complete\Activation\UseExpress to 1 isn't

• DbForge studio for Oracle connection issue with proxy user

  I have oracle DB that is installed on server and want to connect to it via proxy user but it's seems like the application can't connect to the DB even the same connection string is working fine on other application. Please note that I have no DBA privilege

• Popular Topics

• The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.

  I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created

• Invalid Typecast exception on Insert/Update blobs

  Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++

• Virus scanner alarm - Trojan found

  Hello, this morning I received an update message for the installed test version of SQLTools. After downloading the sqltoolsent.exe file from the download area at devart, I started the installation. Unfortunately, I received the following messages from

• Sql Complete v2025.1.134 won't switch to express license

  I updated to v2025.1.134 for SSMS 21 but somehow my Express license was reset and I'm now back in the "Enterprise" license trial mode. The previous solution of setting HKEY_CURRENT_USER\Software\Devart\dbForge SQL Complete\Activation\UseExpress to 1 isn't

• Change order of ApplyUpdate

  Hi Using CachedUpdate I need to have the delete statements to be fired before the inserts, is this possible? if not, i try to delete the deleted records before i can applyUpdates, but when i call apply after that i get error record to be deleted cant

• Popular Articles

• How to Download and Install a Previous Version of the Product

  If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...

• How to Connect to MySQL Server

  In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

• How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools

  If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...

• Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce

  When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...

• How to Activate a Trial Version in dbForge Products

  Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...