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,
dotConnect for MySQL is missing a detail on running a Update in ASP .NET MVC
I am attempting to follow the code snippets on the link shown below and have been able to retrieve and create new database records. dotConnect for MySQL Entity Framework Tutorial (devart.com) The issue is that trying this code snippet below doesn't actually
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
Can I use dotConnect Universal with Entity Framework?
Hello, I'm very new to your product and I consider using it in our project. We need to have the ability to switch between two different databases - Oracle and Postgre. My question is would that be possible with dotConnect Universal while also working
License issue when upgrading from EF Core 7 to 8
Hi, I am working on an application that uses the Devart.Data.Oracle.EFCore nuget package to read data from an Oracle 10g data base. Originally, my application was based on .NET 6.0 and Entity Framework 7. Recently .NET 8.0 was approved for usage within
"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
OperationalError: Trial period has expired
Hi guys! I'm trying use devart.ase lib for python (3.10) and i get this message: "OperationalError: Trial period has expired." Is this lib free for use? if not, how much is? and how can i get a valid license? Thank you in advance
Unexpected SqlParameterExpression implementation when using Oracle spatial functions in EF Core 8
We are planning to upgrade EF Core 6 to EF Core 8 along with upgrade from .NET 6 to .NET 8. We frequently use Oracle spatial functions: "SDO_RELATE" and "SDO_WITHIN_DISTANCE", which unfortunately do not have built-in support in dotConnect for Oracle according
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.
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.
Next Page