• 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

• magic disappearing Data Viewer window

  after jumping from Find and Replace window to Data viewer (mouse click) it magic disappear (get empty) dbForge studio for Oracle 6.0.85

• 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

• exec current statement for pl/sql bloc containing JSON_OBJECT cause error

  hi, running this block via execute current statement cause error 1 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; <an identifier> <a double-quoted delimited-identifier> The symbol ";" was substituted for "end-of-file"

• 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

• "Go to definition" jumps to the package specification, not the package body, like a shift+F12

  Hi. Thank you for last update DBForge studio for Oracle to 6.0.85. Great job. Fixed many bugs. But at the same time a new problem appeared - "Go to definition" (F12) makes jump to package spec. (like a shift+F12) rather then to package body, . Reloading

• 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,

• New BOOLEAN datatype not supported with Oracle 23ai client

  Hello, I am using the latest version of ODAC and Delphi. When I connect to an Oracle 23ai database, using an Oracle 23ai client, and I select (using TSmartQuery) from a table that has a column of datatype BOOLEAN (for example: Select * from user_domain_cols),

• 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.

• SQL Complete No Longer Shows Column List For Trigger Tables

  I could've sworn SQL Complete used to show the column names for the inserted/deleted tables in the list members CREATE TRIGGER [dbo].[tu_Contact_StandingId] ON [dbo].[Contact] AFTER UPDATE AS BEGIN IF UPDATE(StandingId) BEGIN INSERT CapitaTransaction

• 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?

• .NET 9 - Devart.Data.Oracle.EfCore - Discriminator issue with include

  Hello Devart, When using discriminators in EF Core and then including navigational properties which aren't available on all discriminated types, only on specific derived types: var result = await ctx.Vehicles .Include(_ => ((Car)_).PossibleEngineTypes)

• Memory leak in SecureBridge

  Hi, Securebridge initialization code as allocates object which is newer release causing memory  leak. I know that it's not dangerous, cause it doesn't repeat but I was just wondering could the code be fixed so that while catching memory leaks, I wouldn't

• .NET9 Ef Core 9.0.1+ Object reference not set to an instance of an object.

  Hi, I'm getting Object reference not set to an instance of an object. from Microsoft.EntityFrameworkCore.Relational at pretty much each query. For example: await context.TV_USERS.AsNoTracking().Where(x => x.ID == Id).FirstOrDefaultAsync(ct); I'm using

• Invalid command line. Unknown switch 'connection:user'.

  I've been using dbforgemysql in Windows for manual backups and decided to automate it after a recent server crash at our ISP. I've followed the directions, but no matter what I do I receive an error. Invalid command line. Unknown switch 'connection:user'.

• SecureBridge Installer won't let me uncheck any components

  Hello, I want to uncheck the following in the SecureBridge installer, but the boxes don't respond when I uncheck them. SecureBridge files for Win64 (Modern) SecureBridge files for macOS SecureBridge files for Android It's not a big deal, just annoying.

• ERROR: FUNCTION 'SESSIONPROPERTY' is not supported.

  Hi, Anyone had this error when trying to conect do a Microsoft Fabric instance? The endpoints works fina on Azure Data Studio and SSMS but i get this error on DBFORGE Studio for SQL Server

• DateTimeOffset.Date does not correctly truncate time in dotConnect for PostgreSQL

  Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. We have been using multiple methods from the DbFunctions class, many of which were removed in EF Core. From my understanding, DateTimeOffset.Date

• SDAC older versions download

  Hello, Where can I download older versions of SDAC? I have UniDAC installed on our developer machine and it says I need very specific version of SDAC, not any two versions are compatible. So, I need to try SDAC on Delphi 11 Alexandria, specifically version

• C++ Builder error: E2015 Ambiguity between 'Crjson::TJSONObject' and 'System::Json::TJSONObject'

  I just moved one of my C++ Builder projects to RAD Studio 12.2 and UniDAC 10.3.2. I am getting the above error plus E2015 Ambiguity between 'Crjson::TJSONArray' and 'System::Json::TJSONArray'. I am only using TJSONObject and TJSONArray in this project,

• How to quickly find DB Connections

  Does anyone have any solutions for how to quickly find DB connections in Database Explorer when you work for a large company and have thousands of connections for all different servers? There isn't even a search bar and it would take forever to manually

• SQLite low-level

  i want to understand - can i use unidac/litedac in low-level mode? without connections, datasets and so on. as i see - a can use LiteStaticUni module. and, may be, some thing else. is there are some description or manuals for it?

• TUniQuery fails with Parameterized UpdateSQL while updating data in AWS to Bablefish for Aurora PostgresSQL

  Hi We have been using your wonderful library of UniDAC components (for SQL Server) for several years now and currently use version 10.1.0 professional version for Delphi 12. Currently we were evaluating to move our database to AWS through Bablefish implementation

• Define ClientID and ClientSecret in Dynamics365 ODBC DSN

  Hello, how is it possible to store a ClientID and a ClientSecret in a Windows ODBC connection for the Devart driver in the ODBC Manager? I only see the option to generate a token, and I am then prompted to log in. However, I would like to create an app

• Schema Compare for Postgresql: Triggers comparison

  Hello Where can I find an exhaustive list of what schema objects are currently supported and not supported when doing a schema comparison using dbForge for PostgreSQL? I was under the impression triggers are supported by this does not seem to be the

• Oracle Idle Time and Odac

  I am running Odac 12.1.1 with Oracle as my database. In Oracle, the idle time is set to 1 min. SQLPlus disconnects perfectly after 1 min idle time. My frontend application however exactly disconnects after 3 min Why is that ? Anyone else seen such behaviour

• Why no feature to convert T-SQL to LINQ for .NET 9 Core?

  I keep requesting and keep hoping my yearly subscription will get T-SQL to LINQ for .NET 9 core. But sadly every year passes an no feature added? Stored Procedures are a thing of the past and most development projects no longer use them. It's 2025, can't

• Next Page

• Most Discussed Topics

• A collection of enum array values get translated as (NULL, NULL ...)

  Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database

• Unidac connect to Oracle with LOAD_BALANCE

  Hi, it's the first time I have to connect to an Oracle server in a datacenter with Load_Balance feature; I have received this connection string: PROD_SIT_DB_PROD= (DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.148)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.149)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.150)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PDB.subset.vcnphx.oraclevcn.com)))

• memory leak

  memory leak problem is very serious,memory uses will continue grow to several GB level.

• 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

• Feature Suggestions for dbForge Studio for PostgreSQL

  1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply

• Popular Topics

• A collection of enum array values get translated as (NULL, NULL ...)

  Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database

• memory leak

  memory leak problem is very serious,memory uses will continue grow to several GB level.

• Feature Suggestions for dbForge Studio for PostgreSQL

  1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply

• 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

• 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

• 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 Install MySQL on Windows Using MySQL Installer

  The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with ...