Postgres: Performance-Issues after updating from UniDAC 9.4.0 to 10.2.1
Hello, we massive perfomance issues after updating to your newest version. For example: TUniTable (default settings), TUniConnection (already connected), Table with 621 Records - Version 9.4.0: Open returns after ~25ms - Version 10.2.1: Open returns after
Timestamp with TZ field date shifted +66 hours
Hello, Please connect as SYS with direct TCP/IP to an Oracle 19c database. Use an TOraQuery with the following SQL: select /*+first_rows*/ ORIGINATING_TIMESTAMP, HOST_ADDRESS, container_name, module_id, process_id, message_text from v$diag_alert_ext where
PostGres reserved Word
Hi, I'have a table with field INT1,INT2,INT3. On Oracle if I worte SELECT * FROM MyTable WHERE (INT2 = :INT2) it work fine but in postgres params.count = 0, INT2 is a reserved word in Posgres. It Works if I change the query in Format('SELECT * FROM MyTable
SecureBridge: Prevent File Creation with TScSFTPServer
I am uploading files with a SFTP Client to a TScFTPServer, but I want to process the stream directly without creating a file alongside it. I tried overriding OnWriteFile, but then an empty file gets created, which I want to avoid. It seems like OnOpenFile
Connecting to Oracle Autonomous instances with Unidac
Hello, We are using Unidac in Delphi 11 to connect to Oracle Autonomous instances in Direct mode but we can't get it to work. If we give "adb.region.oraclecloud.com" as the server and valid user/password credentials, we receive the following error: ora-03113
UniDac DBF Direct Connection - PACK Table
In the UniDac documentation, in the native DBF provider section a mention is made that PACK-ing of DBF tables (files) is supported. Searching the source code I came upon the TDBFDBase class which implements the PackTable method. I tried to use it by creating
Unidac - MSSQL - Linux
Hi everyone I am migrating a REST application (DMVC Framework) that uses Unidac to access a MS SQL Server 2022. When executing a query with data containing accented characters, all of them are replaced by "?". When compiled and executed on Windows, the
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
SDAC Connection Pooling with TWebModule in Linux environment
We are trying to evaluate whether we can, and exactly how, we can use connection pooling with TWebModule in a Linux env (Apache specifically). We have essentially stripped all threading from our application as it does not seem to play well under Linux.
Delphi TMSStoredProc parameter issues
Hello, we are replacing ADO with SDAC in our application. I cannot get one thing work.. myAdvStoredProcedure := TMSStoredProc.Create(nil); myAdvStoredProcedure.StoredProcName := 'GetCustomerTest'; myAdvStoredProcedure.Params.Clear; myAdvStoredProcedure.Params.CreateParam(ftInteger,
UniDAC SQLite Float type issue on Windows ARM virtual maschine
Hello! I am working since years on a Mac (M1) with VM-Tool Parallels within a Windows ARM version. Recently I have a problem with updating any float values in the database. It's really strange. If I want to update 1 field with type "float", "double",
Unidac + Firebird: error if unicode is used in SQL query
With UniDac 9.4 (demo), Delphi 11 and Firebird 4 If I use some characters in a query I get a Dynamic SQL Error SQL error code = -206 Attached a "working" example! It's my fault or a bug? Thanks Nicola
New User: Following EntityiDAC PDF - Issues
I am trying to follow the demo in the EntityDAC pdf using a sql server. I am to this step: "Then select the EntityConnection component, specify the path to the database in the ConnectionString property and set other properties as follows:" I am populating
Issue with DescribeParams on SQL Server 2022
Hi, we are migrating from SQL Server 2012 to SQL Server 2022 and have a problem with using property DescribeParams of TMSQuery component and calling Prepare. MSQuery1.Options.DescribeParams := True; MSQuery1.SQL.Clear; MSQuery1.SQL.Add('SELECT TOP 10
Connection to MongoDB gives me authentication error
Hi, (I could've sworn I asked this question but my post seems to have disappeared.) Please note I am using Delphi 10.3 (still on a Win8.1 system). On the MongoDB system, using mongoshell: use testdb db.createUser( { user: "testx", pwd: passwordPrompt(),
Using TUniQuery w/ MongoDB
Hi, Having taken a look at https://docs.devart.com/unidac/using-mongodb.htm#tuniconnection, I'm still struggling as the amount of information is somewhat limited (particularly the examples). I have the following code: procedure TForm1.Button1Click(Sender:
Unknown error in OLEDBAccess
We use the latest version of SDAC The program written as a service With several threads in Windows. Sometimes this address is announced and closed accidentally while working Assertion failure (D:\ProjectsClone2\Delphi\Dac\SqlServer\Source\OLEDBAccess.pas,
Access Database "Direct" mode DDL statements not supported
Delphi 7 with UniDac 10.2.1. We are trying to create a view in an Access database using the TUniSQL component. We are using the new "Direct" mode (which is really wonderful, by the way, because it gets around the 32bit/64bit Access Database Driver problem).
Unprepared Execute False by default > why statements are prepared by default
Why UnpreparedExecute is *False* by default. So you always prepare statements by default? If i understand the help correctly, this will call an additional "PREPARE". (https://www.postgresql.org/docs/current/sql-prepare.html) This is in most cases not
[bug] with real data type
hello, PgQuery.SQL.Text := 'SELECT 0::real'; PgQuery.Options.UnpreparedExecute := true; if not(PgConnection.Connected) then PgConnection.Connect; PgQuery.Open; It will crash at opening with an exception! and sometimes (in some queries using real data
AzureAD Interactive Authentication
Hi, I'm attempting to get AzureAD Interactive Authentication (auADInteractive) working with SDAC connecting to a SQL Azure database. At the moment it always asks for my password and then a two factor auth challenge. This happens every time I start the
Unidac in a Windows Service?
I have spent a lot of time trying to get a couple of applications using Unidac to work as a service. I can get these applications to work ok in GUI mode, but they will not run as a service. I can install the service ok, but when I try to Start the service,
Unidac do not connect to NEON database site.
In Delphi I can connect using FIREDAC components and its works fine. But I need use UNIDAC (TUNICONNECTION). And when I try to connect with NEON DATABASE, using the exact same connections informations, this error shows up (SSL_do_handshake = -1) I had
Unidac Postgres - Postgres 14 and older UniDAC postgres
I had to rebuild my old dev environment and installed newer Postgres version, previously had 9.x and went to 14. I have resolved the error, but want to share my solution here. this link let When developing with older unidac 8.4 I ran into issue where
SQLite upper() function Unicode
Hello, SQLite doesn't support unicode SQL upper() function. My question: is there a way in UniDAC to enable it? Example: current: select upper('aou-äöü') -> 'AOU-äöü' expected: select upper('aou-äöü') -> 'AOU-ÄÖÜ' Some suggestion? Br, /Werner
TUniConnection feature request
Hello Please add TUniConnection.CommandTimeout specific option for SQL Server because ConnectionTimeout and CommandTimeout are not the same things. See MSClassesUni.pas, line 1246 It's need for Connection.ExecProc and Connection.ExecProcEx
PostgreSQL: "Unexpected server response : ¹."
The question is how can I avoid this exception? UniDAC 10.1.0 with PosgreSQL server. I try to return a blob field of PosgreSQL type bytea using this code with TUniQuery.Create(nil) do try Connection := ucDL; SQL.Add('SELECT ' + FieldN + ' FROM ' + sNumeTabelComenzi
Strange Refresh Failed error message
Hello, I have a TOraQuery component, with a relatively simple select. It joins tables for the master table called ATB. select atb.rowid, atb.*, sby.c_nev1 c_belep_szintnev, bko.c_nev c_szervezetnev, saj.c_nev1 c_uzemkodnev, bkp.c_nev c_onelszamolonev,
Access violation Unidac in 64bit
I can't connect by using the TUniconnection compornent. My connection makes connection editor. 32 bit is ok, but 64bit is fail. My Environment is Win 11 & Delphi 12.1 & Unidac 10.2.1
Connection Pool is used like this ?
---------------------------------------------------------------------------------------- program api; {$MODE DELPHI}{$H+} uses cthreads, db.dataset; begin db.dataset.PoolConexao; end. ----------------------------------------------------------------------------------------
Regression in UniDAC 10.2+ with PostgreSQL
Hello, When running our database test suite I noticed multiple EOutOfRangeArgument exceptions being thrown by UniDAC (10.2 and 10.2.1) with PostgreSQL (v13.14). When executing the same SQL requests (simple UPDATE statement) directly against the database
PostgreSQL column default values
Hi, I'm using PostgreSQL 15 with Delphi 11 and latest UniDAC components. Create a table: CREATE TABLE sample (col_a VARCHAR DEFAULT 'A'); Then use a TUniQuery that "SELECT * FROM sample", add a TDataSource linked to the query and a grid and dbnavigator
Update to 12.2 with C++Builder 12.0 not working
Hello support, I made an updaet tp 12.2 and got these errors. [C++ Error] Crtypes.hpp(230, 7): unknown type name '_DELPHI_CONST' [C++ Error] Crtypes.hpp(230, 29): cannot define or redeclare 'Int8' here because namespace 'Crtypes' does not enclose namespace
UniDAC Providers components disappear Delphi 11.0
Yesterday I downloaded the UniDAC trial version, installed under Delphi 11.0. Created a program that consisted of a connection, provider, data source, and a dbgrid. Got connected to my SQL Server and the grid populated with the results of the query. Fantastic,
UniDAC 10.1.0 - StoredProcedure incorrect results
Database: Firebird. Since the update, it may happen that StoredProcedures return incorrect results. For some colleagues with Delphi 11 or Delphi 12 it happens that a TUniStoredProc does not return the correct result. But not with all of them, so unfortunately
"The client code page 65001 does not have a corresponding SQL Server Collation. InMemory Rowset creation failed."
A customer has set a Windows setting that was marked as beta, but is probably now required by several applications: Control Panel > Clock and Region > Region > Administrative tab > Change system locale button > Beta:Use Unicode UTF-8 for worldwide language
Unidac 10.1 (in)compatibility issue with Delphi 12.1 in 64bits mode
Hello, We came across an issue while trying to use Unidac from packages compiled with Delphi 12.1 (Version 29.0.51961.7529) on 64bits windows platform. At launch, the package tries to resolve a symbol called __init_record_FILENAME, which, was apparently
How to use UniDAC to connect to Borland's Paradox database
Hello everyone, I'm maintaining a legacy project, developed in Delphi 7, and using the Paradox database (plzl.DB). I now need to migrate the database using the UniDAC component, but I found that there is no Paradox option in the ProviderName property.
How can detect which driver is used by active TMSConnection?
Hello, How can detect which driver is just used by active TMSConnection from code.. For example if is used Native client 11 or Native client 10 or Ole db provider, or SQL server OLE DB driver 19 or 18....... etc... need something like this showmessage('Iam
constraint failed virutalquery
Hi, With the code below : //---- Ouverture de la tables des paramètres (L_PARAM_AS is a TUniTable component on L_PARAM_AS table in attach file) L_PARAM_AS.Open; //---- RequeteParametreDispo is a TVirtualQuery with L_PARAM_AS in source dataset RequeteParametreDispo.Sql.Text
Next Page