Occasional access violation in ODAC 13.3.1 when TOraSession is destroyed
Hello, We recently updated from ODAC version 13.2.1 to 13.3.1 and are now seeing an occasional access violation when TOraSession is destroyed. I am not able to reproduce this at will so I cannot provide an app to demonstrate the bug at this time. I do,
Oracle 19.24 + ASO + DirectMode
Hi I just applied Oracle 19.24 (Security Patch July 2024) to my database and the direct mode no longer work If I disable native encryption it works. Test case: $conn = New-Object Devart.Data.Oracle.OracleConnection('Direct=true;User Id=test;Password=***;Port=1521;Service
TScSMTPClient.AuthenticationType no longer available?
Hi, today I upgraded my SecureBridge from version 10.4.1 to the recently released 10.6.0. When I went to compile my project I found that the TScSMTPClient.AuthenticationType property is no longer available, so I can't define an authentication type before
Store RTF text
I am using Unidac 10.1 with Delphi 11.3. I am using an inherited component from TcxRichText from Developer Express to store formatted text with RTF in database. I am using MS SQL Server with type NVARCHAR(MAX) on the column. My problem is that rtf text
License Issue / Net8Core
Hello! I have the license key for Postgres Connector - Expiration Date Apr28, 2026. In the online overview for the License it tells me 'Available Product Version' 8.3.21 Now the Key and Nuget 8.3.21 works well with Net Framework 4.8 and Net5core on Linux.
migrating from firebird 2 to 4
I use dbx with dbexpress driver I am migrating from firebird 2 to firebird 4 and it returns the error: type mismatch to field 'QNTSAI', expecting :FMTBcd actual : Float I need a way to use both versions until I migrate all the databases delphi11 with
Salesforce ODBC driver exceeded API Requests allowed
A few days ago we used more than the 249k API requests our Salesforce license allows within 24 hours using your Devart ODBC driver. I can see the current number next to the label "API Requests, Last 24 Hours" on https://*.lightning.force.com/lightning/setup/CompanyProfileInfo/home
How to support non Unicode fields when using TUniConnection 10.2.1 to connect to SQLite database?
TUniConnection 10.2.1 When connecting to an SQLite database, because the field type of the table in the SQLite database is varchar (100) instead of Nvarchar (100), it is intuitively not a Unicode database, My current problem is that when I compile a program
Is SecureBridge 10.5.0 compatible with RAD Studio 12.2 - Patch 1
Hi, When I try to install SecureBridge 10.5.0, with the recently released RAD Studio 12.2 (Patch 1), i get warning message. "You are using a version of RAD Studio 12 that is required for SecureBridge 10.5.0." Is SecureBridge 10.5.0 compatible with RAD
RAD Studio 12.2 Athens Inline Patch 1 / UniDAC 10.3
UniDAC 10.3 does not work with the latest RAD Studio 12.2 Athens Inline Patch 1.
What does "Net: Invalid VerifierType" mean?
Hello, A user is attempting to connect to the database with ODAC in direct mode and receiving the error "Net: Invalid VerifierType". What does this error mean and how can it be solved? I see it in OraNetLogon.pas, around line 1529 but of course I can't
RAD Studio 12.2 Athens Inline Patch 1 / ODAC 13.3.0
ODAC 10.3 does not work with the latest RAD Studio 12.2 Athens Inline Patch 1. Starting Delphi 12.2 shows errors like this (german version): "Der Prozedureinsprungpunkt "@Idetheme@Utils@TIDEDialogRegistryServices@$bcctr$qqrv" wurde in der DLL "C:\Embarcadero\Studio\23_components\ODAC\Bin\Win32\oramigwizard290.dll"
MyDac 12.3 and RAD Studio 12.2 Athens Inline Patch 1
MyDAC does not work with the latest RAD Studio 12.2 Athens Inline Patch 1. Can you please update the install file?
UniDAC fails to load in Delphi 12.2 Patch 1
Tried reinstalling but still get entry point error when opening Delphi.
UniDAC SQL Server - prDirect vs. prNativeClient
I use prDirect for SQL server now. My question is, if there is any advantage when I use prNativeClient or prMSOLEDB compared to prDirect? Christian
UniDAC DBF Provider Insert Into Temporary Table
SELECT * into #AA from XYZ gives an error. How can this be done?
PostgreSQL version 17
Did somebody already test UniDac 10.3.x with the latest PostgreSQL version 17.0? Everything ok or are there any known problems? Regards Christian
Trial Period expired
Hello! We have been using the ODBC driver for SalesForce (SQL Server) for almost a year and it has started in the last 24 hours giving the trial period expired error. Our license is valid until 2026, has anyone experienced this before?
Error Connecting Through DSN
I'm trying to connect to Shopify through a 32-bit DSN in Windows 10, using the Devart ODBC driver for Shopify. The owner of the site created a custom app and gave it all permissions, and got an Admin API Access Token, which he shared with me. The Devart
TUniStoredProc fails when connection has parameters
Hi, I have simple UniStoredProc it works fine if I don't define any parameters to connection. But when I add 2 parameters to uniconnection UniConnection1.macros.Add('false','0'); UniConnection1.macros.Add('true','1'); I get error [Zen][ODBC Client Interface][LNA][Zen][SQL
After database upgrade from 19c to 23c, connection in Direct mode gives "NET: Invalid input arguments" error
Hello, A user has a database that was upgraded from 19c to 23c. When the database was on 19c, he could connect using our application (using ODAC in DIRECT mode). Then the database was upgraded to 23c, and now he gets the above error. He says that he can
PostGreSQL/10.3.0/BLOB
Hi, I have updated to Unidac 10.3.0 and I've a problem with the code below : //---- Sql - Sauvegarde des lignes existantes LQ.Sql.Text := 'SELECT MAT_ID,INT_DEB,DIM_EXTENSION,DIM_DATE,DIM_SOURCE,DIM_LIBELLE,DIM_FILENAME,DIM_ID,DIM_ORIGINAL FROM T_DOC_INTER_MAT
Log für TScSMTPClient verfügbar
I use SecureBridge - TScSMTPClient in Delphi 12.2 to send e-mails. It works very well. Is there a way (and an example) how I can log the connection setup, sending and disconnection, similar to a logger? Best regards Gerd
Unidac UniQuery clone access violation
When I use a TUniQuery and perform a CloneCursor using postgres, If I pass "True" as the reset parameter, an access violation error occurs. Attached are the database and the demo file as an example.
Add a field named index to the DBF table
There is a dbf table with a foam structure. It is necessary to add a field with the name index. Variants UniQuery->SQL->Text ="ALTER TABLE \""+System::Ioutils::TPath::GetFileNameWithoutExtension(OpenDialog->FileName)+"\" ADD COLUMN &fldname CHAR(10);";
Issue Unigui / SDAC
I have a problem that occurs with Unigui with SDAC I have two forms, both have a grid connected to a Query (TMSQuery to be exact). I open a popup and select a record, but when I close it, the first form record always moves to the first record. 1- Prepare
Continuous MFA Prompts
Highlights: Linux Server / MySQL / MariaDB / PHP 7.4.34 (upgrading soon!) Windows Client (current version) Connection Type: TCP/IP with SSH and MFA (prompt to my phone) Trial version Issue: I connect just fine and can see everything. However, when I do
Postgres: Performance-Issues after updating from UniDAC 9.4.0 to 10.2.1
Hello, we massive perfomance issues after updating to your newest version. For example: TUniTable (default settings), TUniConnection (already connected), Table with 621 Records - Version 9.4.0: Open returns after ~25ms - Version 10.2.1: Open returns after
Salesforce ODBC forgets about it's license every few months?
I own a valid license and am using it on a Windows 2022 Server running on AWS. It mostly works, but every few moths it seems the driver loses the license and I get errors like this when running queries through my Microsoft SQL linked server setup: ```
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
PostGres reserved Word
Hi, I'have a table with field INT1,INT2,INT3. On Oracle if I worte SELECT * FROM MyTable WHERE (INT2 = :INT2) it work fine but in postgres params.count = 0, INT2 is a reserved word in Posgres. It Works if I change the query in Format('SELECT * FROM MyTable
SecureBridge: Prevent File Creation with TScSFTPServer
I am uploading files with a SFTP Client to a TScFTPServer, but I want to process the stream directly without creating a file alongside it. I tried overriding OnWriteFile, but then an empty file gets created, which I want to avoid. It seems like OnOpenFile
UniDac with Quickbooks QODBC - Enterprise
I am trying to use the QODBC driver to create a "simple" report for Positive Pay for the bank using Delphi, UniDac, and QODBC. I can connect to the QB DB, but opening the BillPaymentChecks table only returns ONE record. Presumably the top/first record.
Connecting to Oracle Autonomous instances with Unidac
Hello, We are using Unidac in Delphi 11 to connect to Oracle Autonomous instances in Direct mode but we can't get it to work. If we give "adb.region.oraclecloud.com" as the server and valid user/password credentials, we receive the following error: ora-03113
UniDac DBF Direct Connection - PACK Table
In the UniDac documentation, in the native DBF provider section a mention is made that PACK-ing of DBF tables (files) is supported. Searching the source code I came upon the TDBFDBase class which implements the PackTable method. I tried to use it by creating
UnpreparedExecute not set for migrations
Hello, I have ran into issue with dotConnect for PostgreSQL with EF Core. After adding a custom script to a migration, i get a Devart.Data.PostgreSql.PgSqlException with a message "cannot insert multiple commands into a prepared statement". I have the
Unidac - MSSQL - Linux
Hi everyone I am migrating a REST application (DMVC Framework) that uses Unidac to access a MS SQL Server 2022. When executing a query with data containing accented characters, all of them are replaced by "?". When compiled and executed on Windows, the
Ongoing problems with TIMESTAMP datatype
Hello, This problem with timestamps in the TZR format still exists in the latest version. https://forums.devart.com/viewtopic.php?t=36016 Similarly, I have had this request for years (the ability to configure time stamp format) https://forums.devart.com/viewtopic.php?f=5&t=44301&p=178343&hilit=tzr#p178343
SDAC Connection Pooling with TWebModule in Linux environment
We are trying to evaluate whether we can, and exactly how, we can use connection pooling with TWebModule in a Linux env (Apache specifically). We have essentially stripped all threading from our application as it does not seem to play well under Linux.
Assertion failure - Devart on Delphi 10.2 Tokyo
Hello, I am having trouble using Devart to connect to PostgreSQL. I am currently using Delphi 10.2 Tokyo and C++ Builder 10.2 Update 2. The error message is: Assertion failure (D:\Projects\Delphi\Dac\PostgreSql\Source\PgClasses.pas, line 4195). I would
Next Page