• 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
  • 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
  • Support .gitignore in dbForge Source Control (Feature Request)

    Please follow .gitignore for SQL Objects. For instance, we have a convention to deprecate objects by prefixing them with "zzz_old_YYYYmmdd" and then waiting a few months before finally deleting them. Source Control doesn't follow the .gitignore file so
  • 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
  • Error Adding DevartNHibernate Model

    Hallo I'm using Visual Studsio Community 2022 And Entity Developer I uninstall it and check the Template Folders for existing ZIP Files and reinstall it with Admin USer Rights. But with the NHibernate Template I get this error: The EF Core Model works.
  • 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
  • Encrypted data is corrupt

    I am considering purchasing a SecureBridge license to use in an older project developed with Delphi 7, I have installed the trial version. But this code gives error: Encrypted data is corrupt procedure TForm1.Button1Click(Sender: TObject); Var Request:
  • 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.
  • SQL Complete - Management Studio 20?

    I just migrated to a new machine, and by default installed the current release of SQL Server Management Studio, which is version 20.0. When I installed SQL Complete, it doesn't add itself to SSMS; is this because version 20 is not yet supported? If this
  • Keep getting an exception of "ORA-00971: missing SET keyword" where SET keyword is there.

    Hello friends, I keep getting an exception of "ORA-00971: missing SET keyword" for the following source code. I have no idea why. As you can see, it has SET keyword. Any ideas? Thank you so much! try { OracleConnection connection = new OracleConnection(_connectionString);
  • How can detect which driver is used by active TMSConnection?

    Hello, How can detect which driver is just used by active TMSConnection from code.. For example if is used Native client 11 or Native client 10 or Ole db provider, or SQL server OLE DB driver 19 or 18....... etc... need something like this showmessage('Iam
  • SQL Complete Support for Synapse/Serverless

    We are moving our SQL Servers to Synapse/Fabric, and are using the Serverless options. However SQL Complete does not work with these. Are there any plans on making it compatible?
  • 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 ...