Unidac connect to Oracle with LOAD_BALANCE
Hi, it's the first time I have to connect to an Oracle server in a datacenter with Load_Balance feature; I have received this connection string: PROD_SIT_DB_PROD= (DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.148)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.149)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.150)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PDB.subset.vcnphx.oraclevcn.com)))
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
Findkey in Cloned DataSet work?
Hello, I would like to confirm a question. Does the FindKey method work on a cloned dataset? In my tests, it does not work. In the IBDAC documentation, a restriction is that the cloned dataset does not allow the use of filters. Is the fact that FindKey
dac290.bpl and pgdac290.bpl not compiled into exe
hello one and all, I'm getting back into Delphi, 12 right now, after last use with XE2. I started with 1 in 1995. anyway, I am evaluating PgDAV for direct connection into psql. when I copy and run the exe unto a native win11 machine and run it, the message
MyDAC MyConnection ignores Password
In various circumstances, the TMyConnection "Password" field doesn't seem to work properly. 1. In the Delphi Object Inspector, right after I enter a password into the Password field, if I then set Connected to True, a connect dialog pops up with the Password
LOOKING FOR FAKE COUNTERFEIT MONEY?(WHATSAPP.+35796370243)
WhatsApp.+35796370243 Telegram.@tesgkm We offer good Quality GBP Bills Online, Counterfeit Money Online which you are Look for the perfect way to get quality backnotes without risking yourself? Look no more further! Buy GBP online from a trusted source
¿DÓNDE COMPRAR DIVISAS FALSAS? (WHATSAPP +35796370243)
WhatsApp.+35796370243 Email.jackwoody962@gmail.com Telegram.@tesgkm quality backnotes for sale, Buy counterfeit banknotes Online that look like real money, the banknotes has been checked and the quality is good, We do Face to Face meeting With our counterfeit
SUCHEN SIE FALSCHGELD? (WHATSAPP.+35796370243)
WhatsApp: +35796370243 Telegram: @tesgkm Wir bieten hochwertige GBP-Banknoten und Falschgeld online an. Suchen Sie nach der perfekten Möglichkeit, hochwertige Banknoten zu erhalten, ohne sich selbst zu gefährden? Dann sind Sie hier richtig! Kaufen Sie
invalid bytes count error - DotConnect for Oracle
Hi, we moved from Oracle 12c to 19c and upgraded Devart.Data.Oracle to 10.0.0.0 and to Devaty.Data.Oracle EntirtE6 and we getting that error invalid bytes count right at the start up, during getting user profiles from database. What can be a reason for
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
Passing parameters to TUniStoredProc without SELECT privilege
Hello. I have MySQL database with some of the stored procedures for accessing data in it. The only global privilege enabled is EXECUTE, others are disabled. I'm trying to call a stored procedure in MySQL database with the help of TUniStoredProc using
Update SQLite Direct ?
Hello, Any ideas why you don't update the SQLite direct to the latest version ? Thank you
How to get entire BLOB content with dbExpress
I have a Firebird 3.x database with UTF8 characters, connected with Devart dbExpress from a Delphi Intraweb program and cannot get it to display more than one character of a BLOB memo field. Presumably I need to set something different when connecting
.NET 9 - Devart.Data.Oracle.EfCore - NullReferenceException
Hi, On EFCore 9, with today driver v10.4.191.9, many operators are failing with this error : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression.PushdownIntoSubqueryInternal(Boolean
MyDAC and SDAC question
I am trying to retrieve data from MS SQL Server (about 40000 records) and copy them to TDictionary as fast as possible. My problem is that it is slow and some setting changes give strange results. What I do is: 1. I open TMSQuery object MSQArt, it takes
IGGM - Is Diablo 4 Season 8 Really An Exciting Boss Challenge?
On March 11, the game developer released the PTR of Diablo 4 Season 8. After a week of experience, players have different opinions on the content of the new season. Diablo 4 Season 8: Belial's Return is speculated to be officially released at the end
POECurrency - What Surprises Will PoE 2 Patch 0.2.0 Bring Us?
The trailer for PoE 2 Patch 0.2.0 has been released. The female character running in the forest with a spear has aroused many players' expectations for this update. The official release date is not far away. Perhaps players can get a glimpse of more from
MyDAC Bug 12.4.0
I just switched to the new release and re-compiled my projects. Now I get this error, when I start my program: assertion failure "d:\jenkins\workspace\DAC\MyDAC\Delphi\Dac\Common\Source\CRVioTcpSSL.pas"
Python xbase connector Trial period has expired in the running computer
Hello, I am using the devart_xbase_connector-1.2.0-cp312-cp312-win_amd64 activated in my development computer (Laptop) and it works normally. I have created a utility program that does various things in a fox-pro database which I run on my other PC (Desktop)
Unitable isindex and lookup do not work
Hello, i am using a UniDac UniTable to access a SQL server database. To view the structure of the table i need to know which fields are index fields and which ones are lookup connections. The tunitable has two properties which should give this information:
UniDAC 10.3.2 - Returning - Firebird 4 / Firebird 5
With 10.1.0 “Added support for multiple rows being returned by DML with the RETURNING clause” was introduced. I have now noticed that in a query with returning with Firebird 4 the returning is in the params (fields empty) and with Firebird 5 in the fields
UniDAC 10.4 Source Installation
Hi, I am trying to use Make.bat using Make.bat Delphi WIN32 but get the error: Embarcadero Delphi for Win32 compiler version 36.0 Copyright (c) 1983,2025 Embarcadero Technologies, Inc. odbcprovider290.dpk(28) Fatal: E2225 Never-build package 'rtl' must
Prevent ODAC from appearing in Delphi main menu
Hello, After I install ODAC components into Delphi, "ODAC" is inserted into Delphi's main menu. Is there a way to prevent (or remove) this? Thanks John Dorlon
Delphi 12.3 64bit-IDE support
Hi when can we expect the design-time controls for the 64bit IDE of Delphi 12.3 for the Delphi Data components ? Kind regards, Erik
'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.
[PgDAC] Error when executing SQL Query in table with blob files
Hi there, hope you'll ok. I recently started using PgDAC for queries that works with blob files, especially using the "execute" command of PostgreSQL (version 16). When i execute the query, i'm getting the following error: "ERROR: Assertion failure (D:\Jenkins\workspace\DAC\PgDAC\Delphi\Dac\PostgreSql\Source\PgSQLProtocol.pas,
New BOOLEAN datatype not supported with Oracle 23ai client
Hello, I am using the latest version of ODAC and Delphi. When I connect to an Oracle 23ai database, using an Oracle 23ai client, and I select (using TSmartQuery) from a table that has a column of datatype BOOLEAN (for example: Select * from user_domain_cols),
Sqlite support to Microsoft Visual Studio Community 2022 (ARM 64-bit)
I'm using Microsoft Visual Studio Community 2022 om a macbook pro M4. Everything work just fine except dotConnect for SQlite. Using latest version 6.4.190 Getting error when try to open SQLiteConnection in debug mode. Application is running fine standalone.
TScSMTPClient for dummies
Hi, I am playing a little around with ScSMTPClient and was able to send mails. I am currently failing to get/receive an errror when using an non existing adress no matter wether used as a from or to address. Am I right that this is probably related to
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?
.NET 9 - Devart.Data.Oracle.EfCore - Discriminator issue with include
Hello Devart, When using discriminators in EF Core and then including navigational properties which aren't available on all discriminated types, only on specific derived types: var result = await ctx.Vehicles .Include(_ => ((Car)_).PossibleEngineTypes)
.NET9 Ef Core 9.0.1+ Object reference not set to an instance of an object.
Hi, I'm getting Object reference not set to an instance of an object. from Microsoft.EntityFrameworkCore.Relational at pretty much each query. For example: await context.TV_USERS.AsNoTracking().Where(x => x.ID == Id).FirstOrDefaultAsync(ct); I'm using
SecureBridge Installer won't let me uncheck any components
Hello, I want to uncheck the following in the SecureBridge installer, but the boxes don't respond when I uncheck them. SecureBridge files for Win64 (Modern) SecureBridge files for macOS SecureBridge files for Android It's not a big deal, just annoying.
DateTimeOffset.Date does not correctly truncate time in dotConnect for PostgreSQL
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. We have been using multiple methods from the DbFunctions class, many of which were removed in EF Core. From my understanding, DateTimeOffset.Date
SDAC older versions download
Hello, Where can I download older versions of SDAC? I have UniDAC installed on our developer machine and it says I need very specific version of SDAC, not any two versions are compatible. So, I need to try SDAC on Delphi 11 Alexandria, specifically version
C++ Builder error: E2015 Ambiguity between 'Crjson::TJSONObject' and 'System::Json::TJSONObject'
I just moved one of my C++ Builder projects to RAD Studio 12.2 and UniDAC 10.3.2. I am getting the above error plus E2015 Ambiguity between 'Crjson::TJSONArray' and 'System::Json::TJSONArray'. I am only using TJSONObject and TJSONArray in this project,
dotConnect for MySQL parses sbyte incorrectly
Hello, I've recently bought dotConnect for MySQL and this is the first problem. All versions are current, .NET 8 with EF Core 9 and Devart's 9.4.191.9 My database has some columns that are tinyint in MySQL, which has the range -128...127. dotConnect's
How to specify Time Zone format
Hello, It looks like there is now a way to specify time zone format in ODAC. How can I specify it in my code, if I want timestamps in query results (like a TSmartQuery attached to a grid) to always have a specific format. I want to use TZR, to solve the
SQLite low-level
i want to understand - can i use unidac/litedac in low-level mode? without connections, datasets and so on. as i see - a can use LiteStaticUni module. and, may be, some thing else. is there are some description or manuals for it?
TUniQuery fails with Parameterized UpdateSQL while updating data in AWS to Bablefish for Aurora PostgresSQL
Hi We have been using your wonderful library of UniDAC components (for SQL Server) for several years now and currently use version 10.1.0 professional version for Delphi 12. Currently we were evaluating to move our database to AWS through Bablefish implementation
Next Page