Recent Topics
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
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
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));
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
SecureBridge - Memory leak in procedure GetIPInterfaces (CRSocketImpl.inc)
Hi, I found a memory leak in procedure procedure GetIPInterfaces (CRSocketImpl.inc). Function Marshal.AllocHGlobal is called witout Marshal.FreeHGlobal. Leak is present in both 10.7.0 and 10.8.0 version. Thanks.
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
IBDAC - Firebird 5 and the Option: isc_wish_list
The release notes for Firebird 5.0.3 state the following on page 43: https://www.firebirdsql.org/file/documentation/release_notes/Firebird-5.0.3-ReleaseNotes.pdf Engine provider sets isc_wish_list error in status and returns zero, when appropriate. Remote
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++
I own UniDAC for SQLite dbs on Android, but should I be using LiteDAC?
I only access SQLite dbs, and only on Android. I've read that LiteDAC is possibly faster for accessing SQLite. But does it lack any features that UniDAC provides, insofar as working with SQLite dbs? If not, I will buy LitDAC as well. Thanks for your
Schema Synch Wizard Re-Using File Names
When I launch a brand new schema compare I really, really, really don't expect the wizard to default the save script file name to the same name as what the prior compare (against different databases) used, thereby wiping out the saved script without any
Add related table lookup functionality to read-only mode
When the results of a query are in edit mode, clicking on a field which is a foreign key reveals a dropdown list of possible values from the primary key table. It's be nice if this feature could be extended to read-only mode so the related data can be
Oracle - EFCore - Hints
Hi, I am trying to use OracleFunctions.Hints("ALL_ROWS") in a project that is using Devart.Data.Oracle.Entity.EFCore. What is the recommended way to add Oracle optimizer hints in EFcore ?
dbForgeSync@1 task issues
I am running an azure pipeline deployment where I take my Schema and Static data in Git, packing it using the dbForgePackage task and deploying it against a database using the dbForgeSync tool. My task looks like the following: - task: dbForgePackage@1
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
Advice on which Unidac components to use in android app
I have a small personal android app which accesses a sqlite database with several tables. The app is single user, no db sharing. Only one table open at a time. Browse, add, edit, delete, search. I currently am trying out a TUniconnection, and a TUniQuery
How to search within stored procs with dbForge for MySql
I would like to be able to search for text and have it look at stored procs and column names, stuff like that. Basically I want something like Redgate's SQLSearch tool for SSMS. Is that in dbForge Studio already or can I request something like that be
Handling of NaN > DevArt Connection Exception
Hi, PostgreSQL DataAcess Components if there is "NaN" in a Numeric column (that is allowed per default by postgres). Devart will fail. The following easy example shows the problem, DevArt is unable to open this dataset. If there is one row in 1000000
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
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
AI Assistant code generation incorrect (missing chars)
I've been working with testing query optimization this morning and finding that the generated queries are not displaying the greater than or less than symbols. For example, a condition 'WHERE someNum <> 0' gets generated as 'WHERE someNum 0'. Any way
Restoring Tabs After Restart Getting Worse
dbForge Studio for SQL Server 2025.1.124 seems to be noticeably worse at restoring tabs after a restart. I'm down to two sql tabs being restored from about the ten I had yesterday after a couple of restarts.
How can I get SQLComplete to format Table Check constraints?
I'm using SQLComplete version 2025.1.134 and have the following table definition: CREATE TABLE MyTable ( [Column1] INT NULL ,[Column2] INT NULL ,CONSTRAINT [CK_MyTable] CHECK ( ( (__Universe2HybridBenchmarkId IS NOT NULL AND __Universe2AccountBenchmarkId
dbforge studio4oracle problem restoring windows/toolbars layout after restart app
Hi. reproducing case: 1. make any changes in windows/toolbars layout what differ from default, 2. place and pin find and replace dialog as on image 3. restart app windows and toolbar layout will be reset to default dbforge studio4 oracle v 2025.1.134
Suggestions for optimizing the log output function
1、SQL1.sql truncate aaa; truncate bbb; truncate ccc; truncate ddd; truncate eee; truncate fff; truncate ggg; truncate hhh; truncate iii; truncate jjj; truncate kkk; truncate lll; truncate mmm; truncate nnn; truncate ooo; 2、SQL2.sql truncate aaa; truncate
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
dbForge Extented Event Profiler for SQL Server
I have downloaded the dbForge Event Profiler in the recent version 2025.1.134 and installed it. When the UI opens and you click on anything but nothing will work ..it hangs for a bit and nothing happens. not even the help menu is working. There is no
Next Page