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.
ODBC Driver for BigCommerce
We are currently evaluating the ODBC driver for BigCommerce 2.4. Our products table in BigCommerce Enterprise has 500,000+ records and would like to query it. We are using a criteria in our query to display 1 product or 1 SKU but it doesn't show up (or
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.
Connecting to PostgreSQL or MSSQL Using Oracle Database Link and ODBC Driver
I want to connect PostgreSQl and MSSQL in Oracle using dblink. I do everything from this page https://docs.devart.com/odbc/postgresql/oracle_dblink.htm and it doesn't work. Please help
Foreign Key violation with 11.0.0
I recently updated SDAC to 11.0.0 (Delphi 7) and made a few tests and all seemed ok. This morning I had an Issue arise with a migration application, The main difference with this is the application connects to two MSSQL databases and allows our customer
Concurrency violation when updating SQLite database using DevArt ODBC Driver
Hi, I'm trying to debug errors produced when updating an SQLite database using the DevArt ODBC Driver from a Win32 application. I'm using COM/MSADO in C++ to interface with the Microsoft OLE DB Provider for ODBC Drivers, which in turn uses the DevArt
ODBC Driver for SQL Server with DBExpress
I Want to know if it is possible to work with the ODBC Driver for SQL Server using dbexpress connection with Devart drive ? and how should I configure tha parameters connections ?
Remove Transaction
Hello, i am creating at runtime a update transaction based on the edit form : Var FUpTrans: TIBCTransaction; procedure OnFormCreate; begin FUpTrans:= TIBCTransaction.Create(AOwner); <-- AOwner = Form FUpTrans.Active := False; FUpTrans.DefaultCloseAction
IBCQuery1.LoadFromXML(File)
Hello Devart Team, All is on the Title. I need this scenario : 1. Saving data to an XML File : IBCQuery1.SaveToXML(aFile); 2. Retreiving these Data from this aFile, something like : IBCQuery2.LoadFromXML(aFile); As IBCQuery.LoadFromXML does'nt exists,
Proxy connections in Direct Mode
Hello, I know that proxy connections are not supported in Direct mode. My question is - will they ever be? Is this something on your to-do list, or is there some reason that this is not possible? Thank you. John Dorlon
CRDBGRID Number format of summary row
Hello, does anyone know how i can set the number firmat in th tcrdbgrid summary row? I use this grid as a generic SQL table view. In the programme the displayformat of each field is set (floating and integer). The grid will show me the values. But right
Magento ODBC Driver with Filemaker
I am trying to use the Magento ODBC driver with Filemaker, but this is totally useless. My first try was the category DB which has something like 100 records. And this worked fine, after about 10 seconds the table was available. Of course that is still
Support Fastreport 2024.1
Can you add Support for Fastreport 2024.1 to use the FastqueryBuilder. In FastReport are come Changes and it will be fine to use ther frxUnidac Component with the QueryBuilder.
ERROR: devart_ase_connector-1.0.1-cp37-cp37m-manylinux_2_34_x86_64.whl is not a supported wheel on this platform.
Guys, I'm trying to install the "Python Connector for ASE 1.0 - Python 3.7 for Linux" library on Linux and I ended up coming across the following message: ERROR: devart_ase_connector-1.0.1-cp37-cp37m-manylinux_2_34_x86_64.whl is not a supported wheel
Problem with Firebird ODBC on Ubuntu
After setup and running isql -v DEVART_FIREBIRD I get: [S1000][unixODBC][Devart][ODBC][Firebird]Cannot load library: libcrypt.so [ISQL]ERROR: Could not SQLConnect Here is my setup [ODBC Data Sources] DEVART_FIREBIRD=Devart ODBC Driver for Firebird [DEVART_FIREBIRD]
VirtualQuery To_Date
Hi, I need to write query in VirtualQuery with To_Date syntax what is the correct way to do it, what is the engine behind VitrualQuery ? Thanks.
Suggestion: add "Encoding" parameter to TIBCScript.ExecuteFile()
Hi, my database is all UTF8. If I load a script in UTF8 format(*) using TIBCScript.ExecuteFile(), all german "umlauts" are scrambled. Funny enough, if I set "UseUnicode" option of TIBCConnection to FALSE, then it loads correct. But then all other inserts
EntityDac save entity to mariadb
I use entitydac context. in Delphi12 and entityDac 3.3.0 var predpokladanaoperace := entitycontext1.CreateAttachedEntity<TTOrderWork> ; predpokladanaoperace.OrderId := 'zakazka000001'; predpokladanaoperace.TsLastchange := now(); predpokladanaoperace.TsCreated
Insert into Sybase: The token datastream length was not correct. This is an internal protocol error.
I'm trying to insert data into a Sybase table, with Python, (with one column) through a procedure and I'm getting this error message. "The token datastream length was not correct. This is an internal protocol error." Below is the code I'm using: my_cursor
SDAC Support for 'Always Encrypted'
Hi Our Delphi application uses SDAC components (TMSConection, TMSQuery etc). I would like to know whether these support SQL Server 'Always Encrypted'? Thanks and regards Vinod A S
EntityDac save entity to mariadb - using FireDac
I use entitydac context. in Delphi12 and entityDac 3.3.0 var predpokladanaoperace := entitycontext1.CreateAttachedEntity<TTOrderWork> ; predpokladanaoperace.OrderId := 'zakazka000001'; predpokladanaoperace.TsLastchange := now(); predpokladanaoperace.TsCreated
unidac + oracle direct mode + non blocking mode
Hi, another question around non blocking mode. the actual working seetings - unidac + oracle db - direct mode - disconnected mode for me the non blocking mode doesn't work very smoothly as it blocks sometimes the entire main thread which the exact reason
Salesforce ODBC driver - select from ContentDocumentLink slow buggy
Hello! I am running this simple query in SSMS via a linked server against the ContentDocumentLink table. It its not only EXTREMEMLY slow, bit it does not respect the LIMIT clause and keeps slowly pulling more records into the output window maybe 30 seconds
MSAccess Direct Mode
Hi, With version 10.1.0 you add support of : MS Access data provider Added support for Direct mode How can I use it and is it working with old access database (.mdb) Regards,
Select and update
Hello I have a stored procedure that returns data and updates a table. How should I execute it to retrieve all the rows it returns and ensure that the changes are saved in the database? Thank you
unidac, oracle, direct mode, disconnected mode, non blocking - cancel query
Hi, i am using unidac to connect to oracle in direct mode, disconnected mode, non blocking and i have sometimes SELECT queries which are last long. I want to cancel them. The query will be triggered from the main/ui thread. How to do this? Do you have
VirtualQuery DataMaping Unidac 10.0
Hi, I use the code below : try //---- Création TableP_MESURES := TUniQuery.Create(Self); try //---- Création WQ := TVirtualQuery.Create(Self); //---- Source de données TableP_MESURES.Connection := FicheModuleDonnees.Connection; WQ.SourceDataSets.Add(P_VLC,
How to add the activation key to SQL Server without Visual Studio
Hello. We have SSIS Dataflow Components for SalesForce installed on an SSIS SQL Server. However Visual Studio is not installed. How can we activate the product without Visual Studio? I found one other thread on this topic that advised copying a .lic file
MAX number of connections reached
hi. I have a C# .net WebForms app with several hundred users. it is running on windows server 2016. my connection string looks like this: value="direct=True;Min Pool Size=5;Max Pool Size=200;Validate Connection=true;Connection Timeout=5;Default Command
ORA-01745: invalid host/bind variable name when using the same variable multiple times in EF7 query Where()
Hi, were are currenly using Devart.Data.Oracle.EFCore v10.1.134.7 in combination with EF7 on net6.0. Whenever we use a query that uses the same variable 2 times or more in a Where() method we get an ORA-01745 exception. Example: var today = DateTime.Today;
Salesforce ODBC - Update Record
Whats the best way to update a record in salesforce using the ODBC driver? I have this setup as a linked sever in SQL Server Management Studio, and would like to update a salesforce record from a local table.
Connection lost
Hello all, I moved the databe from Windows to Linux. And after this move my application is getting lost connection error. Is there an option in MyConnection component to handle such a problem? After loosing the connection all queries are getting problems...
dbexpsda doesn't works with fields with space
Hi, My dbexpsda.dll gives an error using table fields with space like [Num. Registro] in SQL Server . Anyone can help me?
Problems with Batch Updates
Even in the latest version of mydac I have problems with batch updates. (I told you already on the old forum) The problems started when you released a "faster" and "optimized" batch update ;) Now I can reproduce the error in my app. I have a main app
IBDAC and multithreading
From FAQ "Are the IBDAC connection components thread-safe? Yes, IBDAC is thread-safe but there is a restriction. The same TIBCConnection object cannot be used in several threads. So if you have a multithreaded application, you should have a TIBCConnection
UniDAC 10 Data does not get written to PostgreSQL DB
I'm using PostgreSQL 15.1, Delphi 11.2 I have a simple application (64Bit, if that matters) that uses a connection, the PosgresProvider, TuniTable and a Datasource connected to a dbgrid and dbedit and the With 9.4.0 everything worked. With 10.0.0 I can
Next Page