Recent Topics
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
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
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]
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?
SSMS 21 Support
I'm starting to test SSMS 21. Is there a roadmap of when you might add support for SSMS 21?
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.
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";
How to Use the Crafting Machine in Steal A Brainrot
If you’ve been playing Steal A Brainrot for a while, you probably know that the crafting machine is one of the most essential tools in the game. Whether you’re looking to upgrade your items, create rare components, or just experiment with different combinations,
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
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(),
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?
Firebird - RETURNING not working
Hello. I'm having problem in Firebird with RETURNING value with latest Unidac 10.1.0 on Delphi 11 update 3. Problem occurs when "same" query is used for SELECT and INSERT/UPDATE. I've attach db.txt with sample table T1 with three fields (ID,f1,f2). Here
How do I show the Functions/Procedures within a Package
I'll be respectful since I'm a user that has used Oracle Toad for probably 20+ years. The list below are features available within Toad and I don't see how to accomplish these tasks within dbForge Studio for Oracle. How do you display the Functions/Procedures
"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
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
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
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
Devart.Data.Oracle "PInvokeStackImbalance" error in debug mode
I created the following small C# program and keep getting the error message shown in the screenshot. I'm using Visual Studio 2019. The program is compiled as 32-bit. The Oracle client = NT_193000_client. I've also tried oracle client 11.2.0 but the same
Connecting to a PostgreSQL database using SSL when the server requires SNI
Hello, We have a problem connecting to a certain cloud PostgreSQL database using SSL, because the server requires a server name indicator (SNI). We tried the both connection ways described in the "Connection to PostgreSQL through SSL in Delphi" manual
Feature Request - Object Bookmarks
It would be very useful to be able to bookmark objects in the Database Explorer. It can get tedious moving between different objects in different tables in different servers... It would be useful to be able to right-click and bookmark an object (table,
RAD Studio 13 Florence
Hi, I was wondering when mysqldac delphi components would be available for RAD Studio 13 Florence?
Test
test test
dbExpress Driver for SQL Server support for TLS 1.3
Does dbExpress Driver for SQL Server supports TLS 1.3?
innodb retry on ERROR 1213 (40001): Deadlock found
Hi, I recently had to switch some tables from MyIsam to InnoDB, and now I am getting errors when doing inserts from different threads: ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction I am currently changing my code
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
Strange Refresh Failed error message
Hello, I have a TOraQuery component, with a relatively simple select. It joins tables for the master table called ATB. select atb.rowid, atb.*, sby.c_nev1 c_belep_szintnev, bko.c_nev c_szervezetnev, saj.c_nev1 c_uzemkodnev, bkp.c_nev c_onelszamolonev,
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?
Data sync is too slow
I'm syncing data between a dev and production mysql db using dbForge's data compare tool, which is great, except the table has 1.7m records and it's sync'ing one record at a time. This thing will take weeks to finish. Is there a faster way to do this?
Devart.Data.Oracle.EFCore in Azure Web Apps
I have an open ticket for this but wanted to see if anyone else has been able to get EFCore to work with Oracle, dotnet9 in an Azure Web App. Using the line works locally but not in Azue. builder.Services.AddDbContext<TestOracleDbContext>(options => options.UseOracle(vcisDbConnection));
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
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
Changing any paramaters in a NEW unsaved stored procedure, cleaars all of the SQL code section
HI ! This is for DBForge studio 2025.1.134 It did the same thing in 1.124 as well. I thought I saw this posted already. I went looking for it but could not find it. so posting it here. If you create a new stored procedure, then go to the SQL code section
Next Page