• SOQL queries - field/column aliases not recognized and/or toLabel() function duplicate field errors

  Currently running Devart ODBC Driver for Salesforce 3.4.1, set up as linked server in MSSQL 2019 (15.0.4405.4), and I don't seem to be able to use field aliases when running SOQL queries via an OPENQUERY statement. For example: SELECT * FROM OPENQUERY(PCCUSFPROD,

• Schema compare for PostgreSQL free and commercial editions (dbForge Studio for PostgreSQL)

  Is there any difference between Schema compare for PostgreSQL free and commercial editions (dbForge Studio for PostgreSQL)?

• .Net 9 / EF Core 9 support

  Hi, What is the roadmap / delay to support .Net 9 / EF Core 9 on the Devart.Data.MySql.EFCore library ? Regards.

• Data management system

  Data is the backbone of generation

• This server version 17.1 is not currently supported

  I installed the latest dbForge Studio for Postgres. Running on windows 10. Postgres container (latest version from last week) is running in docker desktop for windows on port 5432. When I am creating the connection, dbForge studio is able to connect and

• How to disable formatting of Stored Procedure/Function code in backup?

  In some Functions I format the code myself. However, in the backup copy my formatting is lost, and instead it is replaced by automatic formatting. How do I prevent this? I use dbForge Studio 2020 for MySQL

• Live Data

  In the latest version of dbForge Studio for SQL Server is there any 'live data' functionality to show rows populating as a simple query executes instead of having to wait for the entire query to finish before showing results? For example: select * from

• Set connection parameters via command line

  Hello, we would like to use dbForge for MySQL with PAM solution (not Percona) that requires setting connection parameters via command line (username, password, dbname) to launch dbForge for MySQL application on Windows. Is that possible?

• UniLoader has problem with importing data to a table with default value columns in MSSQL.

  Hello, UniLoader has problem with importing data to a table with default value columns in MSSQL. I received an "unspecified error" message. If I provide the data myself, it works fine, but I would like the data to be filled with the schema's default value.

• I have Error in dbForge Monitor SQL Server "this metrics not supported by the current Microsoft SQL Server edition"

  Hi, I have Error in dbForge Monitor SQL Server "this metrics not supported by the current Microsoft SQL Server edition" What have I do?

