[PgDAC] Error when executing SQL Query in table with blob files
Hi there, hope you'll ok. I recently started using PgDAC for queries that works with blob files, especially using the "execute" command of PostgreSQL (version 16). When i execute the query, i'm getting the following error: "ERROR: Assertion failure (D:\Jenkins\workspace\DAC\PgDAC\Delphi\Dac\PostgreSql\Source\PgSQLProtocol.pas,
Sqlite support to Microsoft Visual Studio Community 2022 (ARM 64-bit)
I'm using Microsoft Visual Studio Community 2022 om a macbook pro M4. Everything work just fine except dotConnect for SQlite. Using latest version 6.4.190 Getting error when try to open SQLiteConnection in debug mode. Application is running fine standalone.
TScSMTPClient for dummies
Hi, I am playing a little around with ScSMTPClient and was able to send mails. I am currently failing to get/receive an errror when using an non existing adress no matter wether used as a from or to address. Am I right that this is probably related to
Any plans to create an ODBC driver for Xero?
Hi Just wondering if there is any plans in the works to create an ODBC driver for the Xero platform?
.NET 9 - Devart.Data.Oracle.EfCore - Discriminator issue with include
Hello Devart, When using discriminators in EF Core and then including navigational properties which aren't available on all discriminated types, only on specific derived types: var result = await ctx.Vehicles .Include(_ => ((Car)_).PossibleEngineTypes)
.NET9 Ef Core 9.0.1+ Object reference not set to an instance of an object.
Hi, I'm getting Object reference not set to an instance of an object. from Microsoft.EntityFrameworkCore.Relational at pretty much each query. For example: await context.TV_USERS.AsNoTracking().Where(x => x.ID == Id).FirstOrDefaultAsync(ct); I'm using
SecureBridge Installer won't let me uncheck any components
Hello, I want to uncheck the following in the SecureBridge installer, but the boxes don't respond when I uncheck them. SecureBridge files for Win64 (Modern) SecureBridge files for macOS SecureBridge files for Android It's not a big deal, just annoying.
DateTimeOffset.Date does not correctly truncate time in dotConnect for PostgreSQL
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. We have been using multiple methods from the DbFunctions class, many of which were removed in EF Core. From my understanding, DateTimeOffset.Date
SDAC older versions download
Hello, Where can I download older versions of SDAC? I have UniDAC installed on our developer machine and it says I need very specific version of SDAC, not any two versions are compatible. So, I need to try SDAC on Delphi 11 Alexandria, specifically version
C++ Builder error: E2015 Ambiguity between 'Crjson::TJSONObject' and 'System::Json::TJSONObject'
I just moved one of my C++ Builder projects to RAD Studio 12.2 and UniDAC 10.3.2. I am getting the above error plus E2015 Ambiguity between 'Crjson::TJSONArray' and 'System::Json::TJSONArray'. I am only using TJSONObject and TJSONArray in this project,
SQLite low-level
i want to understand - can i use unidac/litedac in low-level mode? without connections, datasets and so on. as i see - a can use LiteStaticUni module. and, may be, some thing else. is there are some description or manuals for it?
TUniQuery fails with Parameterized UpdateSQL while updating data in AWS to Bablefish for Aurora PostgresSQL
Hi We have been using your wonderful library of UniDAC components (for SQL Server) for several years now and currently use version 10.1.0 professional version for Delphi 12. Currently we were evaluating to move our database to AWS through Bablefish implementation
Define ClientID and ClientSecret in Dynamics365 ODBC DSN
Hello, how is it possible to store a ClientID and a ClientSecret in a Windows ODBC connection for the Devart driver in the ODBC Manager? I only see the option to generate a token, and I am then prompted to log in. However, I would like to create an app
Oracle Idle Time and Odac
I am running Odac 12.1.1 with Oracle as my database. In Oracle, the idle time is set to 1 min. SQLPlus disconnects perfectly after 1 min idle time. My frontend application however exactly disconnects after 3 min Why is that ? Anyone else seen such behaviour
Why no feature to convert T-SQL to LINQ for .NET 9 Core?
I keep requesting and keep hoping my yearly subscription will get T-SQL to LINQ for .NET 9 core. But sadly every year passes an no feature added? Stored Procedures are a thing of the past and most development projects no longer use them. It's 2025, can't
VirtualQuery IsNULL
Hi, Is use a virutalQuery to show informations : 1. SELECT A.INT_COUT,A.MAT_ID,A.INT_DEB,A.INT_TECH,CAST(SUBSTR(A.INT_DESC,0,255) AS VARCHAR(255)) AS INT_DESC_T,CAST(SUBSTR(A.INT_ACT,0,255) AS VARCHAR(255)) AS INT_ACT_T,A.INT_FIN,A.INT_TYPE,(B.T_CIVILITE
SqLite Localized Order
Hi With Android Studio Java I can select a sqlite table like Select * From MyTable Order By Name Collate Localized The data returns ordered by with my language specific characters But there is no such an option with Delphi/Unidac I receive an exception
Invalid SQL when ordering on a calculated boolean field: "ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering on a calculated boolean field. This is an example of the invalid SQL: SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m0" WHERE "m0".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END) "HasMoreThenOneModel",
Ora error when filtering/ordering on a calculated boolean field: "ORA-00933: SQL command not properly ended"/"ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering/filtering on a calculated boolean field. This is an example of the invalid SQL SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m" WHERE "m".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END)
.NET 9 - devart.Data.Oracle.EFCore method not found
Updating everything for .NET 9.0 and suddenly I get the following error: System.MissingMethodException: 'Method not found: 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlConstantExpression Microsoft.EntityFrameworkCore.Query.SqlExpressionFactory.Constant(System.Object,
Batch move and creating destination table in Access
Hello! I'm experimenting so that we can move away from Paradox onto something a little bit more useful. For the time being, however, the "temporary fix" is Access. Let's not go into the why, how, etc. For now this is the best course of action. The access
ODAC local filter raises EVariantTypeCastError
We have tried to use a newer ODAC version in production. The following issue is a showstopper for us. It seems that this issue exists since version 12.3.0. Steps: - compile and execute the following command line application Expected: the output is PASS
DBExpress driver for PostgreSQL
Hello, I've read that you can't use multi transaction with Devart drivers for PostgreSQL. But I also read that PostgreSQL seemed to support it. Can you tell me what's going on? Thank you in advance. Lbn69
ODAC: "Invalid Field Type" when calling a stored function with VARCHAR2 params
We have developed a VCL application in C++Builder, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. Our database is Oracle 19 running on an ODA with latest patches. The problem always occurs when I
EntityDAC developer on Oracle
Hello, I'm trying to use Entity Developer to generate model for my Oracle database. It seems that after model generation some table are not still present in the database. I'm using Entity Developer version 6.12.1354 trial. Thank you, Luca
Access denied for user 'x'@'ip' (using password: YES)
Hello, This is maybe a strange question, but I am evaluating the mysql connector and I started by trying to generate a model Entity Developer (with entity framework - database first approach). The problem is that I am not even able to connect to my server,
Universal Error in Mysql
hi all ! Im getting the following error and I dont know whats causing it. Exception thrown: 'System.NotSupportedException' in Devart.Data.dll UniDbType not supported by current data provider This is how I setup the connection public new Devart.Data.Universal.UniConnection
Module Class connect() method ConnectMode = "Unsafe" parameter
Hi All, I am using this connector for a few days now and I am quite happy with it. Recently I had to deal with a connection to a 3rd party Visual Foxpro database in which I couldn't connect because the dbf file I wanted to access was locked by another
XDBGrid sort function doesn't work
I'm using the XDBGrid sorting feature in FireDac, but it doesn't work in uniDac. If you have any solutions, please let me know. XDBGrid Designer -> Contrlo2 -> sortingControl
opened connection by an exception
In the TCustomPgDataSet.Execute(PgAccess) becomes TCRConnection.FAutoCommit(CRAccess) set to false and not reset after the exception in the RefreshRecord. Then the error dialog, through our THauptForm.ShowServerTimer a ConnectionCheck with "Select true,"
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
SOQL queries - field/column aliases not recognized and/or toLabel() function duplicate field errors
Currently running Devart ODBC Driver for Salesforce 3.4.1, set up as linked server in MSSQL 2019 (15.0.4405.4), and I don't seem to be able to use field aliases when running SOQL queries via an OPENQUERY statement. For example: SELECT * FROM OPENQUERY(PCCUSFPROD,
.Net 9 / EF Core 9 support
Hi, What is the roadmap / delay to support .Net 9 / EF Core 9 on the Devart.Data.MySql.EFCore library ? Regards.
Skip exception
hi all ! I have the following code that returns a bool value. If there is no connection it should be false. The problem is that I always get the exception and get out of the program. Is there a way to avoid it? private static bool IsMariaDBServer(string
SOQL error: unexpected token: '('
I have a complex SOQL query that includes nested queries of child objects that works in the Salesforce workbench but fails with the error "OLE DB provider "MSDASQL" for linked server "SALESFORCE" returned message "[Devart][ODBC][Salesforce]Invalid SOQL:
DIRECT Mode fails with "Net: error 99" if a TYPE is modified between uses in a SELECT
Hello, Using the attached demo project with the latest version of ODAC and Delphi. You'll have to enter your own user/pass/server. The bug happens on any Oracle version. After connecting in direct mode, a script runs which does the following: 1) Creates
Firebird query statistics, int32 of int64?
Hi, In my application, I'm using TIBCConnection.DatabaseInfo to fetch query statistics, the Reads/Writes/Fetches/Marks fields. These are int32, but I think these should be int64. Can you check with the API? Here's an example of values that clearly overflow
Direct connect to MS Access in 64bit application
Hi, Since we have issues with connectivity through OLE DB (using ADO) on certain installations (mostly windows hosts with win32 Office installed) we're trying to use UniDac in order to connect to a MS Access database in direct mode. Delphi 10.4 and UniDac
securebridge with mydac
ThirdParty demo mydac are SecureBridge(Deprecated) and SecureBridge With last delphi 12 with patch wich one should be install deprecated has MySSHIOHandler and MySSLIOHandler In mydac connection handler properties have no longer available components if
Received error message not overriden in inherited class
with securebridge (ssh connection i received this error message. In local connection not received nothing Any idea why I received this error see attach file
Next Page