• I can't copy anything from the results from dbForge Search

  I can't copy anything from the results of dbForge Search. There's no right mouse click menu and when I hit ctrl-c I get this error message.

• SSIS Components for MySql - SSL CA Cert - How To Use?

  Hello, we have a MySql Database that we'd like to connect to. The database asks us to activate the following property: require_secure_transport=ON Where can this property be set? Also, which format is requested in the "SSL CA Cert" option in the manager

• [DEVART][ODBC][PostreSQL]Trial period is expired

  hi, last year i tried devart odbc driver for postresql on a server with windows2012 R2, it was for a POC with an instance postressql for test. now i want to industialise solution and before buy devart odbc driver, i want to try access on the same but

• TSmartQuery SQLTYPE property sometimes 0 when in Direct Mode

  Hello, When in Direct mode, and running certain SQL in a TSmartQuery, the SQLType value is zero. Some examples are: CREATE INDEX test_ind ON TEST_TBL (EMPNO); ALTER TABLE TEST_TBL ADD (ddd DATE); It works correctly for these statements: create table test_tbl

• Error "System.InvalidOperationException: Transaction already exists."

  Hi, That error has already been mentioned here, but no solution. Wen can reproduce by doing this: //-------------------------------- try { //--step 1 try { Data1 dat1 = new() { field1 = 1, field2 = 2 }; ctx.Add(dat1); ctx.SaveChanges(); } catch(Exception

• No DbUpdateConcurrencyException when OracleDbContextOptionsBuilder.MaxBatchSize > 1

  Hi, we have an issue while enforcing optimistic concurrency in combination with an OracleDbContextOptionsBuilder.MaxBatchSize greater than 1 (eg. 50): there is no thrown DbUpdateConcurrencyException when there should be one. How to reproduce: Create an

• Query Profile Mode but???

  Hello, I am in try version with dbForge for a new project using postgresql database. I see you have query profile mode but I don't see catching statement when I process from my UI. What I mean, is it possibility to catch all incoming statement like SQL

• SQL Server Always On feature

  Do SDAC components for Delphi support SQL Server Always On feature? The "FailoverPartner" property was added for mirroring, but I am not sure if it would work with Always On.

• Alerter on Postgres

  HI. We have set up an alerter in Postgres (15) on linux ubuntu 22.04. The alerter works when we listen in psql on the server, but placing the Unidac alerter on our server application doesnt seem to do anything. I have put log messages in both the onerror

• ODAC (direct mode) non-blocking

  I am having an issue with ODAC non-blocking queries. Expected result: The .open method returns immediately. Actual result: The .open method does not return until the SELECT has completed the non-data transfer part of query. In practical terms, that means

• TVirtualQuery Float field loaded as memo

  Hello, I have a DataModule that I use to do some calculations and eventually display a chart. I have a TTable component with 2 Float fields (Rate and PieceRate). I assign this table to a TVirtualTable (vtPools). There are other tables as well. Next I

• Is there a bug in SDAC Component ?

  Field of type Data is treated as a widestring when the application runs on a computer other than the computer on which SDAC is installed. each reference to a date field generates string to date conversion errors, ONLY on the computer where delphi (XE")

• Old DLL Reference (Devart.Data.PostgreSql)

  Hello, in my Web Forms App I did upgrade to current Devart DLLs but there's somehow a hard reference to an older DLL and the only way I could solve it, was by using a DLL redirection - see below. Here's what I tried to solve it the right way: - I removed

• SQL Schema Compare between revisions of TFVC

  Im using Source Control on TFVC. When I'm trying a comparison between different changeset, the source is always empty and the result is a drop for every object in the target. For example between head and changeset 5 there's only a change But the tool

• SecureBridge wws certificate validity

  I am trialing SecureBridge WebSocket client. when I connect to a test server with wws the response from the server is "the certificate is not within its validity period". this is just a dev/testing environment so you can I for testing accept the error

• Issue when migrating data

  Hello, I face this error message for every table inside my schema. although I just created the schema structure only and all tables are empty. I did this step while leaving it without tables and let dbforge create the tables, miss the already configured

• please add support for mariadb 10.11.2

  thanks

• SQL commands of dbForge Studio for MySQL GUI's backup action

  Hi all, Is there a way to read what is the SQL commands of action click in dbForge Studio, like a backup click action on database backup and restore page? Regards, bobojin

• "Auto refresh" when adding

  Hi guys, This is a feature request (or a bug report?), it's been years I haven't had one due to your tool being too complete ;) When I create a new table, database... I have the refresh the database explorer. It'd be great if once the creation has succeeded,

