Recent Topics
BUG UniDAC v10 : @@rowcount is incorrect
Hi, - Delphi 11.3 - UniDAC v10.0.0 - MS SQL 2022 "select @@rowcount" is incorrect with update, insert and delete. no problem with UniDAC v9.3.0 Update of 44811 rows : Deleting a row that does not exist : Thank you in advance Regards
**WARNING**: DO NOT INSTALL version 10.0.46 - usability is dead!
hi there, you might have seen the latest update with tons of changes and maybe, like me, you were super happy in the first place to realize, that the team did a great job fixing so many bugs and adding new features. but after using the new version for
Issue on Fresh installation of ADO.NET Data Providers whit VS 2022 x64 and win 11
Hi on first trial installation of ADO.NET Data Providers I have this issue when try to add on VS 2022 windows form a devart Uniconnection : Is it because it uses x86 references? Tks for any info....
UniDac - Hide SQL oracle from Sqlmonitor Applications
I Need to Block access SQL Scripts from External Applications like SQL Monitor or Other. It can do using Direct Access function from UniDac, bud its is more bureaucratic. There are some form to do this accessing with HostName from TNSName?
Unhandled exception. System.ArgumentNullException: Value cannot be null. (Parameter 'expr')
Hi Devart team, I am facing an issue in my .NET 7 application connecting to an Oracle Database using Devart.Data.Oracle.EF library. When I try to query the parent table that is configured using table-per-type (TPT) I got the next error: Unhandled exception.
Entity Framework Core 8 (EF8) / .NET 8.x support
I am wondering when .Net 8 support will be released for Entity Developer? Do we have an ETA on that yet?
Feature Request
Hello, before we started using UniDAC we have used the Direct Oracle Access components (DOA) from AllroundAutomations. The dataset of DOA has a nice feature regarding CachedUpdates. Before it applies any changes to the database in ApplyUpdates, it reads
AlwaysOn configuration
Which options are required to make UniDAC work properly with AlwaysOn SQL Server? If I'm correct options related to AON are: -Provider (should be set prNativeClient) -FailoverPartner, -MultiSubnetFailover We are running UniDAC (version 9.1.1) and our
scFTPClient: Active-Connection ListDir -> ErroNo.: 530 ..Please login with USER and PASS
SBridge Version 10.3.1 Following scFTPClient-properties are defined: Hostname, Username, Password, UsePassive true/false (makes no difference) TLSMode = tmDisableTLS Connect Active = true when calling ListDir, the error occurs. What's wrong. I can't find
How to add DefaultValue attribute
Hi, I am using Entity Developer 7.2.10, in DB First on EF Core 7 and Data Annotations for Validation Framework. I want to add the standard attribute: [DefaultValue(false)] to a boolean field, but this is not available in the properties at all. I am aware
BiDirectionalSync
we are using two databases in which one is source database (central database) and the other is destination database (store database). And we are preforming bidirectional sync between central and store database, the problem occurred where the data existed
Multiple DbContext in one transaction in NET6 Devart.Data.Oracle.EFCore 10.2.0.7
Hi, When trying to use multiple dbContexts in one transaction I get the following error when setting the transaction: dbContext.Database.UseTransaction(transaction) System.InvalidOperationException: 'The specified transaction is not associated with the
EF Core 8 / .Net 8 support
Hello, Do you have any roadmap or release date about supporting EF Core 8 ? Currently it's not possible to run a project with Devart.Data.Mysql (9.1.151.7) and EF Core 8.0. Thank you.
Support .NET 8
Hi With the release of the LTS .NET 8 version, is there a plan for support for .NET 8 dotConnect Universal? https://learn.microsoft.com/en-us/dotnet/core/whats-new/dotnet-8
dotConnect Oracle Entity Framework 8 and Oracle Database 11/12
There is already a question about the release of dotConnect Universal. This question is about dotConnect Oracle. Do you already have a release date planned? As Oracle dropped support for Database 11/12 in their EF 8 driver. Will your EF 8 driver keep
License issue
Hey, I'm having an LinqConnect professional license with expiration date 13th october 2022. Today I tried with the included version 5 using LinqConnect with PostgreSQL and it raised an LicenseException. So the question is, what happend ? As I can see
ODAC Direct Mode Bug: Selecting RAW columns through DB Link causes Access Violation
Hello, Using ODAC version 12.3.0 and Delphi 11.3 Using ODAC with DIRECT=TRUE TSmartQuery has Options.RawAsString=TRUE I have a table like this: CREATE TABLE HAS_RAW (RAW_COL RAW(30)); Insert into HAS_RAW (RAW_COL) Values ('43'); Insert into HAS_RAW (RAW_COL)
How to use TMyConnectionOptions with TMyConnection to set protocol to IPv4 (or IPv6)?
I'm using MySQL Data Access Components, standard edition, version 10.3.2 for Rad Studio 2009 (I'm also using the SSH components to get an encrypted connection) The docs here https://docs.devart.com/mydac/devart.mydac.tmyconnectionoptions.ipversion.htm
IP protocol used by MyDac TMyconnection changes from IPv4 to IPv6 (or vice versa) and database queries fail
Scenario My application obtains the public IP address of the user by running a small PHP script on the same server that hosts my database. I then programatically insert that IP address into the remote hosts table so that I can gain remote access to the
Firebird 5 released
Firebird 5 was released 2024-01-12. Now, when do we get an IBDAC update? ODS is compatible to FB4, but there are new SQLs, like partial indexes and "SKIP LOCKED". There are new backup options for parallel workers, which may be configured in TIBCBack
InvalidCastException with value types and logging applied to the DbContext
Hi, We are using Microsoft.EntityFrameworkCore 7.0.15 and Devart.Data.Oracle.EFCore 10.2.0.7. Some of our queries use value types in the where clause but don't work when we enable logging for the DbContext. I have a attached a small project which reproduces
C++ Builder 2010 Unable to connect to database
Hello, We are using C++ Builder 2010, Firebird 2.5.9 we are having some problems with mult-thread access with our current Firebird Driver (other driver) We are interested in testing you driver but we receive a strange exception after the trial info dialog
Issue when comparing temporal table dbForge Schema Compare
Hello, I encounter an issue while comparing GIT branch VS SQL Server database especially with temporal table alter on dbForge Schema Compare while "Synchronize" action. I unchecked both "Ignore history table" and "Ignore history table name" options and
Remotely connect to xBase ODBC driver from an external service
Hi, I'm wanting to connect an ETL (Azure Data Factory) to a FoxPro database on an on-premise server. I see that some of your ODBC drivers provide connection options like port etc, but the xBase one doesn't. Does that mean that there's no way to connect
Compiler Issues with LiteDAC Component
In my C++ Builder XE 11.2 project, I placed a LiteConnection component and attempted to compile an APK for Android 32-bit. During the compilation process, an error occurred: [bccaarm Fatal Error] DBAccess.hpp(17): 'Winapi.Windows.hpp' file not found.
Error No Entity Framework Provider found for Devart.Data.SQLite
Hi! I maintain a .NET Framework 4.8 app that uses DevArt DotConnect for SQLite. It uses Entity Framework to talk to a database where application logs are stored. Anyway, starting about a year ago something changed in the app's config that's causing an
Devart.Data.Oracle.OracleException : ORA-00920: invalid relational operator
Hi Devart team, I am getting the error Devart.Data.Oracle.OracleException : ORA-00920: invalid relational operator when querying the database using a bool property in a where clause like: var students = _dbContext.Students.Where(s => s.IsActive).ToList();
SQL Complete Snippets - How to insert the text on your clipboard?
In other tools I've used similar to SQL Complete there's always been a placeholder that would insert what you have copied into the snippet. For instance if I copied the text "Table1" and used this snippet SELECT TOP 100 * FROM #Clipboard# I would get
debug is not working
after purchasing license debug is not working in sql 19
ScSignalRHubConnection
Hello, I wonder if the unit ScSignalRHubConnection supports the ASP.NET Core SignalR protocol for connecting to the server. Thank you and Best Regards Boris
ODAC TOraQuery cannot popup window to enter SQL query
My environment is: Delphi 10.2 and C++Builder 10.2 Update 3 Devart Oracle Data Access Components 11.1.3 While I add a TOraquery to a form, and then in Object Inspector I click on SQL trying to bring up the editor window. Delphi dies. What I can do is
Built-in dbExpress Driver problem
I use dbExpress Driver for InterBase and Firebird 6.1 Source code. and Delphi XE use DbxIdaDriverLoader and compile An error occurred [DCC Error] IBCError.pas(29): E2003 Undeclared identifier: 'ECRError' in unit IBCError; How to resolve it? thanks!
Why no active back button after a failed data import?
After an import fails for whatever reason in the Import Data option, the back button is always disabled. I can only click on the Finish button and it takes me out. This means I have to start all over again and repeat this workflow until there are no more
Importing fixed width flat file should default to the columns and their sizes in the destination table
I am trying to import a flat file with fixed width columns. I created beforehand a table to accept this data and defined the columns with sizes that match the field size to be imported, in the import wizard I had to manually define all the positions and
dotConnect MySQL Info
2 questions with the dotConnect for MySqL 1) does dotConnect for sql work with the square brackets in mySQL? The devArt MySQL Odbc driver handles the square brackets but it looks like the [] are throwing an error? Example select * from [Company] 2) using
dbExpress very slow on one computer
Hi All, Normally I have no problem with the speed of the dbExpress drivers. But I have one customer where the connection to the database (MSSQL) is very slow (more than 10 times slower than others). He has the same setup as others, so I cannot pin point
Migratig from FibPlus
Hi I have a FibDataSet with CachedUpdate activated. and this code: Trans := Consulta.Transaction; Trans.Active := true; Consulta.Open; Trans.Active := false; when I close the transaction, the DataSet state is dsBrowse and all the data are still in DataSet.
Multiple dataset problem
Hi, I use TMSStoredProc and SP has multiple datasets. Besides, SP has some business logic and use Cursor to handle the logic. I tested to insert the records into physical table instead of #temptable in SP. I found it doesn’t insert any records into physical
How to move to a new computer?
I need to move the QuickBooks ODBC driver to a new computer. What is the process to do that?
SQL Complete - Can the code snippet auto-complete function be customized with a key other than 'Tab'?
Dear Devart, Hello. I am a user who is considering using sql complete this time. I asked you a question about using Code snippet in SQL Complete. As a result of checking the manual, it is confirmed that the snippet is automatically completed if you enter
Next Page