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
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?
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)
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;
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?
Как правильно работать c компонент Encryption Unidac Firebird3?
Добрый день Подскажите пожалуйста как правильно работать c компонент Encryption Unidac Firebird3? то что работал Ibdac перестал работать Unidac База Firebird 3 тип поля VARCHAR(2000) CHARACTER SET OCTETS COLLATE OCTETS В Ibdac работает но в Unidac после
IndexFieldNames
Hi, I need "natural sort" as a sorting algorithm to use with IndexFieldNames. For natural sort see: https://en.wikipedia.org/wiki/Natural_sort_order I have an article number field as varchar. Some of my customers have article numbers with mixed letters
Automatic Timestamp Macro
Hi, I found this topic and I think this is still a problem with UniDac: https://forums.devart.com/viewtopic.php?f=28&t=38112 When I use an SQL like ".... {timestamp '......'] ..." this works fine except for one client where I get an error: La conversion
How to translate SQLite messages
Hi, I use UniDAC to deal with SQLite databases. I use direct mode. If there is any error I use EUniError(E).ErrorCode but it is not detailed. (usually returns 1). E.Message holds detailed message in English. How to intercept to be able to get real error
Best practice to work with SQL Server transactions
Hello, what's the best way to perform a transaction with a TMSQuery? See the following source code: try LQuery := LDatenHandler.GetQuery; // returns an TMSQuery object try LQuery.SQL.Clear; LQuery.SQL.Add('Begin transaction'); LQuery.SQL.Add('INSERT INTO
Insert to oracle 21 -> -922337203685478 value instead of 1.99 (exactly 1,99)
Hello, we have a problem with entering values to fields. The value 1.99 is entered into the table as null or as -922337203685478. We are using a 32 bit client - there is a problem on it. On the 64 client it is fine, unfortunately we cannot use it. Current
Performance on PostgreSQL connection
Good afternoon! We use TUniConnection in our applications, using in most cases the PostgreSQL database. We are experiencing problems related to slowness, especially when our customers use VPN for the connection. We are currently using the parameters below:
EMyError
Hey there, I think that the online documentation for EMyError is *very* incomplete. There is no mention, for example, of a "Message" property, which I've seen you mention in some help topics. Can you please point me where I can find the structure of EMyError
NET:IOHandler is not specified
A user is receiving this error message when attempting to connect to the database using a TOraSession in DIRECT mode. Can you tell me what this error means and how to resolve it? I am using the most recent ODAC version on Delphi 11.3 compiling in 64 bit.
Modify TStringField for ANSI / UTF translation
I am using the latest UniDac version with Delphi 12.3 on an oracle database (db2 / sqlserver planned) There are many old cobol applications running which not support UniCode, so data is written as AnsiString using the codepage setting of the windows client.
UniDac - Delphi 11.3 - OpenSSL - Linux
Hello Community, We'd like to upgrade our Ubuntu Docker containers from V 18.04 to someting newer. We'd also like to use newer SSL components, but it seems like UniDac (MySqlConnector) only works with OpenSSL 1.x.x. Can someone shed some light on that
'Invalid parameter specified' on prepared query with a double
In our project we get an Exception: 'Invalid parameters specified'. We've determined that this is specifically when we use a double variable. In the scenarios below the first two instances of TPgQuery are executing properly, however on opening the third
ConnectDialog
Hello, when trying to open the connection to the database, if it fails, it shows me the ConnectDialog even though I don't have any associated TConnectDialog component, I need it to mark the exception and not show the ConnectDialog. How do I do this?
Number(20) cannot be read!
Hi, using c++ builder 10.3.2, unidac 9.2.1. I have an oracle table with column number (20) populated with numbers having 17 digits create table pelidetail(id number(9), peliid number(10), sortweight number(20), primary key(id)); insert into pelidetail
SQL Server LockTimeout not working?
I am using Delphi XE10.3.2 with UniDac 9.3.0. SQL Server We have a problem with a MS SQL Server Stored Procedure that frequently comes up with a "Lock request time out period exceeded." error. The SP basically does a lot of table Truncates and then INSERT
BREAKING CHANGE - Default Encrypt with Microsoft OLE DB-Driver 19 for SQL-Server
Hello I create a database connection with all standard parameters (TUniConnection.SpecificOptions) to MS SQL Server MyConnect := TUniConnection.Create; MyConnect.ProviderName := 'SQL Server'; MyConnect.Database := <DBName>; MyConnect.Username := <DBUser>;
Unidac 9.4 and SQL-Server
I'm trying to connect to a SQL-Server database. This works without any problems with Unidac 9.3.0. After installing Unidac 9.4.0 the application crashes. The reported error is 2.5 Type : EMSError 2.6 Message : TCP Provider:_Es konnte keine Verbindung
Next Page