Recent Topics
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
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
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
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
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?
SSMS 22 support
Do we have any plan for integrating SQL Complete into SQL Management Studio version 22 (SSMS 22)?
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,
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 ?
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,
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
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
VirtualTable SaveToFile saves the file with zero permisions (chmod 0)
I am trying to recover my old Linux Lazarus source files and working with Lazarus v2.2.6 and VirtualDac v13.2.1 It is working well so far except I ran into this weird behavior where the VirtualTable.SaveToFile method saves the file with zero permissions
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?
Oracle connection error - Invalid Bytes count
I am getting error when connecting to oracle. I have tried with .NET 6 and .NET 8 string connectionString = "" + "Server=myserver;" + "Port=1521;" + "User Id=myuserid;" + "Password=mypassword;" + "Service Name=myserver;" + "Direct=True;" + "License Key=mykey";
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
memory leak
memory leak problem is very serious,memory uses will continue grow to several GB level.
new UNIDAC (11.0) don't support Unicode? older version (9.3) done well.
new UNIDAC (11.0) don't support Unicode? older version (9.3) done well.
ODAC 13.4.1 different behaviour related to ODAC 9.0.1 related to persistent fields on Delphi 7 and Oracle 19.22
Hello, Recently we updated our libraries on an old but important project from ODAC 9.0.1 to ODAC 13.4.1 and we observed the following: After the update in case an OraQuery gets a persistent field having the size property holding a value less than the
getting error connection error 08006 or Error: No such host is known
Hi, We got an error on and off as "connection error 08006" or "Error: No such host is known" when we try to run some report . But if we re-run the same report again, then no error will be shown. Do you have an idea what causing the issue? below is a sample
Update Failed
Hi I upgraded to IBDAC 10.0.0 and now there is an error after inserting a record. (after the refresh) "Update Failed Found 0 records" Now I have downgraded to 9.3.0 and it works again. I have a TIBCQuery-Object with SQL: SELECT KDMANAG.*, (Select MINAME
IBDAC Firebird Prepare
Hello, i am confusing using Prepare when setting parameters, should i set the values before prepare or after : SQLQuery.Prepare; <-------------------HERE SQLQuery.ParamByName('Param').AsString := 'YourValue'; SQLQuery.Prepare; <------------------- OR
Update from 9.5.15 for RAD Studio XE4 to most recently
Hello, I am currently using version 9.5.15 of your product with RAD Studio XE4. I would like to know if there are commercial options available to upgrade my license to a more recent version. Could you please provide details on the upgrade process, pricing,
MyDAC with Lazarus
I am currently using myDAC Professional 13 with Delphi 12.1 and would like to test with Lazarus. Just checking - I would need to upgrade to MyDAC Professional with Source Code? Are there any docs on how to install myDAC for Lazarus?
Next Page