• Skip exception

  hi all ! I have the following code that returns a bool value. If there is no connection it should be false. The problem is that I always get the exception and get out of the program. Is there a way to avoid it? private static bool IsMariaDBServer(string

• How to show table name on windows with retrieved data?

  When I'm retrieving data from table through context menu option in previous versions on opened tab was shown name of the table. But now its just "SQL", "SQL1", "SQL2"

• SOQL error: unexpected token: '('

  I have a complex SOQL query that includes nested queries of child objects that works in the Salesforce workbench but fails with the error "OLE DB provider "MSDASQL" for linked server "SALESFORCE" returned message "[Devart][ODBC][Salesforce]Invalid SOQL:

• DIRECT Mode fails with "Net: error 99" if a TYPE is modified between uses in a SELECT

  Hello, Using the attached demo project with the latest version of ODAC and Delphi. You'll have to enter your own user/pass/server. The bug happens on any Oracle version. After connecting in direct mode, a script runs which does the following: 1) Creates

• Entity Developer issue with nullable DateOnly

  I am in the process of upgrading our apps to .net 8 and EF core 8 and have also upgraded Entity Developer to the latest release. However, I am having an issue with DateOnly fields. If I mark a database field as DateOnly and nullable = true, the resulting

• Schema compare for PostgreSQL 1.4.839

  Very good tool with minor exceptions. For now I miss compare for triggers and indexes. Didn't test partitioning yet (is this working).

• Firebird query statistics, int32 of int64?

  Hi, In my application, I'm using TIBCConnection.DatabaseInfo to fetch query statistics, the Reads/Writes/Fetches/Marks fields. These are int32, but I think these should be int64. Can you check with the API? Here's an example of values that clearly overflow

• Direct connect to MS Access in 64bit application

  Hi, Since we have issues with connectivity through OLE DB (using ADO) on certain installations (mostly windows hosts with win32 Office installed) we're trying to use UniDac in order to connect to a MS Access database in direct mode. Delphi 10.4 and UniDac

• SSMS 19.3 no SQL Complete after installation

  Hi. Yesterday I installed SqlComplete 7.0. Everything went smoothly until I saw there is no SQLComplete menu in SSMS 19.3. There was no indication of error. I tried it twice, with same result. What should i do? How do I troubleshoot this? Thanks.

• securebridge with mydac

  ThirdParty demo mydac are SecureBridge(Deprecated) and SecureBridge With last delphi 12 with patch wich one should be install deprecated has MySSHIOHandler and MySSLIOHandler In mydac connection handler properties have no longer available components if

• Received error message not overriden in inherited class

  with securebridge (ssh connection i received this error message. In local connection not received nothing Any idea why I received this error see attach file

• Errors testing backup db with 20+ tables total 10GB

  Hi, My first question evaluation dbForge Studio for MySQL, after a few days testing other stuff through the evaluation of ENTERPRISE. The "only" special circumstance is that it is on a MariaDB 10.4 db enginge with tables in innodb. I have verified that

• UniScript unterminated dollar-quoted string

  I have a problem with Uniscript when running the command below CREATE OR REPLACE FUNCTION public.fin_fc_cte_integracao_fin() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE vFlgBaixado boolean; BEGIN IF (TG_OP = 'DELETE') THEN SELECT (CASE WHEN dat_bai

• Unable to use dotconnect for postgres

  I recently had to get a new computer and a previous web services site that worked fine under VS 2017 does not work under VS2022 and the error is when accessing the entity I get the following exception. Keep in mind the exact same site is working in production.

• Oracle AQ - Dequeue from a sharded queue causes invalid cast exception

  Since i converted my Oracle queue into a sharded queue, the OracleQueue.Dequeue function always throws an invalid cast exception in Devart.Data.Oracle.dll. When i used a normal queue everything worked fine.

• Oracle-19-24 issue in DirectMode

  Hi, We have the same issue: https://support.devart.com/portal/en/community/topic/oracle-19-24-aso-directmode Is there any forecast for the release of the official version? Could you give us the access to the pre-release build? Regards

• System.AccessViolationException when having parallel db writes using Devart.Data.SQLite.EFCore

  Hi, I've observed and AccessViolationException when running unit tests in parallel. Investigating this I found out that creating multiple different databases, or even inserting new entities in a database, in parallel can cause this exception: Fatal error.

• Specify synchronization Order

  This other software allows to specify the synchronization order so that integrity errors don't happen like foreign key issues. Is this possible with your current version of Data Compare? This is important to avoid, for example, having to disable a ProductPhotos

• OptimizedBigInt on Mysql 8.*

  Hi, I have OptimizedBigInt on in options, and in MySQL server 5.7 this SQL works well and produces an integer field type: FLOOR((DATEDIFF(CURRENT_DATE, STR_TO_DATE(Birthdate, "%Y-%m-%d")) / 365)) AS Age But on MySQL 8.*, I am getting: Type mismatch for

• PostgreSql.EFCore: problem querying spatial data

  Hello I migrated from .Net Framework to .NET Core 6.0 and have a problem querying spatial data. DbContext is extended with: optionsBuilder.UsePostgreSql(connectionString, options => { options.UseNetTopologySuite(); }); I use database first approach, the

• "CROSS APPLY" is not supported in Postgresql?

  Hello If I use a LINQ query over 2 tables, I get an error 42601: syntax error at "APPLY" It seems that the SQL contains "CROSS APPLY" which is unknown in Postgresql. How can I avoid that ? Never had that problem with the previous versions (.NET Framework)

• No data gets written to the database with Devart.Data.Oracle.EFCore 10.2.0.7 and Microsoft.EntityFrameworkCore 7.0.15

  Hi, I'm working on migrating an application from .NET Core 3.1 to .NET 6. This project previously used to following nuget packages without any issue: * Microsoft.EntityFrameworkCore 5.0.4 * Devart.Data.Oracle.EFCore 9.14.1228 I have now updated those

• EF Core 7 MaxBatchSize and auto generated ID's

  When using a MaxBatchSize I get an Exception when inserting a record, the ID is auto generated by the database: The property 'Planning.PLANNING_ID' has a temporary value while attempting to change the entity's state to 'Unchanged'. Either set a permanent

• Entity Developer - Changes lost on "Update Model from Database"

  Hello I have a large SQL Server 2019 database with thousands of tables generating an EF Core Model (.NET 8). When i created the model, some association endpoints are generated with names like "table_fieldname1, table_fieldname2" which is okay (usually,

• Unitable with postgreSQL (v17)

  I'm using TUniTable with postgreSQL v17. When I open semi large table (140 000 rows, 220 fields) with unitable it takes 3-4 secods. is there any way to avoid this delay, like take just first record etc unidac is latest 10. Server version: PostgreSQL 17.0

• Entity developer (NHibernate) 7.1.151 generating wrong SQL at Update the Database from Model

  Hello If you add an association between two entities with composite primary keys, entity developer (NHibernate) 7.1.151 will generate the wrong sql script at "Update the Database from Model". Example (Assoc is One Cat to Many Dogs, ISet) The generated

• How much time does it need Devart to fix bugs in ODAC?????

  Honest Question on ODAC Support Quality I am in the process of porting a massive application (5 million lines of code) from DOA to ODAC. The application uses an intermediate access layer, so my job is to port this layer from DOA to ODAC. I started this

• Can ODAC connect in Direct Mode with Kerberos?

  Hello, Our application has an option to use ODAC either in Direct Mode or using an Oracle client. When a client is used, customers can connect using Kerberos without any problems. That is, once it is configured in SQLNet.Ora and the Kerberos configuration

• IBDAC : TIBCQuery and TIBCEncryptor

  Hello, TIBCEncryptor work fine with a TIBCQuery connected to a Grid or if you do Dataset.insert or dataset.post. But it's doesn't seem to work if you add record with a TIBCQuery using execSQL like this ? MyQuery:TibcQuery; MyEncryptor:TibcEncryptor; ...

• Version Control on Script Files for Oracle

  Other Devart Tools allow for Source Control on Script Files but not for Oracle? Also there is no Schema Compare to Script Files, this is a major missing component. This allows Redgate to monopolize the market and charge $140,000.00 for a 50 user Enterprise

• 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

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

• 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

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