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
SQL Statement Parsing Error
Greetings; In version 10.1.0 of UniDac I have a problem in type conversions with PostgreSQL, this problem was not present in the previous version. Example: "SELECT id, name::text FROM customer" In the example SQL statement I get an error in the "name::text"
Firebird - RETURNING not working
Hello. I'm having problem in Firebird with RETURNING value with latest Unidac 10.1.0 on Delphi 11 update 3. Problem occurs when "same" query is used for SELECT and INSERT/UPDATE. I've attach db.txt with sample table T1 with three fields (ID,f1,f2). Here
UniDAC loading and saving Delphi TMemo
How can I load and then save a Delphi TMemo contents into an sqlite table?
performance of simple "select count(*) from ....."
I run a simple "select count(*) from mytable", but it is quite slow. sqlite3 database. If I do it with sqlitestudio 3.3.3 I get the answer instantaneous. 264000 records. With unidac it takes 6 secs, when I set unidirectional = false or it is much worse
I can't use UniDac in Linux application.
Hi everyone. I have a REST application in Delphi Athens 12, in Windows works very well (connected to PostgreSQL 14 in Ubuntu 22.04 64bits). I make the same application to Ubuntu 22.04 64bits (Target plataform), the application starts well, but in the
Security Banners
From https://www.devart.com/odac/revision_history.html.... Added support for connect to servers with enabled Security Banners in the Direct mode Hello, Can you provide some details on this? I would like to be able to display the banners in my application,
Type mismatch for SBadTimeZoneID
The second Parameter in the string SBadTimeZoneID (= 'Invalid Time Zone ID: (%d, %d)' ) is of type decimal. In the unit IBCCall.pas, the function TTimeZoneUtils.TimeZoneIDToTimeZoneName(...): String contains the line RaiseError(Format(SBadTimeZoneID,
TUniConnection.AssignConnect(TOraSession) ?
Hi, is there any way to assign an active TOraSession to a TUniConnection instance? There is a need to use both components with the same session.
How does IBDAC handle RETURNING in Firebird 5 if there is more than an row returned?
https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-compat-returning says: Client-side INSERT … SELECT, UPDATE, DELETE, MERGE and UPDATE OR INSERT queries containing the RETURNING clause may now return multiple
UniDAC: SQLite extension error
Im trying add pivot table extension "pivot_vtab" (https://antonz.org/sqlite-pivot-table/) to my sqlite, according to item "3. Pivot extension" in manual. I compiled DLL, in UniConnection did load an extension, see manual here: https://docs.devart.com/unidac/using-sqlite.htm.
Next Page