Can ODAC connect in Direct Mode with Kerberos?
Hello, Our application has an option to use ODAC either in Direct Mode or using an Oracle client. When a client is used, customers can connect using Kerberos without any problems. That is, once it is configured in SQLNet.Ora and the Kerberos configuration
IBDAC : TIBCQuery and TIBCEncryptor
Hello, TIBCEncryptor work fine with a TIBCQuery connected to a Grid or if you do Dataset.insert or dataset.post. But it's doesn't seem to work if you add record with a TIBCQuery using execSQL like this ? MyQuery:TibcQuery; MyEncryptor:TibcEncryptor; ...
Version Control on Script Files for Oracle
Other Devart Tools allow for Source Control on Script Files but not for Oracle? Also there is no Schema Compare to Script Files, this is a major missing component. This allows Redgate to monopolize the market and charge $140,000.00 for a 50 user Enterprise
SDAC SQL Server 2022 (express) - Connection forcibly closed (10054)
I have just released a new version of our main product to a select few customers, and I've already received a bug report with the following error: Error on data writing to the connection: An existing connection was forcibly closed by the remote host.
SQL Server 2022 - Native Client
Hi I've read that the native client isn't recommended for new projects. I currently use SDAC and use prDirect as the provider, but I wondered, what your plans are for the prNative option? Thanks Chris
Advice for using VirtualQuery
Hello, We are developing software under Embarcadero Sydney with TUniQuery component on Firebird or SQL Server DataBase. We have noticed that using a VirtualQuery is much faster (especially when sorting). From there I have two questions : 1. Question ----------
Add Stored Procedure fails in DB First, unless trivial contents
Firstly, there seems to be no Support Category for Entity Developer. I hope that's not a reflection of the support for that product?? Most of the time when I attempt to add existing Stored Procedures to the model, the process fails when retrieving result
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
Review Assistant freezing/slow
Hi, We're currently evaluating Review Assistant with a small team, however are noticing substantial timeouts and poor performance (long delays/stalls) when adding a comment, or (for example) changing the filter from "All Reviews" to "My Reviews". We are
TScFTPClient - SSL Negotiation Command is Failed
Our company recently purchased your FTP components and I'm using TScFTPClient to try and connect to an FTP server with TLS. I can call the client's Connect method OK, but when I attempt to use the Login method, I get an error message stating, "SSL negotiation
An error occurred when receiving wrapped code for the 'LOCUS.INC' object: ORA-06550: line
I get this error when I do a schema compare between 2 databases. An error occurred when receiving wrapped code for the 'LOCUS.INC' object: ORA-06550: line 13, column 37: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 13, column 7: PL/SQL:
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
EntityDeveloper EF Core 6 version creates modelBuilder....UseTptMappingStrategy(); which not supported by .NET 6
If I remove the code line, is it possible that EF Core does not work correctly?
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
dbForge Monitor v7.0 w/ SSMS v20.2 on Windows 11 - Microsoft.IdentityModel.Clients.ActiveDirectory error
I've installed the latest dbForge Monitor v7.0 (7.0.158) on my Workstation SSMS install. It installed with no errors and SSMS starts up and connects to a remote server with no errors. When I try to activate "Monitor / Show Monitor" I get the following
V7.0.158 has broken Intellisense support when working with SQL Queries
Myself and another developer in my company upgraded from v6.x to v7.x and now intellisense for selection of Tables/Fields via the dropdown in the SQL editor no longer work? The dropdown shows completely unrelated options and NONE of them help with table/field
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
Importing data into a temporal table requires default value in PeriodEnd, PeriodStart
The PeriodEnd and PeriodStart columns in an SQL Server table are designated as "Generated Always." No default value can be provided. Because Data Pump identifies the columns on the table, a default value is required. How can I import data into a temporal
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
Bug: dbForge Studio for MySQL Professional Edition 10.0.225 - Problem with Order By query results in Data window if columns were previously manually sorted
Running a query with Order By in the Text window does not produce correctly sorted results in the Data window if the columns for the table were already manually sorted from inside the Data window. Selecting "clear all sorting" in the Data window of a
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);";
Next Page