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),
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)))
ODAC - base class for BeforeOpen
Hi there. I'm trying to build an interposer class für TOraQuery. I couldn't find the correct base class, though. TOraQuery = class(Ora.TOraQuery) //TOraQuery = class(TMemDataSet) //TOraQuery = class(TCustomDADataSet) //TOraQuery = class(TOraDataset) //TOraQuery
#28000Access denied for user @localhost (using password: NO)
I have a large application where i : i have 14 datamodules. there's 1 main datamodule which contains the MyConnection component which is set at runtime and at design-time the connectionstring is empty every datamodule has a OnCreate event on all datamodules
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
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
MyDAC login problems
I am using MyDAC 12.4.0 with Delphi 10.2 Using MyConnection1 and Myconnection Dialog Anytime there is a login mistake, wrong password or user, the second attempt throws the flowing error: assertion failure "d:\jenkins\workspace\DAC\MyDAC\Delphi\Dac\Common\Source\CRVioTcpSSL.pas"
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
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
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
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"
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
[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,
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
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.
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,
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
Oracle Idle Time and Odac
I am running Odac 12.1.1 with Oracle as my database. In Oracle, the idle time is set to 1 min. SQLPlus disconnects perfectly after 1 min idle time. My frontend application however exactly disconnects after 3 min Why is that ? Anyone else seen such behaviour
VirtualQuery IsNULL
Hi, Is use a virutalQuery to show informations : 1. SELECT A.INT_COUT,A.MAT_ID,A.INT_DEB,A.INT_TECH,CAST(SUBSTR(A.INT_DESC,0,255) AS VARCHAR(255)) AS INT_DESC_T,CAST(SUBSTR(A.INT_ACT,0,255) AS VARCHAR(255)) AS INT_ACT_T,A.INT_FIN,A.INT_TYPE,(B.T_CIVILITE
SqLite Localized Order
Hi With Android Studio Java I can select a sqlite table like Select * From MyTable Order By Name Collate Localized The data returns ordered by with my language specific characters But there is no such an option with Delphi/Unidac I receive an exception
Batch move and creating destination table in Access
Hello! I'm experimenting so that we can move away from Paradox onto something a little bit more useful. For the time being, however, the "temporary fix" is Access. Let's not go into the why, how, etc. For now this is the best course of action. The access
ODAC local filter raises EVariantTypeCastError
We have tried to use a newer ODAC version in production. The following issue is a showstopper for us. It seems that this issue exists since version 12.3.0. Steps: - compile and execute the following command line application Expected: the output is PASS
ODAC: "Invalid Field Type" when calling a stored function with VARCHAR2 params
We have developed a VCL application in C++Builder, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. Our database is Oracle 19 running on an ODA with latest patches. The problem always occurs when I
EntityDAC developer on Oracle
Hello, I'm trying to use Entity Developer to generate model for my Oracle database. It seems that after model generation some table are not still present in the database. I'm using Entity Developer version 6.12.1354 trial. Thank you, Luca
opened connection by an exception
In the TCustomPgDataSet.Execute(PgAccess) becomes TCRConnection.FAutoCommit(CRAccess) set to false and not reset after the exception in the RefreshRecord. Then the error dialog, through our THauptForm.ShowServerTimer a ConnectionCheck with "Select true,"
Firbird 5.0 / Substring in IbcQuery.Filter
Hello devart team, Try to filter an IbcQuery (latest release) with firebird 5.0 : IbQuery1.Filtered :=False; IbQuery1.Filter := Substring( MyField from 1 for 5) = 'Hello' IbQuery1.Filtered :=True; This rise an error : "Substring is an unknown Field" (Something
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
DIRECT Mode fails with "Net: error 99" if a TYPE is modified between uses in a SELECT
Hello, Using the attached demo project with the latest version of ODAC and Delphi. You'll have to enter your own user/pass/server. The bug happens on any Oracle version. After connecting in direct mode, a script runs which does the following: 1) Creates
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?
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
Next Page