Query taking much longer in Direct Mode than when using an Oracle client
Hello, Our product gives the user a choice of using either Direct Mode or using an Oracle client. A customer has reported that when using Direct Mode, a particular query is taking 17 minutes, and when using an Oracle client, it takes only 18 seconds.
ODAC Oracle RAC SCAN direct mode support.
Hello, I was curious of Oracle SCAN name is supported with ODAC and using direct mode. We have an application we are trying to connect to an Oracle cluster using SCAN and it works fine with the Oracle client but not using the SCAN name with direct mode.
Connecting Postgresql with certificate
Hello We need to connect to the Postgresql database with a digital certificate, how do we do it?
UniDac ilink32 warning
Hello. RAD 10.4.2 / Unidac 9.4.0 / Windows 10 Pro version 22H2 I am getting the warning below: [ilink32 Warning] Warning: Duplicate string: ID 102; File C:\PROGRAM FILES (X86)\DEVART\UNIDAC FOR RAD STUDIO 10.4\LIB\WIN32\DBACCESS.RES string kept: "Password";
Parameter.AsString for an integer field results in a "record not found" error
Hi, With Delphi 5 + V6.11.23 of SDAC components + request : select * from TABLE where KEYFIELD = :Key + ParamByName('Key').AsString := '123' with Key integer field evrything works fine with SQL Server 2016 with SQL Server 2008 (or 2012, not sure), error
Query - ParamByName
Hello. RAD 11.3 / Unidac 9.4.0 / Windows 10 Pro version 22H2 I have problem with ParamByName in Query component. Field in Table is defined as CHAR(1) SQL: Select * from <table> where <field> LIKE '%A%' If the code is Q.SQL.Add('SELECT * from <table> where
Closing UniDac VERY slow
I have been using UniDac for years, currently in Delphi XE10.3.2 with Firebird 3 and for one particular UniDac query I have come up with a (to me) strange problem. It is taking about 8 seconds to close. The query is fairly simple (basically just a SELECT
type mismatch for field ‘xxx’ expecting string actual widestring
Hi all, I'm using SDAC 10.3 on Delphi 11.3: I got the above mentioned type mismatch, as I had created my SQL tables with NVarChar, and had persistent fields in my MSTables on the form. I found a description for the problem and a solution on this forum,
How and where do I set UseUnicode in sdac 10.3
Hi All, I have asked this question in a previous topic, but with another angle and more complex description. The simple question is: How and where do I set UseUnicode to False. I'm using SDAC 10.3 in Delphi 11.3 Regards Soren
Automatic choice of provider
Hello, We're wondering about the algorithm that chooses the provider to use to connect to a SQL Server instance when the Provider property is set to prAuto. According to the documentation (and the UniDac's source code), the Native Client is prefered over
NTDLL.DLL error when calling mstable.open, from an inherited form
Hi All, Using SDAC 10.3 and Delphi 11.3: I have a form, with 2 MsTable, which it has inherited from a standard form. On the standard, the Connection is pointing to a DB module with the MSConnection, but no tablename. In the inherited form, I set the tablename
Error during Installation of TCRSSLIOHandler for macOs
Hi, Delphi 11.2 / Windows 11 64bit I installed MyDac 11.3.0 and SecureBridge 10.3.1 with success for macOS and Win32 platforms. I'm trying to install the TCRSSH[L]IOHandler from ...\Documents\Devart\MyDAC for RAD Studio 11\Demos\TechnologySpecific\SecureBridge.
UniDAC object was open
I am migrating a project from Delphi XE with UniDAC 4.5.10 to Delphi Alexandria with UniDAC 9.2.1 and I am getting a few errors on Query.Open. These are the errors and I don’t have them in the old project. 1. illegal constraint expression 2. object was
Cannot connect to SQLServer in os authentication mode
Hello! Delphi 11.3 Pro. This is my connection configuration: object UniConnection1: TUniConnection ProviderName = 'SQL Server' Port = 1433 SpecificOptions.Strings = ( 'SQL Server.Authentication=auWindows') Server = 'DESKTOP-4J9A9E5' LoginPrompt = False
Unidac UniQuery clone access violation
When I use a TUniQuery and perform a CloneCursor using postgres, If I pass "True" as the reset parameter, an access violation error occurs. Attached are the database and the demo file as an example.
Export DataSet To JSON
Tell me, is it possible to export the dataset to JSON format? If not, is there a plan to do so?
Ongoing problems with TIMESTAMP datatype
Hello, This problem with timestamps in the TZR format still exists in the latest version. https://forums.devart.com/viewtopic.php?t=36016 Similarly, I have had this request for years (the ability to configure time stamp format) https://forums.devart.com/viewtopic.php?f=5&t=44301&p=178343&hilit=tzr#p178343
Heterogeneous queries
Hello, Does it exists a way to do Heterogeneous queries, off course on Firebird Dabases + TMemDataSet (= really powerful), like it is possible to do it with Firedac ? https://docwiki.embarcadero.com/RADStudio/Rio/en/Local_SQL_(FireDAC)
BLOB With VirutalQuery Oracle
Hi, I need to use VitrualQuery to transfert Tables, table with clob et blob, but if I done the folowing code. With Postgres at the end Table2.Memo is filled by with Oracle is Empty. If I execute 'INSERT INTO TABLE2 SELECT * FROM TABLE1' in sqlplus it
Virtual table transfer to another
Hello, When I use the code below to transfer a table to another table, all fields with non-English names appear as question marks. What should I do to keep the field names as they are? Var MM : TMemoryStream; T1,T2 : TVirtualTable; Begin MM := TMemoryStream.Create;
Delphi 12 Beta
Hy, I just installed Delphi 12 und the new UniDAC Source. I solved most problems, but get these Compiler errors: [dcc32 Fehler] OLEDBAccessUni.pas(155): E2291 Implementierung der Interface-Methode ISequentialStream.Read fehlt [dcc32 Fehler] OLEDBAccessUni.pas(3646):
Bug UniScript
Attached is a demo project the event cannot continue even using procedure TForm.UniScript1Error(Sender: TObject; E: Exception; SQL: string; var Action: TErrorAction); begin Action := eaContinue; end; This Script can be executed by IBExpert by creating
MsSQL New transaction is not allowed because there are other threads running in the session
Dears, we are trying to move large project from Delphi 11.2 ADO to Delphi 11.3 UniDAC. We use Firebird and MsSQL. We use main DbConnection and separate DbConnections for specific actions. We open forms with main DbConnection and we often use SpecificOptions.Values[FETCH_ALL]
How to get the MySQL table structure
I am developing a MySQL database table structure synchronization function. The client will request the structure of the specified table on the server and receive it through the Json string. Then the client will compare whether the local table structure
How to setup dedicated server in ODAC direct mode
Hello, we have implemented the use of 'direct mode' in our applications with ODAC, which is very useful to us. However, we would like to know what the equivalent of 'Dedicated Server' TNS connection type would be in ODAC direct mode
Access Violation - in Delphi 11 UP3 - after installing UNIDAC 10.4
Hello, after installing the latest UNIDAC version I am getting Access Violations when I try to install other components. I also have those problems within the RAD Studio when I click e.g. into the project tree - after de-installing UNIDAC - problems are
c++ builder compile error after unidac upgrade
Using c++ builder xe10.3.2, vcl win32 bits app. After update from unidac 9.2.1 to unidac 9.4.0 I got a compile error in standard includes: [bcc32 Error] ws2tcpip.h(604): E2015 Ambiguity between 'std::size_t' and 'Litecalluni::size_t' Any idea why?
Firebird 5
Hi, I would like to prepare/test for Firebird 5.0. When is a driver expected +/- ? Kind regards, Filip
TSmartQuery SQLTYPE property sometimes 0 when in Direct Mode
Hello, When in Direct mode, and running certain SQL in a TSmartQuery, the SQLType value is zero. Some examples are: CREATE INDEX test_ind ON TEST_TBL (EMPNO); ALTER TABLE TEST_TBL ADD (ddd DATE); It works correctly for these statements: create table test_tbl
SQL Server Always On feature
Do SDAC components for Delphi support SQL Server Always On feature? The "FailoverPartner" property was added for mirroring, but I am not sure if it would work with Always On.
Alerter on Postgres
HI. We have set up an alerter in Postgres (15) on linux ubuntu 22.04. The alerter works when we listen in psql on the server, but placing the Unidac alerter on our server application doesnt seem to do anything. I have put log messages in both the onerror
ODAC (direct mode) non-blocking
I am having an issue with ODAC non-blocking queries. Expected result: The .open method returns immediately. Actual result: The .open method does not return until the SELECT has completed the non-data transfer part of query. In practical terms, that means
TVirtualQuery Float field loaded as memo
Hello, I have a DataModule that I use to do some calculations and eventually display a chart. I have a TTable component with 2 Float fields (Rate and PieceRate). I assign this table to a TVirtualTable (vtPools). There are other tables as well. Next I
Is there a bug in SDAC Component ?
Field of type Data is treated as a widestring when the application runs on a computer other than the computer on which SDAC is installed. each reference to a date field generates string to date conversion errors, ONLY on the computer where delphi (XE")
TCREncryptor support for more modern hash function
i was looking to use TCREncryptor with unidac and noticed that it only supports deprecated hash algorithms - MD5 and SHA-1. Are there any plans to support sha-2 (I.e SHA256) as well as hmac based algorithms in unidac soon ?
Configuring a stored procedure with return values
I am new to UniDAC and am trying to configure a TUniStoredProc for a stored procedure with return values. I have managed to do this in code using CreateProcCall(<procedure name>), but I would like to know how to do this by just configuring the component
I'd like to ask you to cancel my subscription
Hello. The automatic renewal was checked at the time of purchase last year, so the product that was not scheduled to be used this year was automatically paid. I'd like to cancel my subscription, can I know how?
Unidac 9.3.0, Delphi XE2 ver 16.04, Oracle EE with TDE, ORA-00600
Hello, I am using UniDac version 9.3.0 with Delphi XE2 Version 16.0.4504.48759 on an oracle database 19c Enterprise Edition with TDE configured. I have a table with two columns crypted. Here the script I've used: ALTER TABLE utenti MODIFY (USERNAME ENCRYPT
Cancel Subscription
I'd like to cancel my annual subscription for MySQL Database COmponents. Where can I do this?
Possible OraClasses bug?
Hi, During a test, I've had a range check error throw up in OraClasses.pas. It was in version 12.2, but I've just updated now to 12.3 and I think the problem is the newer version as well. I am currently unable to reproduce the error, but I think it had
Next Page