Recent Topics
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
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
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.
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
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
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
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
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.
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.
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
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 -
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
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
Review Assistant freezing/slow
Hi, We're currently evaluating Review Assistant with a small team, however are noticing substantial timeouts and poor performance (long delays/stalls) when adding a comment, or (for example) changing the filter from "All Reviews" to "My Reviews". We are
TScFTPClient - SSL Negotiation Command is Failed
Our company recently purchased your FTP components and I'm using TScFTPClient to try and connect to an FTP server with TLS. I can call the client's Connect method OK, but when I attempt to use the Login method, I get an error message stating, "SSL negotiation
An error occurred when receiving wrapped code for the 'LOCUS.INC' object: ORA-06550: line
I get this error when I do a schema compare between 2 databases. An error occurred when receiving wrapped code for the 'LOCUS.INC' object: ORA-06550: line 13, column 37: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 13, column 7: PL/SQL:
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
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
EntityDeveloper EF Core 6 version creates modelBuilder....UseTptMappingStrategy(); which not supported by .NET 6
If I remove the code line, is it possible that EF Core does not work correctly?
Next Page