Recent Topics
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?
SQL Complete Execution History Import
Is there a way to move over query execution history from one computer to another?
TScFTPClient 'FTP server error occurred: TLS required, configure with AUTH first.'
Get the EScFTPError 'FTP server error occurred: TLS required, configure with AUTH first' FFtpClient.TLSMode := tmRequireExplicitTLS FFtpClient.SSLOptions.IgnoreServerCertificateConstraints := true; FFtpClient.SSLOptions.IgnoreServerCertificateInsecurity
.NET 9 - Devart.Data.Oracle.EfCore - Discriminator issue with include
Hello Devart, When using discriminators in EF Core and then including navigational properties which aren't available on all discriminated types, only on specific derived types: var result = await ctx.Vehicles .Include(_ => ((Car)_).PossibleEngineTypes)
Memory leak in SecureBridge
Hi, Securebridge initialization code as allocates object which is newer release causing memory leak. I know that it's not dangerous, cause it doesn't repeat but I was just wondering could the code be fixed so that while catching memory leaks, I wouldn't
.NET9 Ef Core 9.0.1+ Object reference not set to an instance of an object.
Hi, I'm getting Object reference not set to an instance of an object. from Microsoft.EntityFrameworkCore.Relational at pretty much each query. For example: await context.TV_USERS.AsNoTracking().Where(x => x.ID == Id).FirstOrDefaultAsync(ct); I'm using
Invalid command line. Unknown switch 'connection:user'.
I've been using dbforgemysql in Windows for manual backups and decided to automate it after a recent server crash at our ISP. I've followed the directions, but no matter what I do I receive an error. Invalid command line. Unknown switch 'connection:user'.
SecureBridge Installer won't let me uncheck any components
Hello, I want to uncheck the following in the SecureBridge installer, but the boxes don't respond when I uncheck them. SecureBridge files for Win64 (Modern) SecureBridge files for macOS SecureBridge files for Android It's not a big deal, just annoying.
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
DateTimeOffset.Date does not correctly truncate time in dotConnect for PostgreSQL
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. We have been using multiple methods from the DbFunctions class, many of which were removed in EF Core. From my understanding, DateTimeOffset.Date
SDAC older versions download
Hello, Where can I download older versions of SDAC? I have UniDAC installed on our developer machine and it says I need very specific version of SDAC, not any two versions are compatible. So, I need to try SDAC on Delphi 11 Alexandria, specifically version
C++ Builder error: E2015 Ambiguity between 'Crjson::TJSONObject' and 'System::Json::TJSONObject'
I just moved one of my C++ Builder projects to RAD Studio 12.2 and UniDAC 10.3.2. I am getting the above error plus E2015 Ambiguity between 'Crjson::TJSONArray' and 'System::Json::TJSONArray'. I am only using TJSONObject and TJSONArray in this project,
How to quickly find DB Connections
Does anyone have any solutions for how to quickly find DB connections in Database Explorer when you work for a large company and have thousands of connections for all different servers? There isn't even a search bar and it would take forever to manually
dotConnect for MySQL parses sbyte incorrectly
Hello, I've recently bought dotConnect for MySQL and this is the first problem. All versions are current, .NET 8 with EF Core 9 and Devart's 9.4.191.9 My database has some columns that are tinyint in MySQL, which has the range -128...127. dotConnect's
How to specify Time Zone format
Hello, It looks like there is now a way to specify time zone format in ODAC. How can I specify it in my code, if I want timestamps in query results (like a TSmartQuery attached to a grid) to always have a specific format. I want to use TZR, to solve the
SQLite low-level
i want to understand - can i use unidac/litedac in low-level mode? without connections, datasets and so on. as i see - a can use LiteStaticUni module. and, may be, some thing else. is there are some description or manuals for it?
TUniQuery fails with Parameterized UpdateSQL while updating data in AWS to Bablefish for Aurora PostgresSQL
Hi We have been using your wonderful library of UniDAC components (for SQL Server) for several years now and currently use version 10.1.0 professional version for Delphi 12. Currently we were evaluating to move our database to AWS through Bablefish implementation
Secure bridge sign PDF
hello i need help about signing some PDF file, with secure bridge... Some examples, sign with PFX or from smart card...
Define ClientID and ClientSecret in Dynamics365 ODBC DSN
Hello, how is it possible to store a ClientID and a ClientSecret in a Windows ODBC connection for the Devart driver in the ODBC Manager? I only see the option to generate a token, and I am then prompted to log in. However, I would like to create an app
Schema Compare for Postgresql: Triggers comparison
Hello Where can I find an exhaustive list of what schema objects are currently supported and not supported when doing a schema comparison using dbForge for PostgreSQL? I was under the impression triggers are supported by this does not seem to be the
Oracle Idle Time and Odac
I am running Odac 12.1.1 with Oracle as my database. In Oracle, the idle time is set to 1 min. SQLPlus disconnects perfectly after 1 min idle time. My frontend application however exactly disconnects after 3 min Why is that ? Anyone else seen such behaviour
Why no feature to convert T-SQL to LINQ for .NET 9 Core?
I keep requesting and keep hoping my yearly subscription will get T-SQL to LINQ for .NET 9 core. But sadly every year passes an no feature added? Stored Procedures are a thing of the past and most development projects no longer use them. It's 2025, can't
Documentation tool doesn't generate flow diagrams for Stored Procedures?
I'm puzzled that such an important feature for those of us converting legacy databases to a more modern architecture don't have any tools that can flow diagram T-SQL stored procedures? I feel like your products are dancing around "real world" developer
VirtualQuery IsNULL
Hi, Is use a virutalQuery to show informations : 1. SELECT A.INT_COUT,A.MAT_ID,A.INT_DEB,A.INT_TECH,CAST(SUBSTR(A.INT_DESC,0,255) AS VARCHAR(255)) AS INT_DESC_T,CAST(SUBSTR(A.INT_ACT,0,255) AS VARCHAR(255)) AS INT_ACT_T,A.INT_FIN,A.INT_TYPE,(B.T_CIVILITE
.NET 9 - Devart.Data.Oracle.EfCore - NullReferenceException
Hi, On EFCore 9, with today driver v10.4.191.9, many operators are failing with this error : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression.PushdownIntoSubqueryInternal(Boolean
SqLite Localized Order
Hi With Android Studio Java I can select a sqlite table like Select * From MyTable Order By Name Collate Localized The data returns ordered by with my language specific characters But there is no such an option with Delphi/Unidac I receive an exception
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
Invalid SQL when ordering on a calculated boolean field: "ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering on a calculated boolean field. This is an example of the invalid SQL: SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m0" WHERE "m0".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END) "HasMoreThenOneModel",
Ora error when filtering/ordering on a calculated boolean field: "ORA-00933: SQL command not properly ended"/"ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering/filtering on a calculated boolean field. This is an example of the invalid SQL SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m" WHERE "m".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END)
Cannot find Datamodel.hbml file error NHibernate
I am following the instructions for database first creation. However, at the end, the template fails to find the hbml file in the appdata folders. This only happens with NHibernate templates.
.NET 9 - devart.Data.Oracle.EFCore method not found
Updating everything for .NET 9.0 and suddenly I get the following error: System.MissingMethodException: 'Method not found: 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlConstantExpression Microsoft.EntityFrameworkCore.Query.SqlExpressionFactory.Constant(System.Object,
Batch move and creating destination table in Access
Hello! I'm experimenting so that we can move away from Paradox onto something a little bit more useful. For the time being, however, the "temporary fix" is Access. Let's not go into the why, how, etc. For now this is the best course of action. The access
Is there a better way to view this panel info?
When viewing indexes for a table, the index "details" panel (see image attached) is incredibly awkward, being compressed into a small space. Is there a way to better view that panel to use it more easily? e.g. a different window/panel arrangement or an
MMOexp New World to the gameplay
In the vast world of online gaming, few titles have generated as much buzz as Amazon Games’ New World. Set in the mythical land of Aeternum, this mmoexp invites players to explore a vibrant open world, engage in combat, and establish settlements. Following
Rsorder OSRS gold in hopes
Playing an Ironman account on Old School RuneScape (OSRS) has become an increasingly popular challenge for players who want to take the game to a new level of difficulty and satisfaction. Ironman mode restricts trading and other forms of assistance from
MMOexp Diablo4 with the combat
Since its launch, Diablo 4 has captivated players with its dark, immersive world, engaging storyline, and a robust system of character customization. With numerous gameplay elements to explore, one aspect that stands out is the game's tiered difficulty
Compare to schema inside same database
Hi, I started to evaluate DbForge Studio for PostgreSQL. I wan't to compare schemas inside database. (I mean those schemas which are created by CREATE SCHEMA myschema); our use case is for example a franchising chain, where all companies are under same
ODAC local filter raises EVariantTypeCastError
We have tried to use a newer ODAC version in production. The following issue is a showstopper for us. It seems that this issue exists since version 12.3.0. Steps: - compile and execute the following command line application Expected: the output is PASS
SecureBridge TscSSHClient irregularly causes critical crash in FMX app on IOS when disconnecting
Hello, after refitting a mobile application with SecureBridge to enable SFTP data exchange I have encountered the following problem: In irregular intervals the app crashes fatally when performing an SFTP data exchange. With the help of the debugger I
DBExpress driver for PostgreSQL
Hello, I've read that you can't use multi transaction with Devart drivers for PostgreSQL. But I also read that PostgreSQL seemed to support it. Can you tell me what's going on? Thank you in advance. Lbn69
Next Page