Received error message not overriden in inherited class
with securebridge (ssh connection i received this error message. In local connection not received nothing Any idea why I received this error see attach file
Direct connect to MS Access in 64bit application
Hi, Since we have issues with connectivity through OLE DB (using ADO) on certain installations (mostly windows hosts with win32 Office installed) we're trying to use UniDac in order to connect to a MS Access database in direct mode. Delphi 10.4 and UniDac
securebridge with mydac
ThirdParty demo mydac are SecureBridge(Deprecated) and SecureBridge With last delphi 12 with patch wich one should be install deprecated has MySSHIOHandler and MySSLIOHandler In mydac connection handler properties have no longer available components if
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
TUniLoader
I'm using TUniLoader with SQL Server and it works fine. I would to know when the component finishes writing data on the database. Is it at the end of OnPutData event?
UniScript unterminated dollar-quoted string
I have a problem with Uniscript when running the command below CREATE OR REPLACE FUNCTION public.fin_fc_cte_integracao_fin() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE vFlgBaixado boolean; BEGIN IF (TG_OP = 'DELETE') THEN SELECT (CASE WHEN dat_bai
Access Direct Mode Connection Fails if Database has a Query (View)
We get EAssertionFailed with a message beginning "jTYPE_ATTRIBUTE" (JetTable.pas line 5126) when using an Access database in Direct mode, but only if there is a query defined in the database. We are using UniDAC 10.3.1 for Rad Studio 10.4. Recent release
Oracle AQ - Dequeue from a sharded queue causes invalid cast exception
Since i converted my Oracle queue into a sharded queue, the OracleQueue.Dequeue function always throws an invalid cast exception in Devart.Data.Oracle.dll. When i used a normal queue everything worked fine.
Oracle-19-24 issue in DirectMode
Hi, We have the same issue: https://support.devart.com/portal/en/community/topic/oracle-19-24-aso-directmode Is there any forecast for the release of the official version? Could you give us the access to the pre-release build? Regards
System.AccessViolationException when having parallel db writes using Devart.Data.SQLite.EFCore
Hi, I've observed and AccessViolationException when running unit tests in parallel. Investigating this I found out that creating multiple different databases, or even inserting new entities in a database, in parallel can cause this exception: Fatal error.
'relation "__EFMigrationsHistory" already exists' when running multiple migration sets
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. The application has multiple modules with migrations for module-specific entities and all migrations are applied to the same database.
OptimizedBigInt on Mysql 8.*
Hi, I have OptimizedBigInt on in options, and in MySQL server 5.7 this SQL works well and produces an integer field type: FLOOR((DATEDIFF(CURRENT_DATE, STR_TO_DATE(Birthdate, "%Y-%m-%d")) / 365)) AS Age But on MySQL 8.*, I am getting: Type mismatch for
PostgreSql.EFCore: problem querying spatial data
Hello I migrated from .Net Framework to .NET Core 6.0 and have a problem querying spatial data. DbContext is extended with: optionsBuilder.UsePostgreSql(connectionString, options => { options.UseNetTopologySuite(); }); I use database first approach, the
"CROSS APPLY" is not supported in Postgresql?
Hello If I use a LINQ query over 2 tables, I get an error 42601: syntax error at "APPLY" It seems that the SQL contains "CROSS APPLY" which is unknown in Postgresql. How can I avoid that ? Never had that problem with the previous versions (.NET Framework)
No data gets written to the database with Devart.Data.Oracle.EFCore 10.2.0.7 and Microsoft.EntityFrameworkCore 7.0.15
Hi, I'm working on migrating an application from .NET Core 3.1 to .NET 6. This project previously used to following nuget packages without any issue: * Microsoft.EntityFrameworkCore 5.0.4 * Devart.Data.Oracle.EFCore 9.14.1228 I have now updated those
EF Core 7 MaxBatchSize and auto generated ID's
When using a MaxBatchSize I get an Exception when inserting a record, the ID is auto generated by the database: The property 'Planning.PLANNING_ID' has a temporary value while attempting to change the entity's state to 'Unchanged'. Either set a permanent
Unitable with postgreSQL (v17)
I'm using TUniTable with postgreSQL v17. When I open semi large table (140 000 rows, 220 fields) with unitable it takes 3-4 secods. is there any way to avoid this delay, like take just first record etc unidac is latest 10. Server version: PostgreSQL 17.0
How much time does it need Devart to fix bugs in ODAC?????
Honest Question on ODAC Support Quality I am in the process of porting a massive application (5 million lines of code) from DOA to ODAC. The application uses an intermediate access layer, so my job is to port this layer from DOA to ODAC. I started this
Can ODAC connect in Direct Mode with Kerberos?
Hello, Our application has an option to use ODAC either in Direct Mode or using an Oracle client. When a client is used, customers can connect using Kerberos without any problems. That is, once it is configured in SQLNet.Ora and the Kerberos configuration
IBDAC : TIBCQuery and TIBCEncryptor
Hello, TIBCEncryptor work fine with a TIBCQuery connected to a Grid or if you do Dataset.insert or dataset.post. But it's doesn't seem to work if you add record with a TIBCQuery using execSQL like this ? MyQuery:TibcQuery; MyEncryptor:TibcEncryptor; ...
SDAC SQL Server 2022 (express) - Connection forcibly closed (10054)
I have just released a new version of our main product to a select few customers, and I've already received a bug report with the following error: Error on data writing to the connection: An existing connection was forcibly closed by the remote host.
SQL Server 2022 - Native Client
Hi I've read that the native client isn't recommended for new projects. I currently use SDAC and use prDirect as the provider, but I wondered, what your plans are for the prNative option? Thanks Chris
Firebird query statistics, int32 of int64?
Hi, In my application, I'm using TIBCConnection.DatabaseInfo to fetch query statistics, the Reads/Writes/Fetches/Marks fields. These are int32, but I think these should be int64. Can you check with the API? Here's an example of values that clearly overflow
Advice for using VirtualQuery
Hello, We are developing software under Embarcadero Sydney with TUniQuery component on Firebird or SQL Server DataBase. We have noticed that using a VirtualQuery is much faster (especially when sorting). From there I have two questions : 1. Question ----------
Occasional access violation in ODAC 13.3.1 when TOraSession is destroyed
Hello, We recently updated from ODAC version 13.2.1 to 13.3.1 and are now seeing an occasional access violation when TOraSession is destroyed. I am not able to reproduce this at will so I cannot provide an app to demonstrate the bug at this time. I do,
Oracle 19.24 + ASO + DirectMode
Hi I just applied Oracle 19.24 (Security Patch July 2024) to my database and the direct mode no longer work If I disable native encryption it works. Test case: $conn = New-Object Devart.Data.Oracle.OracleConnection('Direct=true;User Id=test;Password=***;Port=1521;Service
TScSMTPClient.AuthenticationType no longer available?
Hi, today I upgraded my SecureBridge from version 10.4.1 to the recently released 10.6.0. When I went to compile my project I found that the TScSMTPClient.AuthenticationType property is no longer available, so I can't define an authentication type before
Store RTF text
I am using Unidac 10.1 with Delphi 11.3. I am using an inherited component from TcxRichText from Developer Express to store formatted text with RTF in database. I am using MS SQL Server with type NVARCHAR(MAX) on the column. My problem is that rtf text
License Issue / Net8Core
Hello! I have the license key for Postgres Connector - Expiration Date Apr28, 2026. In the online overview for the License it tells me 'Available Product Version' 8.3.21 Now the Key and Nuget 8.3.21 works well with Net Framework 4.8 and Net5core on Linux.
migrating from firebird 2 to 4
I use dbx with dbexpress driver I am migrating from firebird 2 to firebird 4 and it returns the error: type mismatch to field 'QNTSAI', expecting :FMTBcd actual : Float I need a way to use both versions until I migrate all the databases delphi11 with
TScSMTPClient for dummies
Hi, I am playing a little around with ScSMTPClient and was able to send mails. I am currently failing to get/receive an errror when using an non existing adress no matter wether used as a from or to address. Am I right that this is probably related to
Salesforce ODBC driver exceeded API Requests allowed
A few days ago we used more than the 249k API requests our Salesforce license allows within 24 hours using your Devart ODBC driver. I can see the current number next to the label "API Requests, Last 24 Hours" on https://*.lightning.force.com/lightning/setup/CompanyProfileInfo/home
How to support non Unicode fields when using TUniConnection 10.2.1 to connect to SQLite database?
TUniConnection 10.2.1 When connecting to an SQLite database, because the field type of the table in the SQLite database is varchar (100) instead of Nvarchar (100), it is intuitively not a Unicode database, My current problem is that when I compile a program
Is SecureBridge 10.5.0 compatible with RAD Studio 12.2 - Patch 1
Hi, When I try to install SecureBridge 10.5.0, with the recently released RAD Studio 12.2 (Patch 1), i get warning message. "You are using a version of RAD Studio 12 that is required for SecureBridge 10.5.0." Is SecureBridge 10.5.0 compatible with RAD
RAD Studio 12.2 Athens Inline Patch 1 / UniDAC 10.3
UniDAC 10.3 does not work with the latest RAD Studio 12.2 Athens Inline Patch 1.
What does "Net: Invalid VerifierType" mean?
Hello, A user is attempting to connect to the database with ODAC in direct mode and receiving the error "Net: Invalid VerifierType". What does this error mean and how can it be solved? I see it in OraNetLogon.pas, around line 1529 but of course I can't
RAD Studio 12.2 Athens Inline Patch 1 / ODAC 13.3.0
ODAC 10.3 does not work with the latest RAD Studio 12.2 Athens Inline Patch 1. Starting Delphi 12.2 shows errors like this (german version): "Der Prozedureinsprungpunkt "@Idetheme@Utils@TIDEDialogRegistryServices@$bcctr$qqrv" wurde in der DLL "C:\Embarcadero\Studio\23_components\ODAC\Bin\Win32\oramigwizard290.dll"
MyDac 12.3 and RAD Studio 12.2 Athens Inline Patch 1
MyDAC does not work with the latest RAD Studio 12.2 Athens Inline Patch 1. Can you please update the install file?
UniDAC fails to load in Delphi 12.2 Patch 1
Tried reinstalling but still get entry point error when opening Delphi.
UniDAC SQL Server - prDirect vs. prNativeClient
I use prDirect for SQL server now. My question is, if there is any advantage when I use prNativeClient or prMSOLEDB compared to prDirect? Christian
Next Page