Keep getting an exception of "ORA-00971: missing SET keyword" where SET keyword is there.
Hello friends, I keep getting an exception of "ORA-00971: missing SET keyword" for the following source code. I have no idea why. As you can see, it has SET keyword. Any ideas? Thank you so much! try { OracleConnection connection = new OracleConnection(_connectionString);
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"
Solution for .NET entity framework database connection using web API
We have a windows .NET application which is built using Entity framework and WCF. Looking for Database connectivity tool to stablish secure connection with SQL Server Database using web API
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?
Entity Developer and Composite Keys
Hello, Is there are way within Entity Developer, prior to code generation, to flag attributes, and remove the warnings e.g. Northwind db (image) so my generated code mappings won't have an issue. Thanks.
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
GetDate() error for Dynamics ODBC Driver
I'm getting an error message when I use GetDate() in a SQL query I'm writing using the ODBC driver. Basically I only want to pull records created today. Has anyone run into this issue and found a work around? Thanks
Firbird 5.0 / Substring in IbcQuery.Filter
Hello devart team, Try to filter an IbcQuery (latest release) with firebird 5.0 : IbQuery1.Filtered :=False; IbQuery1.Filter := Substring( MyField from 1 for 5) = 'Hello' IbQuery1.Filtered :=True; This rise an error : "Substring is an unknown Field" (Something
ItemInventory missing custom fields in QuickBooks Desktop
I'm trying to select from ItemInventory with a python script and I'm finding that the table structure is different, when I use the DevArt driver rather than the QODBC driver. Particularly, the custom fields are missing. I'm not seeing any settings in
SocketException with dotConnect for Magento while Opening Connection
Hello, I am experiencing a Socket connection error with ADO.NET provider for dotConnect for Magento while opening a connection. Interestingly there is no problem connecting to the database with MySQL Nuget package by Oracle. The Connection Errors are:
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
Oracle AQ - Dequeue from a sharded queue causes invalid cast exception
Since i converted my Oracle queue into a sharded queue, the OracleQueue.Dequeue function always throws an invalid cast exception in Devart.Data.Oracle.dll. When i used a normal queue everything worked fine.
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
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
Next Page