• execute procedure via dbforge studio give error cursor does not exist.

  While executing the procedure via dbforge studio, it gives an error: Cursor <cursor_name> does not exist. But the same code runs in pgadmin, and it's working fine. call ea.usp_procedure_name(parm_1,parm_2,'ref_result_data1'); fetch all FROM ref_resu

• Expecting Devart.Data.Oracle.OracleConnection but got Devart.Data.Oracle.Entity.av when using DbConnectionInterceptor

  Version used: Used NuGet Package in .net 6 Project: Devart.Data.Oracle.EFCore 10.1.134.7 Problem: I need to Intercept the DbConnection to set some metadata but when using Microsoft.EntityFrameworkCore.Diagnostics.DbConnectionInterceptor instead of getting

• [Devart][ODBC][Adaptive Server Enterprise]Invalid activation key ??Trial version

  hello, We have successfully installed and efficiently configured Devart on our iMac M1 with the latest operating system, Ventura 13.4. As we opted for the trial version, we encountered a minor setback during a connection test—a vexing error message appeared:

• Wrong number or types of arguments in call to 'SF_GET_CLIENTS_QUERY'

  Hi Team, Facing this error, when we try to call a specific Oracle function, which has a input of type Table. there are no other mismatch on the number or type of arguments. Issue only when we use this particular parameter(atbl_client_nr). Below i have

• TCREncryptor support for more modern hash function

  i was looking to use TCREncryptor with unidac and noticed that it only supports deprecated hash algorithms - MD5 and SHA-1. Are there any plans to support sha-2 (I.e SHA256) as well as hmac based algorithms in unidac soon ?

• Configuring a stored procedure with return values

  I am new to UniDAC and am trying to configure a TUniStoredProc for a stored procedure with return values. I have managed to do this in code using CreateProcCall(<procedure name>), but I would like to know how to do this by just configuring the component

• dbForge doesn't recognize null. It has to be "null"

  I am having several issues when importing from a json file when using dbForge version 6.4.7 - I have the setting to ignore errors yet dbForge imported nothing. - I attached the log file. The file mentions Row: 201. If it read 200 rows successfully, why

• I'd like to ask you to cancel my subscription

  Hello. The automatic renewal was checked at the time of purchase last year, so the product that was not scheduled to be used this year was automatically paid. I'd like to cancel my subscription, can I know how?

• Slow connection using Dbeaver and ODBC <> BigCommerce Connection

  We're looking for a solution to connect to BC using ODBC for my team. We managed to get the connection working but its unbelievably SLOW. Like 2-3 minutes for a select statement. We have enterprise BC so we shouldn't have any rate limiting issues, is

• Unidac 9.3.0, Delphi XE2 ver 16.04, Oracle EE with TDE, ORA-00600

  Hello, I am using UniDac version 9.3.0 with Delphi XE2 Version 16.0.4504.48759 on an oracle database 19c Enterprise Edition with TDE configured. I have a table with two columns crypted. Here the script I've used: ALTER TABLE utenti MODIFY (USERNAME ENCRYPT

• Multiple Query

  Hi I have a following problem: trying to utilize multiple query feature but getting error about incorrect sql syntax (ORA-00933). I want to pass few sql queries into one command, then execute reader, fetch data from first query, then call NextResult and

