Learn Practical Design Skills at Sevenmentor UI UX Classes in Pune
Learning UI/UX design is an excellent step for individuals who want to build a creative career in the digital world. Websites, mobile applications, and online platforms need attractive interfaces and smooth user experiences to meet people's expectations.
Delphi 13 / IBDAC 11.0.1 - Dynamic SQL Error -804 Function unknown RTRIM with TIBTable
Environment: Delphi 13 IBDAC 11.0.1 InterBase 2020 Issue: When attempting to fetch data using components like TIBTable in InterBase 2020, I encounter the following error. This issue did not occur in Delphi 12. Have there been any changes? Dynamic SQL
Getting OLE DB details in UniDAC
Hi I use UniDAC for accessing SQL Server data, though I note there is also SDAC. I have recently been getting the occasional exception with message: "OLE DB error occurred. Code 80040E21h". This is difficult to repro so I am trying to get as much information
Unable to set State or Status for D365 Sales Opportunity
When we are updating an opportunity, it won't allow us to set the status and state. With an INSERT the statement fails if I set the state/status to anything but Open/In Progress. UPDATE u SET u.statecode = 'Lost', StatusCode = 'Out-Sold' from OPENQUERY(D365DEV,'SELECT
Memory leak in TUniConnection and TInterbaseUniProvider
Hi all, I'm using Delphi 13.1 Enterprise and UniDAC 12.0.1. When I close my app, I get a memory leak warning (see attachment). The issue is easy to reproduce: File - New - Windows VCL Application Place the TUniConnection and TInterbaseUniProvider components
Devart.Data.MySql.MySqlException: License not found.
Hi Im getting this error on my new desktop PC, which is being configured like my current laptop PC. Both windows 11. Everything working on the laptop. Check out the code, build, run - everything works on the laptop, but not on the desktop. Im using the
Delphi 13.2/Unidac 12.1/ SSL Postgres
Hi, With last version of unidac 12.1 on delphi 13.2 I have an error when trying to connect to postgres in ssl mode, the error message is : The certifiicate subject name is not complies the server DNS name. I use the last securebridge, and the connection
Oracle Problem upgrading to NET10/EF10 with queries using contains.
Hi, after upgrading to the latest version simple queries with contains no longer work for me. I'm using an - Oracle 19c database patched to 19.26.0.0 and - EF 10.0.4 - Devart.Data.Oracle.EFCore 11.1.35.10 and 11.1.33.10 (both verified not working for
unidac and rad 13.2
Hello, Does the latest version of UniDAC officially support RAD Studio 13.2? I’m currently using UniDAC with Delphi and would like to upgrade to RAD Studio 13.2. Before upgrading, I’d like to confirm whether UniDAC is fully compatible with Delphi 13.2.
SQLite Direct Mode library for Linux THREADSAFE=0
I tested the trial version of the latest UniDAC and noticed that the SQLite Direct Mode library for Linux is compiled with: THREADSAFE=0 MUTEX_OMIT sqlite3_threadsafe() also returns 0. At the same time, the Windows SQLite libraries are compiled with THREADSAFE=1.
PgDAC/PostgreSQL connection for PostgreSQL 18, requires SNI
Hi, Trying to connect to a cloud PostgreSQL connection, with PgDAC 9, I got an error saying "No SNI Information found". I found this: https://support.devart.com/portal/en/community/topic/connecting-to-a-postgresql-database-using-ssl-when-the-server-requires-sni
License key in connection string
we have a purchased license of dotconnect for postgresql. today i installed the new version (9.0.0.0) and tried it with a .net framework 4.7.1 project. i tried the deployment and realized that i have to use the activation key in the licencse key field
ef core + unsigned data types mapping
I see on Entity Framework Data Type Mapping that unsigned int maps to an 64 bit integer on dotnet / ef core. Is there a way to hook into where that mapping happens or have changes otherwise to map to a 32 bit unsigned int instead?
Can you please code sign the SDAC BPL files?
Hi, Can the SADC BPL files be code signed? Examples: dac370.bpl sdac370.bpl tdstream370.bpl Thanks Stuart
Devart.Data.Oracle.EFCore v11.1.100.10 broken: ORA-01036: illegal variable name/number
Trivial insert causes ORA-01036: illegal variable name/number. Database used: Oracle 19c. Repro: Clean dotnet 10 project. Install just Devart.Data.Oracle.EFCore v11.1.100.10, no other package. Configure DbSet for public class Example { public int Id {get;
TUniDump
Hi, With TuniDump in restore mode with a dump I have some message at the end like field in primay key the end of the dump is like : DROP INDEX IF EXISTS idx_l_type_locpt_categorie; CREATE INDEX idx_l_type_locpt_categorie ON public.l_type_locpt USING btree
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
TUniScript
Hi, Is it possible to pass parameter to TUniScript like TUniQuery ? And Is there an option on large query on TUniScript to have progress information. Regards
Float field encode error when saving to Oracle DB with instant client 21.8
Hi, I have an very strange issue with a software compiled on Delphi 2010 using Unidac v3.70.0.17, this software is (mostly) on maintenance only mode and is being stable for many year. After the system administrator of this customer changed the Oracle
FloatAsSingle default True value
I am currently working with your components (Devart dbExpress 6.4.0 - Delphi 2010) and noticed that the property FloatAsSingle is set to True by default. I have questions regarding this: What is the reasoning behind having this set to True by default?
MS Access crashes when trying to "link" google sheet through 64 bit ODBC connector.
In the 64bit ODBC admin app, I have logged into the google sheet, created the token, tested the link "all good". In Access I try to establish a "new" data source via the DevArt ODBC Google Sheets connector. When I select, Access crashes. Any thought
Intermittent error "Unknown prepared statement handler (14) given to mysql_stmt_precheck"
Product version: dotConnect for MySQL Professional 10.1.35 OS Version and Bitness: Windows 10, Windows Server 2012 R2 and Windows Server 2022. All x64. Project Type: Winforms app (.NET Framework 4.8) Please describe the issue: We are facing intermittent
SSL connection
Hi, Finally it works with TC.ProviderName := 'PostgreSQL'; TC.UserName := UserName.Text; TC.Password := Password.Text; TC.server := Server.Text; TC.Database := Database.Text; TC.port := Port.ValueAsInt; TC.SpecificOptions.Values['ApplicationName'] :=
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
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.
EF Core 10 for MySQL dotConnect exact support state
Hello, I'm trying to migrate to .NET10 and EF Core 10 an application. According to the website the connector supports both .NET 10 and EF Core 10. The current latest NuGet dependency also shows package requirements for EF Core 10 But running queries actually
Problem with Devart.Data.PostgreSql.EFCore 9.1.33.10
Hello, i just started to upgrade an application to net10 and i get following error: System.TypeLoadException: Method 'VisitRightJoin' in type 'System.Data.Common.CommandTrees.PgSqlExpressionCloner' from assembly 'Devart.Data.PostgreSql.Entity.EFCore,
EF Core 10 support (Oracle)
It's been some time since dotnet 10 release. When can we expect version of Devart.Data.Oracle.EFCore that supports EF Core 10 ?
Missing parentheses in a where clause with EF Core and IsNullOrWhiteSpace
Hi, With EF Core I have a parentheses issue with this kind of code : _context.MyModels.Where(m => string.IsNullOrWhiteSpace(m.Name) && m.Id > 1) When using IsNullOrWhiteSpace, the generated SQL does not encapsulate correctly with parentheses, which looks
Devart Oracle EF Core: NullReferenceException in paging pipeline for join with filtered subquery (EF Core 9.0.11)
## Environment - OS: Windows 10 x64 (10.0.26200) - .NET SDK: 9.0.310 - EF Core: 9.0.11 - Devart.Data.Oracle.EFCore: 11.0.0.9 - Provider: Devart dotConnect for Oracle ## Database Oracle database with existing tables: - Items (Id, OwnerId) - Itemsub (Id,
dotConnect for postgresql 8.0 not compatible with NetTopologySuite?
I used dotConnect version 7.17 with NetTopologySuite 1.14 + GeoAPI 1.7.4. I update dotConnect to version 8.0. Now I can't run my application: When I compile I have the warning warning MSB3277: détection de conflits non résolus entre différentes versions
SSIS Data Flow Components for MySQL and MariaDB Install err
An error occurs when attempting to install the current version of SSIS Data Flow Components for MySQL and MariaDB (version SSIS Data Flow Components for MySQL v.4.0.0). (Runtime error (at 239:515): Type Mismatch. The error occurs on all systems (more
Managing UniDAC Connections for Multi-Threaded Fetch & Transactional Updates
Could you please tell me how to use UniDAC? I'd like to use separate connections in threads for data retrieval (Select). For saving data, I want to update multiple datasets within a single transaction. Previously, I used TClientDataSet and switched its
Postgres SSL connect
I need to add on option to connection postgres with ssl I add this options : TC.SpecificOptions.Values['SSLMode'] := 'smRequire'; TC.SpecificOptions.Values['SSLCert'] := Certificatclient.Text; TC.SpecificOptions.Values['SSLKey'] := Clefprive.Text; TC.SpecificOptions.Values['SSLCACert']
EF Core 10 support (MySQL/MariaDB)
.NET 10 has been available for a long time now (currently 10.0.3), but there is still no Devart.Data.MySql.EFCore version available that supports .NET Core 10. The latest version only supports versions 8 and 9. When can we expect support for .NET 10?
Virtual Query and Blob
Hi, With last version of Unidac 11.0.1 and delphi 13 (september and october patch installed), i've this error when adding blob in virtualquery : Le projet MSat5.exe a déclenché la classe d'exception EAssertionFailed avec le message 'TBlob.Free RefCount
pgDac and Google AlloyDB
Hello configuration: pgdac 9.0 standard, delphi 11.2, database Google AlloyDB (Cloud Database & postgresql share same issue anyway) AlloyDB is configured for public ips and "require SSL"; connection from PgAdmin on dev machine ok. blank project, PgConnection
UniDAC and OpenSSL 3.x compatibility for MySQL SSL connections
Hello, I am using UniDAC 10.0.0 to connect to MySQL over SSL/TLS. Currently my application uses external OpenSSL libraries libssl-1_1.dll / libcrypto-1_1.dll (OpenSSL 1.1.1w). Since OpenSSL 1.1.1 is EOL, I would ask. Does UniDAC 11.x support OpenSSL 3.x
Direct Mode is not supperted with DBF file connection
if set Direct Mode=False,get error. older version uniDac work well on delphi 11.
IBDAC Connection
Firebird 3/ IBDAC 7 Hello, i have a small client server network (2 pc's) . On the Client PC my connection ini file is : Data Source=192.168.1.10 Port=3050 DataBase=192.168.1.10:eOlive <-----Alias on Database.conf Client Library=C:\Windows\System32\FBCLIENT.DLL
Next Page