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).
Salesforce ODBC - How to work with *ChangeEvent tables?
Hi there! We've recently bought our Devart Salesforce ODBC license and set it up so we can query our Salesforce via Microsoft SQL LinkedServer. I've now seen that nearly every Object has an additional ObjectChangeEvent table and I was wondering how we
woocommerce - unauthorized
Hello, We've just installed the Woocommerce ODBC driver, configured it with domain name, customer key and customer secret, but we keep getting the following error message The remote server returned an error 401 : unauthorized The same credentials work
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
"CROSS APPLY" is not supported in Postgresql?
Hello If I use a LINQ query over 2 tables, I get an error 42601: syntax error at "APPLY" It seems that the SQL contains "CROSS APPLY" which is unknown in Postgresql. How can I avoid that ? Never had that problem with the previous versions (.NET Framework)
Visual Studio 2022 error not loading Devart.Data.PostgreSql.Vs.dll (dotConnect for PostgreSQL 8.1 Express)
Hi, I cannot find this topic in FAQ. So I posted here. It will always appear when I start Visual Studio even when with empty project. Please advice if this error can be ignored. Regards Samuel Toh
Not for profit volunteer developer
I'm doing some volunteer database work and the NFP wants to connect the DevArt plugin from their shopify account to their Microsoft Access database. I have full rights to a sandbox store, but I'm getting an error message -7711 from Access when I try to
Passing parameters to TUniStoredProc without SELECT privilege
Hello. I have MySQL database with some of the stored procedures for accessing data in it. The only global privilege enabled is EXECUTE, others are disabled. I'm trying to call a stored procedure in MySQL database with the help of TUniStoredProc using
Is there a code sample on how to use multiple DbContext
Hi devart team I am developing an ASP.Net Core application using .Net 8.0 and DevArt.Data.Oracle 10.3.10 and DevArt.Data.Oracle.EFCore 10.3.10.8. I have two projects each has a DbContext. In the program.cs for both DbContext services.AddDbContext<DatabaseContext>(options
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,
Devart.Data.Oracle.EF6: Can it have .Net Framework support in Nuget?
Hello, I am currently updating our dotConnect for Oracle (DevArt.Data.Oracle) package to 10.3.10 in our .NET Framework 4.6.2 solution. I would also like to update Devart.Data.Oracle.EF6 to 10.3.10 but the dependencies in nuget requires .NET Standard 2.1:
OracleSQLCompatibility with EF Core 8
Hi, I am working on an application that uses the Devart.Data.Oracle.EFCore nuget package to read data from an Oracle data base. I want to update the application to EFCore 8 but I have a problem with Contains in LINQ queries when I use a older Oracle database.
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
SQLite data access issue
I have successfully installed the Devart SQLite ODBC driver and I can connect to the SQLite database using MS Access. I can update data and delete rows but I am having 2 issues I hope you can help me with. · I am unable to add new rows to any SQLite table
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
ut8 collation
Starting with SQL Server 2019, there is a new collation named Latin1_General_100_BIN2_UTF8 which seems to allow to use unicode-characters in traditional varchar-fields. Can you share any experience with columns using that collation? We access our database
dotConnect for MySQL can't display Chinese Character
Hi, trying to evaluate if the dotConnect is useful for my project, I downloaded the free version. managed to get the thing to work after jumping through many many many hoops. (Like, it doesn't work in VS2022, had to hunt down a copy of VS2019 to get it
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
Issue with Dynamics ODBC
Good morning, We've a recurrent issue with this ODBC...every 2 weeks - more or less - we're not able to use it due to this error: We bought a full license months ago. We've tried several times what you suggested on previous communications: remove the
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,
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.
Next Page