Recent Topics
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
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
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
Errors testing backup db with 20+ tables total 10GB
Hi, My first question evaluation dbForge Studio for MySQL, after a few days testing other stuff through the evaluation of ENTERPRISE. The "only" special circumstance is that it is on a MariaDB 10.4 db enginge with tables in innodb. I have verified that
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
SSMS 19.3 no SQL Complete after installation
Hi. Yesterday I installed SqlComplete 7.0. Everything went smoothly until I saw there is no SQLComplete menu in SSMS 19.3. There was no indication of error. I tried it twice, with same result. What should i do? How do I troubleshoot this? Thanks.
Set connection parameters via command line
Hello, we would like to use dbForge for MySQL with PAM solution (not Percona) that requires setting connection parameters via command line (username, password, dbname) to launch dbForge for MySQL application on Windows. Is that possible?
Unable to use dotconnect for postgres
I recently had to get a new computer and a previous web services site that worked fine under VS 2017 does not work under VS2022 and the error is when accessing the entity I get the following exception. Keep in mind the exact same site is working in production.
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.
Specify synchronization Order
This other software allows to specify the synchronization order so that integrity errors don't happen like foreign key issues. Is this possible with your current version of Data Compare? This is important to avoid, for example, having to disable a ProductPhotos
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
Entity Developer - Changes lost on "Update Model from Database"
Hello I have a large SQL Server 2019 database with thousands of tables generating an EF Core Model (.NET 8). When i created the model, some association endpoints are generated with names like "table_fieldname1, table_fieldname2" which is okay (usually,
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
SSL connection problem in dbForge Studio for MySQL
Hello. I have a problem with SSL connection in dbForge Studio for MySQL on one of my machines. An account in the database has 'REQUIRE X509' option, so it's required to specify a client key, certificate and optionally CA to connect. I have specified all
Entity developer (NHibernate) 7.1.151 generating wrong SQL at Update the Database from Model
Hello If you add an association between two entities with composite primary keys, entity developer (NHibernate) 7.1.151 will generate the wrong sql script at "Update the Database from Model". Example (Assoc is One Cat to Many Dogs, ISet) The generated
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
What happend to dbForge Studio for SQL Server?
Hi there I have now updated to the latest version of dbForge Studio for SQL Server. And in hindsight, that was a big mistake. - The time it takes for the program to start has increased by a factor of ten - Intellisense no longer works automatically -
I have Error in dbForge Monitor SQL Server "this metrics not supported by the current Microsoft SQL Server edition"
Hi, I have Error in dbForge Monitor SQL Server "this metrics not supported by the current Microsoft SQL Server edition" What have I do?
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; ...
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
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
ODAC: "Invalid Field Type" when calling a stored function with VARCHAR2 params
We have developed a VCL application in C++Builder, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. Our database is Oracle 19 running on an ODA with latest patches. The problem always occurs when I
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 ----------
Add Stored Procedure fails in DB First, unless trivial contents
Firstly, there seems to be no Support Category for Entity Developer. I hope that's not a reflection of the support for that product?? Most of the time when I attempt to add existing Stored Procedures to the model, the process fails when retrieving result
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
Intellisense/Suggestions for Locally Created Temp Tables?
I create local temp tables and query from them often in my script. In my previous installations of SSMS with (and without) SQL Complete, I was able to write "SELECT * FROM #" and would receive suggestions for available temp tables to query, including
Next Page