Recent Topics
Insert issue after upgrade
We recently upgraded from Unidac 8.4.3 to 11.0.0, with a corresponding Delphi upgrade from 10.4 to 13.0, that connect to a SQL Server database. We use a number of TUniQueries and TUniTables to insert records that no longer work after upgrading. The error
Unidac express and Oracle
Hello I am doing some experiment with Unidac express together with odac but I am experiencing an issue with latest release. I have installed version 14.0.1 of Odac professional, and version 11.0.1 of Unidac express. Simple form with UniConnection, UniQuery,
EF Core 10 support (Oracle)
It's been some time since dotnet 10 release. When can we expect version of Devart.Data.Oracle.EFCore that supports EF Core 10 ?
What happened to promised SQL to LINQ .NET core conversion?
Our company has been a consistent customer for several years now and we keep requesting for a SQL to LINQ conversion (.NET 10 core) tool built into dbForge Studio for SQL Server. DevArt keep saying "yes" in the next version, but every year we pay licenses
DotConnect for SQLite TransactionScope
Hi, I am trying to use TransactionScope together with EFCore but I am getting this error: System.InvalidOperationException : Cannot enlist local transaction, because current global transaction already contains distributed transactions. Stack Trace: DbConnectionClosed.Open(DbConnectionBase
sql course in chennai
SQL is a fundamental database technology employed for storing, managing, and analyzing structured data across different sectors. It allows professionals to efficiently write queries, retrieve insights, and manage data using relational databases. For students,
IBDAC Connection
Firebird 3/ IBDAC 7 Hello, i have a small client server network (2 pc's) . On the Client PC my connection ini file is : Data Source=192.168.1.10 Port=3050 DataBase=192.168.1.10:eOlive <-----Alias on Database.conf Client Library=C:\Windows\System32\FBCLIENT.DLL
Weird Code Completion List Issue With Snippet Shortcuts
Open a new query tab and enter a snippet shortcut (ssf for example). ssf is no longer selected by default. Next, construct the query, hit Enter a couple times, and enter ssf again: The snippet is now correctly selected. Tested on two different computers
SecureBridge detect lost connection
Hello, I am using a TscSSHClient and TCRSSHIOHandler with ODAC to connect to an Oracle database through SSH. A user has reported that sometimes the SSH connection is lost so his database connections become lost too, and then he has to restart our app,
Unidac and PostgreSQL 18.1
Does latest Unidac 11.0.0 support PostgreSQL 18 (which was released in September) or the latest version 18.1 ?
Will dbForge for Postgresql filter out comments when submitting queries?
Will dbForge for Postgresql filter out comments when submitting queries? If filtering is applied, it is recommended not to do so, as certain features of Alibaba Cloud Polardb may become completely ineffective. pg_hint_plan - PolarDB - Alibaba Cloud Documentation
Feature Request - AI Generated Commit Comments
It'd be really useful if, after the objects to be committed are chosen in Source Control Manager, the AI Assistant could generate the commit comment.
SSMS 22 support
Do we have any plan for integrating SQL Complete into SQL Management Studio version 22 (SSMS 22)?
no prompts for package procedure parameters
dbforge for oracle 6.0.85 and prev
Maximum Depth Of An Expression Tree in direct mode on TUniConnection
Hi, how I can increase Maximum Depth Of An Expression Tree value in direct mode on TUniConnection?
dbexpress for Oracle and PostgreSQL different behaviour (probably bug in oracle one)
Hello Environment Delphi 11.2 Latest dbexpress drivers for Oracle and PostgreSQL PostgreSQL database: Insert sqlconnection, configure access, connected := Truee Insert SQLQuery, link to connection, edit SQL: "select * from TABLE where field = :P1" Confirm
What is core ball?
Coreball is an addicting online game that you won't be able to put down! Zigzag your way to the high score! Coreball (also named “Core Ball”) is a classic little arcade game that can be played online. The concept of this game is followed by an idea from
Linq Connect Update Timeline
Is there a timeline for an update to LinqConnect 5.-0.151 to support the recent updates to visual studio? Thanks -Pete
On Mac M3 moving from Devart.Data.MySql.EFCore 9.3.21.8 to 9.4.290.9 causes AccessViolationException
Hi, We try to move from EF Core 8 to 9 but looks like on Mac M3 it crashes instantly when we update the Devart.Data.MySql.EFCore package. It throws this : Fatal error. System.AccessViolationException: Attempted to read or write protected memory. This
KeyNotFoundException when using Oracle spatial functions in EF Core 8
Hello, We are in the middle of upgrading EF Core 6 to EF Core 8 along with upgrading from .NET 6 to .NET 8. We found and reported an issue when analyzing this upgrade. That issue is here: https://support.devart.com/portal/en/community/topic/unexpected-sqlparameterexpression-implementation-when-using-oracle-spatial-functions-in-ef-core-8
dotConnect for Oracle - Devart.Data.Oracle.OracleException - ORA-00933: SQL command not properly ended
Devart.Data.Oracle.OracleException (0x80004005): ORA-00933: SQL command not properly ended was raised when I use MaxBatchSize. Versions: - Devart.Data.Oracle.EFCore :10.4.235.8 - Devart.Data.Oracle :10.4.235 - EntityFrameworkCore: 8.0.13 Ex: optionsBuilder.UseOracle(_oracleSessionManager.GetOrCreateOracleConnection(),
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
Devart.Data.Oracle.EF6: Can it have .Net Framework support in Nuget?
Hello, I am currently updating our dotConnect for Oracle (DevArt.Data.Oracle) package to 10.3.10 in our .NET Framework 4.6.2 solution. I would also like to update Devart.Data.Oracle.EF6 to 10.3.10 but the dependencies in nuget requires .NET Standard 2.1:
Entity Developer and Composite Keys
Hello, Is there are way within Entity Developer, prior to code generation, to flag attributes, and remove the warnings e.g. Northwind db (image) so my generated code mappings won't have an issue. Thanks.
dbforge mysql query delimit option
we use dbforge mysql for schema compare and patch generation for db sync; dbforge forge generate query and use delimiter $$, ; automatically. we want to change delimiter character. is there option already?
New AI Feature in dbForge Studio for SQL Server
Good start but a bit rough when actually using it, both in terms of UX and output. My first prompt, "Explain this query", resulted in a 500 internal server error. I figured out I had to include the query with the prompt but in these cases, Studio should
ODAC and Oracle Home
Hello... I am doing some test with ODAC ... for possible switch from dbexpress... I have Oracle 26ai FREE installed in my windows 11 machine I do see that OraSession does not populate "Home", and by consequence neither the Server names... If I try to
RowsAffected
Hi, Delphi 10. Firebird 3.x IBDAC using query like SELECT * From Chat and DLM Statements : INSERT INTO CHAT (ID, IDUSER, IDUSERTO, IDUSERFROM, DATETIME, MESSAGE, ISNEW) VALUES (:ID, :IDUSER, :IDUSERTO, :IDUSERFROM, :DATETIME, :MESSAGE, :ISNEW) Or UPDATE
Suggestions popping up when writing comments
Hi, I noticed a problem with typing comments that started sometime in 2025, I think, but I'm just now getting around to reporting it. If I start typing a comment block at the top of a query window with two dashes (--), then SQL Complete pops up the suggestion
connection to cloud autonomous database in direct mode
Hello all, I know how to connect using OCI client to cloud oracle autonomous database, what I am asking is if there's a way to connect using dbxoda in direct mode... Is there some tutorial or blog post or whatever on this topic? in case dbexpress is unable
dotConnect for MySQL for VS 2026
Is there a date for the next VS 2026 and .NET 10 compatible release?
Debug SP in SQL Studio
Hi I am trying to debug SP in Studio for SQL Server it is workign well and, I also can see veriable value which declare in SP like int or nvarchar veriables. but if i ma using tbale veribale like , CREATE TABLE #TempValidation ( TempValidationID INT IDENTITY(1,
TUniConnection feature request
Hello Please add TUniConnection.CommandTimeout specific option for SQL Server because ConnectionTimeout and CommandTimeout are not the same things. See MSClassesUni.pas, line 1246 It's need for Connection.ExecProc and Connection.ExecProcEx
Some suggestions regarding query statements and query results
1. Can the software add a query statement saving directory configuration? Query statements should be saved by default in the current database under the current connection name in this directory. When switching to the current connection and current database,
When will dbForge Studio for PostgreSQL have similar features to dbForge Studio for MySQL?
When will dbForge Studio for PostgreSQL have similar features to dbForge Studio for MySQL?
Use Modern File Open Dialog
It'd be nice if dbForge Studio called the modern Windows File Open dialog box instead of the XP-era dialog box it calls now. Having easy access to pinned locations would be useful.
SSMS 21 Support
I'm starting to test SSMS 21. Is there a roadmap of when you might add support for SSMS 21?
How to retrieve the field structure in a dataset ?
I searched Google and couldn't find anything about it. I use "Unidac" and I'd like to know if anyone has created a function to return the SQL field structure. Example SQL SELECT
Case When (CC.FOTO is Not Null) Then 'Sim' Else Null End as FOTO
FROM CADASTRO_PESSOAS
SDAC 8.2.8 - stored procedure output parameter
I am using SDAC 8.2.8 with D 10.2 and have strange problem that I think might have already solved, however it is all strange, maybe someone will be able to explain what is going on. I have stored procedure in MS SQL Server: CREATE PROCEDURE [dbo].[AAAA]
Strange error attempting to save a record with a blob jpg...
I have developed a VCL application in Delphi, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. It uses Devart MySQLDAC 12.2.1 For RADStudio 12 for database My customer has just emailed to say they
Next Page