• 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

• 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

• dbForge SQL Monitor documentation

  Hi, in the support page I can Read <<For a complete description of the tab, refer to the Top Queries, Monitor Window topic>> So where are these complete descriptions of functionality? Thanks a lot

• 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,

• SFTP Client Timeout

  Hello, We have an application which uses an scSFTPClient component to transfer files to our bank. This program has been in use for years and never had a problem. Today, we had two files fail due to a reported timeout. Our timeout value is set to 30. After

• 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.

• Where is the TCRSSHIOHandler component?

  Hello, I would like to use SecureBridge to recreate your example Connecting to MySQL Through SSH in Delphi in Delphi. Unfortunately, I do not have a TCRSSHIOHandler component. I am working with D12.1, dbForge Studio for MySQL Professional, SecureBridge

• 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

• How to properly sync sequence values from production to development?

  I synchronize the Oracle Database 12c R2 from production to development weekly. However, I am encountering a problem where the current sequence values from production cannot be synchronized to the development instance. Is there an option in the wizard

• Can't start win64 version

  When I start the win64 version, the following error message is shown and the Entity Developer does not open.

• 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

• Visual Studio Error

  I get the following error in VS 2022 any help would be appreciated:

• Evaluating SQL Source Control - Linked server on Get Latest

  Hello! I am trying to run a get latest command in the Source Control module - there's 1 stored procedure it's trying to update my local DB with that has a linked server. The linked server does not allow distributed transactions and I saw that the tool

• 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

• ScHttpServer and ResponseInfo.OutputStream

  I would like to know what is the best way to use the ScHttpServer component to return an Outputstream. I have the following code in ScHttpServerProcessRequest, and it works, but when I release the stream, it stops working. try fs := TFileStream.Create(

• Cant get ScSSHClient to work with key - not even following step by step instructions

  Hi, I cannot get the ScSSHClient component to connect when using a key instead of a password. I've been trying out these steps: https://docs.devart.com/sbridge/index.html?client_configuration.htm Here's what I've done: create SSH server on Ubuntu, connecting

• 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

• Trouble installing SQL Source control add-ins for SSMS

  Hi all, Trying to follow the steps in the installation guide to evaluate this vs redgate, and the first bump is that the download link for source control goes to the DBForge SQL Tools download, and not a standalone installer. Ok, fine. I install the full

• 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,

• Trouble reading response from websocket connect/call

  Apologies for the newbie question, but do you have sample code on how to parse the OnMessage data array to a format that I can read into a memo field? Thanks! - Robert

• 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

• Can't install SQL Search version 2.7.25 for SSMS version 20.0

  Hi, This is the error that I get. With SSM 19.X, it's working.

• How to delete a Db in dbForge Studio for Postgres

  How can I delete a database in dbForge Studio for Postgres (without running a command) I don't see such an option when I right click database

• 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

• dbForge Studio: Is it possible to work with diagrams (*.DBD) without being connected to a database?

  Hi, I am trying out dbForge Studio and would like to use its DB Design features without necessarily being connected to an instance of SQL Server. Is this possible? Thanks and regards, Mario

• How to draw/sync db with ER Diagram?

  We are evaluating DBForge Studio for PostgreSQL, and in a prior position while using the DBForge for SQL Server, I saw that it had a ER Diagramming tool. Since PGAdmin is so very basic and lacks much, I was hoping to make up for that deficit with DBForge

• Next Page

• Most Discussed Topics

• The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.

  I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created

• Oracle - EFCore - Hints

  Hi, I am trying to use OracleFunctions.Hints("ALL_ROWS") in a project that is using Devart.Data.Oracle.Entity.EFCore. What is the recommended way to add Oracle optimizer hints in EFcore ?

• Invalid Typecast exception on Insert/Update blobs

  Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++

• Advice on which Unidac components to use in android app

  I have a small personal android app which accesses a sqlite database with several tables. The app is single user, no db sharing. Only one table open at a time. Browse, add, edit, delete, search. I currently am trying out a TUniconnection, and a TUniQuery

• Virus scanner alarm - Trojan found

  Hello, this morning I received an update message for the installed test version of SQLTools. After downloading the sqltoolsent.exe file from the download area at devart, I started the installation. Unfortunately, I received the following messages from

• Popular Topics

• Invalid Typecast exception on Insert/Update blobs

  Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++

• The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.

  I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created

• Virus scanner alarm - Trojan found

  Hello, this morning I received an update message for the installed test version of SQLTools. After downloading the sqltoolsent.exe file from the download area at devart, I started the installation. Unfortunately, I received the following messages from

• Sql Complete v2025.1.134 won't switch to express license

  I updated to v2025.1.134 for SSMS 21 but somehow my Express license was reset and I'm now back in the "Enterprise" license trial mode. The previous solution of setting HKEY_CURRENT_USER\Software\Devart\dbForge SQL Complete\Activation\UseExpress to 1 isn't

• Change order of ApplyUpdate

  Hi Using CachedUpdate I need to have the delete statements to be fired before the inserts, is this possible? if not, i try to delete the deleted records before i can applyUpdates, but when i call apply after that i get error record to be deleted cant

• Popular Articles

• How to Download and Install a Previous Version of the Product

  If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...

• How to Connect to MySQL Server

  In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

• How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools

  If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...

• Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce

  When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...

• How to Activate a Trial Version in dbForge Products

  Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...