Linq Connect Update Timeline
Is there a timeline for an update to LinqConnect 5.-0.151 to support the recent updates to visual studio? Thanks -Pete
On Mac M3 moving from Devart.Data.MySql.EFCore 9.3.21.8 to 9.4.290.9 causes AccessViolationException
Hi, We try to move from EF Core 8 to 9 but looks like on Mac M3 it crashes instantly when we update the Devart.Data.MySql.EFCore package. It throws this : Fatal error. System.AccessViolationException: Attempted to read or write protected memory. This
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
dotConnect for Oracle - Devart.Data.Oracle.OracleException - ORA-00933: SQL command not properly ended
Devart.Data.Oracle.OracleException (0x80004005): ORA-00933: SQL command not properly ended was raised when I use MaxBatchSize. Versions: - Devart.Data.Oracle.EFCore :10.4.235.8 - Devart.Data.Oracle :10.4.235 - EntityFrameworkCore: 8.0.13 Ex: optionsBuilder.UseOracle(_oracleSessionManager.GetOrCreateOracleConnection(),
A collection of enum array values get translated as (NULL, NULL ...)
Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database
dbexpress for Oracle and PostgreSQL different behaviour (probably bug in oracle one)
Hello Environment Delphi 11.2 Latest dbexpress drivers for Oracle and PostgreSQL PostgreSQL database: Insert sqlconnection, configure access, connected := Truee Insert SQLQuery, link to connection, edit SQL: "select * from TABLE where field = :P1" Confirm
Devart.Data.Oracle.EF6: Can it have .Net Framework support in Nuget?
Hello, I am currently updating our dotConnect for Oracle (DevArt.Data.Oracle) package to 10.3.10 in our .NET Framework 4.6.2 solution. I would also like to update Devart.Data.Oracle.EF6 to 10.3.10 but the dependencies in nuget requires .NET Standard 2.1:
Entity Developer and Composite Keys
Hello, Is there are way within Entity Developer, prior to code generation, to flag attributes, and remove the warnings e.g. Northwind db (image) so my generated code mappings won't have an issue. Thanks.
ODAC and Oracle Home
Hello... I am doing some test with ODAC ... for possible switch from dbexpress... I have Oracle 26ai FREE installed in my windows 11 machine I do see that OraSession does not populate "Home", and by consequence neither the Server names... If I try to
connection to cloud autonomous database in direct mode
Hello all, I know how to connect using OCI client to cloud oracle autonomous database, what I am asking is if there's a way to connect using dbxoda in direct mode... Is there some tutorial or blog post or whatever on this topic? in case dbexpress is unable
Unidac and PostgreSQL 18.1
Does latest Unidac 11.0.0 support PostgreSQL 18 (which was released in September) or the latest version 18.1 ?
TUniConnection feature request
Hello Please add TUniConnection.CommandTimeout specific option for SQL Server because ConnectionTimeout and CommandTimeout are not the same things. See MSClassesUni.pas, line 1246 It's need for Connection.ExecProc and Connection.ExecProcEx
How to retrieve the field structure in a dataset ?
I searched Google and couldn't find anything about it. I use "Unidac" and I'd like to know if anyone has created a function to return the SQL field structure. Example SQL SELECT
Case When (CC.FOTO is Not Null) Then 'Sim' Else Null End as FOTO
FROM CADASTRO_PESSOAS
SDAC 8.2.8 - stored procedure output parameter
I am using SDAC 8.2.8 with D 10.2 and have strange problem that I think might have already solved, however it is all strange, maybe someone will be able to explain what is going on. I have stored procedure in MS SQL Server: CREATE PROCEDURE [dbo].[AAAA]
Maximum Depth Of An Expression Tree in direct mode on TUniConnection
Hi, how I can increase Maximum Depth Of An Expression Tree value in direct mode on TUniConnection?
Oracle connection error - Invalid Bytes count
I am getting error when connecting to oracle. I have tried with .NET 6 and .NET 8 string connectionString = "" + "Server=myserver;" + "Port=1521;" + "User Id=myuserid;" + "Password=mypassword;" + "Service Name=myserver;" + "Direct=True;" + "License Key=mykey";
new UNIDAC (11.0) don't support Unicode? older version (9.3) done well.
new UNIDAC (11.0) don't support Unicode? older version (9.3) done well.
ODAC 13.4.1 different behaviour related to ODAC 9.0.1 related to persistent fields on Delphi 7 and Oracle 19.22
Hello, Recently we updated our libraries on an old but important project from ODAC 9.0.1 to ODAC 13.4.1 and we observed the following: After the update in case an OraQuery gets a persistent field having the size property holding a value less than the
Update Failed
Hi I upgraded to IBDAC 10.0.0 and now there is an error after inserting a record. (after the refresh) "Update Failed Found 0 records" Now I have downgraded to 9.3.0 and it works again. I have a TIBCQuery-Object with SQL: SELECT KDMANAG.*, (Select MINAME
Update from 9.5.15 for RAD Studio XE4 to most recently
Hello, I am currently using version 9.5.15 of your product with RAD Studio XE4. I would like to know if there are commercial options available to upgrade my license to a more recent version. Could you please provide details on the upgrade process, pricing,
MyDAC with Lazarus
I am currently using myDAC Professional 13 with Delphi 12.1 and would like to test with Lazarus. Just checking - I would need to upgrade to MyDAC Professional with Source Code? Are there any docs on how to install myDAC for Lazarus?
Firebird - RETURNING not working
Hello. I'm having problem in Firebird with RETURNING value with latest Unidac 10.1.0 on Delphi 11 update 3. Problem occurs when "same" query is used for SELECT and INSERT/UPDATE. I've attach db.txt with sample table T1 with three fields (ID,f1,f2). Here
Connecting to a PostgreSQL database using SSL when the server requires SNI
Hello, We have a problem connecting to a certain cloud PostgreSQL database using SSL, because the server requires a server name indicator (SNI). We tried the both connection ways described in the "Connection to PostgreSQL through SSL in Delphi" manual
RAD Studio 13 Florence
Hi, I was wondering when mysqldac delphi components would be available for RAD Studio 13 Florence?
dbExpress Driver for SQL Server support for TLS 1.3
Does dbExpress Driver for SQL Server supports TLS 1.3?
Strange Refresh Failed error message
Hello, I have a TOraQuery component, with a relatively simple select. It joins tables for the master table called ATB. select atb.rowid, atb.*, sby.c_nev1 c_belep_szintnev, bko.c_nev c_szervezetnev, saj.c_nev1 c_uzemkodnev, bkp.c_nev c_onelszamolonev,
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?
Devart.Data.Oracle.EFCore in Azure Web Apps
I have an open ticket for this but wanted to see if anyone else has been able to get EFCore to work with Oracle, dotnet9 in an Azure Web App. Using the line works locally but not in Azue. builder.Services.AddDbContext<TestOracleDbContext>(options => options.UseOracle(vcisDbConnection));
IBDAC - Firebird 5 and the Option: isc_wish_list
The release notes for Firebird 5.0.3 state the following on page 43: https://www.firebirdsql.org/file/documentation/release_notes/Firebird-5.0.3-ReleaseNotes.pdf Engine provider sets isc_wish_list error in status and returns zero, when appropriate. Remote
Invalid Typecast exception on Insert/Update blobs
Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++
I own UniDAC for SQLite dbs on Android, but should I be using LiteDAC?
I only access SQLite dbs, and only on Android. I've read that LiteDAC is possibly faster for accessing SQLite. But does it lack any features that UniDAC provides, insofar as working with SQLite dbs? If not, I will buy LitDAC as well. Thanks for your
The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.
I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created
Advice on which Unidac components to use in android app
I have a small personal android app which accesses a sqlite database with several tables. The app is single user, no db sharing. Only one table open at a time. Browse, add, edit, delete, search. I currently am trying out a TUniconnection, and a TUniQuery
Handling of NaN > DevArt Connection Exception
Hi, PostgreSQL DataAcess Components if there is "NaN" in a Numeric column (that is allowed per default by postgres). Devart will fail. The following easy example shows the problem, DevArt is unable to open this dataset. If there is one row in 1000000
Change order of ApplyUpdate
Hi Using CachedUpdate I need to have the delete statements to be fired before the inserts, is this possible? if not, i try to delete the deleted records before i can applyUpdates, but when i call apply after that i get error record to be deleted cant
DbForge studio for Oracle connection issue with proxy user
I have oracle DB that is installed on server and want to connect to it via proxy user but it's seems like the application can't connect to the DB even the same connection string is working fine on other application. Please note that I have no DBA privilege
dotConnect C# MySQL: Setting charset at global level?
I'm using the generated great TableAdapters in C#, where I had errors with my Hungarian strings (containing á, é letters) until I added any of these before opening the connection: this.Adapter.InsertCommand.Connection.Unicode = true; this.Adapter.InsertCommand.Connection.Charset
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
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?
Upgrading SSIS Data flow for Salesforce Issue with License
Hello, We are using the SSIS data flow component 1.7.x for salesforce. It has been working for years. Now we have migrated servers (SQL2014=>SQL2019) and when deploying the SSIS Package and scheduling it to run using SQL Server agent we get "Cannot find
Next Page