• Cancel Subscription

  I'd like to cancel my annual subscription for MySQL Database COmponents. Where can I do this?

• How to make Code Compare Ignore closing/opening braces openings or endings?

• facing issue as Cannot describe stored procedure arguments

  Hi Team, we are facing the same issue which is mentioned in below link, this is created around 2 years ago. Do not find any solution/fix provided. please help in understand the resiolution required. For reference we are adding the Procedure for reference.

• Unable to create entity model

  Hi, Using Visual Studio; When I try to add a new Devart Entity Model; I can create a model using the thick client app and open it in Visual Studio but the entities are not generated and I do not see Run Custom Tool.

• Как правильно работать c компонент Encryption Unidac Firebird3?

  Добрый день Подскажите пожалуйста как правильно работать c компонент Encryption Unidac Firebird3? то что работал Ibdac перестал работать Unidac База Firebird 3 тип поля VARCHAR(2000) CHARACTER SET OCTETS COLLATE OCTETS В Ibdac работает но в Unidac после

• Snapshot functionality or getting sqlite3* connection handle from SQLiteConnection

  I need the snapshot functionality offered by SQLite as described here: https://www.sqlite.org/c3ref/snapshot_get.html but in context of a SQLiteConnection in turn used with Enity Framework 6. As far as I can see dotConnect for SQLite does not support

• IndexFieldNames

  Hi, I need "natural sort" as a sorting algorithm to use with IndexFieldNames. For natural sort see: https://en.wikipedia.org/wiki/Natural_sort_order I have an article number field as varchar. Some of my customers have article numbers with mixed letters

• Is there a way to extract whole postgres schema without the data ?

  Hello I am looking for a solution to extract all my postgres schema to a file. DDL format would be nice. Thank you for help!

• Installation Questions

  I am installing dcoracle101pro.exe on a server that functions as a development environment as well as a production web server. When I attempted the installation it said that it was going to remove any old versions and I told it to go ahead and then another

• Export results from dbForge Search within SSMS

  Hi I've done a search for the name of a table, and have a list of around 40 results. I need to go through each of these items and check / update some code. However, I'm not going to get it all done today, so I'd like to export the list of results to a

• Next Page

• Most Discussed Topics

• A collection of enum array values get translated as (NULL, NULL ...)

  Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database

• memory leak

  memory leak problem is very serious,memory uses will continue grow to several GB level.

• Findkey in Cloned DataSet work?

  Hello, I would like to confirm a question. Does the FindKey method work on a cloned dataset? In my tests, it does not work. In the IBDAC documentation, a restriction is that the cloned dataset does not allow the use of filters. Is the fact that FindKey

• Feature Suggestions for dbForge Studio for PostgreSQL

  1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply

• Connect to MySQL with SSL and validate server certificate

  Hello I'm working with an Amazon RDS MySQL instance, and i'm sucessfully connecting to my db even when i'm providing a wrong certificate in MySqlConnection.SslOptions.CACert I only have CA certificate, no client certificate. How should I force the verification

• Popular Topics

• A collection of enum array values get translated as (NULL, NULL ...)

  Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database

• memory leak

  memory leak problem is very serious,memory uses will continue grow to several GB level.

• Feature Suggestions for dbForge Studio for PostgreSQL

  1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply

• Connect to MySQL with SSL and validate server certificate

  Hello I'm working with an Amazon RDS MySQL instance, and i'm sucessfully connecting to my db even when i'm providing a wrong certificate in MySqlConnection.SslOptions.CACert I only have CA certificate, no client certificate. How should I force the verification

• Newer Version of SQL Complete Breaks Stream Deck Macros

  Using SSMS 20.2. Stream Deck https://www.elgato.com/ca/en/s/welcome-to-stream-deck is a piece of hardware or an app that hooks up to your PC and provides extra macro keys. I have text strings assigned to some of these macro keys. Until SQL Complete v7.0.362

• 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 Install MySQL on Windows Using MySQL Installer

  The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with ...