• TUniQuery - Prepare and IsQuery on PostgreSQL

    Hello. Does Prepare and IsQuery methods (of Query) work on PostgreSQL database? I'm using Unidac 9.3.0 on Delphi 11.1 Alexandria. Simple code like the one I've posted, works on Firebird, Oracle, MSSql server, but not working in PostgreSQL (PG version

  • Query/Table SavetoXML with large datasets

    First, let me say this forum looks awful. Anyway, I am using uniTable.SavetoXML(name of file) and it is generally working fine - on small tables. With large tables I get an 'Out of memory' error. the system seems to be loading the whole table into memory

  • Memory leak in SecureBridge connection to a signelR hub

    Hello, I have detected a memory leak in SecureBridge connecting to a SignalR hub. The memory leak is produced on each unexpected disconnection. The error can be traced in a simple way. 1. Connect a hub client to any server hub in IIS. 2. Setup the hub

  • SProcs using ODBC for QurickBooks

    I'm trying to execute a sproc via a trigger to create a record in QuickBooks.... I'm getting "OLE DB provider "MSDASQL" for linked server "BT_QB" returned message "[Devart][ODBC]Optional feature not implemented". Doesn't the ODBC drivers for QuickBooks

  • How to ignore INITRANS with Oracle Schema Compare?

    I'm comparing an 11.2 database to a 19.0 database. In the comparison view, this is the 11.2 db: and this is the 19.0 db: And this is the relevant part of the sync script: How can I eliminate INITRANS from the comparison?

  • In Version 6.0.3 is impossible to run transaction RO

    Dears according to information provided by you I am starting read-only transactions by this command KPTrans = KPSessionName->BeginTransaction(5); It works perfectly till version 6.0.2, but the last version 6.0.3 doesnt work, and stay in RW transaction.

  • Is it possible to keep the parameters of a file downloaded through "ScSFTPClient1.DownloadFile"?

    Is it possible to keep the parameters of a file downloaded through "ScSFTPClient1.DownloadFile"? Example: The A.zip file has a creation date of 2/5/2007 on the server. When downloading it, the downloaded file is having as current creation/modification

  • connectionstring, connnection properties and localdb

    Hello, have con.ConnectString:='Provider=SQLNCLI11.1;Integrated Security=SSPI;Initial Catalog=somedatabase;Data Source=(localdb)\mssqllocaldb'; this works correctly. When i want to set this values as properties of object con (TMSConnection), i did not

  • Delphi 11.2, AnyDac 9.3.0, ReportBuilder 22.0

    Hi. Trying to compiler rbUniDAC.dpk using Delphi 11.2 / AnyDac 9.3.0 / ReportBuilder 22.0 got the error message below: [dcc32 Fatal Error] daUniDAC.pas(21): E2411 Unit ppPDFDigitalSignatureDlg in package rbRCL2228 refers to unit Vcl.CustomizeDlg which

  • DBGrid Postgres

    Hi, I've a problem to show some string in DBGrid Column number 3 si not show I have (MEMO) instead. My query : RequeteRapportAEnvoyer.Sql.Text := 'SELECT A.IN_TYPE,A.S_ID,A.IN_ID,A.IN_DATE,CAST(TRIM(CONCAT(CONCAT(B.T_PRENOM,'' ''),B.T_NOM)) AS VARCHAR(100))

  • firebird 4

    from what version can i connect firebird 4 i have the version 4.2.3 wil wok

  • Firebird 4

    from what version can i connect to firebird 4

  • User defined functions in Entity Framework Core 7.0

    Hello. I'm porting my code from "classic" Entity Framework 6.4 to Entity Framework Core 7.0. What is replacement for the following code (User defined functions setup)? Most classes doesn't exist in both Devart.Data.SQLite and Microsoft.EntityFrameworkCore

  • Assert error in UNIDAC

    Hi Connecting to postgres through UNIDAC. Query is taken from DB monitor. Insert to same table with same fields works fine. query : update eeli_1.t1009_packages("t1009_id","fd","td","t1002_id","t0106_id","package_name","start_sn","stop_sn","bar_code","user_id","in_date","comments","unit_name","s_id","pd_id","del_user_id","del_in_date","min_unit_name","code","min_unit_count")

  • .Net 7 support

    Do dotConnect for Oracle support .Net 7? If not when will you will support it? Thanks.

  • Devart.Data.MySql & .NET 7 support

    Hello, .NET 7 is out and we would like to upgrade our projects. Unfortunately the Devart.Data.MySql.EFCore package seems to not be compatible with it. Do you plan to have a compatible version any time soon ? Regards

  • Entity Framework Core 7 (EF7) / .NET 7.0 support

    Hello, are there any estimates when Entity Developer will start supporting Entity Framework Core 7 (EF7) and .NET 7.0? Thank you

  • SLOW START DELPHI APPLICATION

    Hello, My Delphi Embarcadero application uses TUniQuery, to access 2 Interbase Tables, and TUniTable to access 2 DBF Tables. The application is getting slower and slower and slower when starts, more than 2 minutes. Every day is slower than the day before.

  • PostgreSQL 15.x support

    Does anybody use the current version with the latest PostgreSQL 15.x versions? I'm still using 13.x and I have to migrate a server. So I just want to be sure, if there may be any issues UniDAC - PostgreSQL 15.x? When will there be a release with offical

  • Firebird ODBC driver can't open table using with BDE on Delphi11.2

    When open database I tested Firebird ODBC driver using with BDE on Delphi11.2. I get error when openning TTable, "Dynamic SQL Error. Column unkown ID at line 1, column 8." I create database on Firebird 3.0.10, then create OBDC DataSoure using ODBC administrator

  • Relation Many-To-Many from Diagram Devart version 7

    Hi all, I am working with the latest version of devart 7, with .net core 6 MVC, Visual Studio 2022 and with Sql server 2019. I need to relate two Many-to-Many tables and in the middle table I need to add more fields besides the two Ids of the related

  • BigQuery ODBC driver | Data truncation

    Hello, My company has recently purchased and installed the ODBC Driver for Google BigQuery. We are pushing data from BigQuery into a SQL Server database. It is working well for small datasets, however when we try to query for large datasets (e.g. 2 million

  • The new forum is awful and totally unreadable.

    Hello, The new forum is totally unreadable. - posts are mixed between components, - number of post about UniDac since the new forum started seems to no showing all posts (only few posts) , - the topics are not organized i table (ie no columns for viewers,

  • Deployment issue, System.TypeLoadException

    We recently updated our web application from dotConnect for MySQL 8.17 to 9.0.0 (with EF5). Everything works fine on dev machines but not when deployed to the web server (Windows Server 2012): System.Data.EntityCommandCompilationException: An error occurred

  • On Save of a view the editor / formatter adds backticks (grave accents) around names - How do I stop this?

    Hi guys, When saving a view, the auto formatted adds backticks (`) around object names eg. `ea`.`ParentEntityId` AS `ParentEntityId` I want to turn this off (unless necessary, like a name with a space) so the line reads like; ea.ParentEntityId AS ParentEntityId

  • SQL Query Hangs when adding anything beyond Select *

    Using the Excel Add-in to pull and refresh BigCommerce sales data for orders with status = 'shipped' when selecting columns for a preview, the query executes fine. However, when adding any filters/order by logic, the query is stuck on 'executing query'.

  • dotConnect for postgresql 8.0 not compatible with NetTopologySuite?

    I used dotConnect version 7.17 with NetTopologySuite 1.14 + GeoAPI 1.7.4. I update dotConnect to version 8.0. Now I can't run my application: When I compile I have the warning warning MSB3277: détection de conflits non résolus entre différentes versions

  • Inconsistent metadata - Connecting to Firebird from SQL Server Management Studio using ODBC Driver for Firebird

    We have a Firebird 3.0.8 database we want to add as a linked server to SQL Server Management Studio. We downloaded the 'ODBC Driver for Firebird 3.3' and created a ODBC Data-Source: The database used in this test is a clean firebird 3.0.8 database with

  • MySQL 8.0+ : Compare and Generate Schema without Integer Display Width

    As noted Old DevArtForum topic "Integer width deprecated" > In mySQL 8, there is a Warning, when creating a field with integer incl. precision. > "Warning: #1681 Integer display width is deprecated and will be removed in a future release." Can DevArt

  • Output the Search (Find a database object) to a file, table, excel, clipboard

    After doing a "Search" (Find Database Object) thru my database, I'm unable to copy the results. Is this just not possible? Or, do I need to request a feature/enhancement?

  • Is it possible to convert back from EDML to EDMX?

    Is it possible to convert back from EDML to EDMX? If so, what are the steps? I'm in a situation where I have to change one of our applications back to just using ODP .NET Data Provider and Entity Framework 6 default in Visual Studio.

  • How i can know if specific File Exists on server?

    Hello again, How i can know if specific File Exists on server with ScSFTPClient? I need to check if a specific file exists or not on the server. How can I do it?

  • Question/Problem dbForge keeps asking for an old connection when opening .sql file

    In the past I have used another connection to work with dbForge. The connection has changed, I removed the old one from the database explorer and even when I'm using the new one, when opening a .sql file it keeps asking for the old one and I have to manually

  • SSH Connection with Public key not working

    Hello, I am using dbForge Studio 2022 for MySQL Enterprise Edition 9.1.21 and trying to connect to a MariaDB server on a remote Arch Linux server via SSH. On that server, SSH is configured to accept public key authentication. When using the standard Windows

  • Setup Linked Server in MSSQL Server with ODBC MySQL driver

    Hi, currently I'm trying to setup a linked server connection in Microsoft SQL Server 2019 to access a MySQL Database via the ODBC driver. I've followed Connecting SQL Server Management Studio to MySQL via ODBC (devart.com) & Windows DSN Configuration

  • sFTP with Progressbar

    Hello, I need a example of "ScSFTPClient1.DownloadFile" and "ScSFTPClient1.UploadFile" with a Progressbar do view the progress of file transfer. I Appreciate your attention.

  • Error in demo for SFTP

    Hello, I'm trying to understand how the SFTP component is working, but í get some errors when running the demo. Please advice.

  • dbForge Enterprise via MySQL

    Hi, I am on the process of migration using the copy database. Picture for reference. I am stuck with those red line that have percentage and not showing errors to troubleshoot. Btw, I am using a free trial and plan to buy license but i am testing it

  • How to ensure TScSSHClient and TMyConnection both open and / or close at the same time

    I like the way opening a TMyQuery automatically opens the TMyConnection that it is connected to. Does TScSSHClient do the same thing? ie if I have TMyConnection. IOhandler -> TScFileStorage.Client -> TScSSHClient will calling TMyConnection.Connect automatically

  • How does the securebridge demo know which key is the one downloaded from the server?

    I have eventually managed to get the securebridge demo (Documents\Devart\MyDAC for RAD Studio\Demos\TechnologySpecific\SecureBridge\Demo) working after deleting references to IdeVer.inc. I am now trying to understand how it does the things the sample

  • Next Page

  • Most Discussed 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++

  • How do I show the Functions/Procedures within a Package

    I'll be respectful since I'm a user that has used Oracle Toad for probably 20+ years. The list below are features available within Toad and I don't see how to accomplish these tasks within dbForge Studio for Oracle. How do you display the Functions/Procedures

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

  • Will dbForge for Postgresql filter out comments when submitting queries?

    Will dbForge for Postgresql filter out comments when submitting queries? If filtering is applied, it is recommended not to do so, as certain features of Alibaba Cloud Polardb may become completely ineffective. pg_hint_plan - PolarDB - Alibaba Cloud Documentation

  • 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

  • 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

  • Connecting to a PostgreSQL database using SSL when the server requires SNI

    Hello, We have a problem connecting to a certain cloud PostgreSQL database using SSL, because the server requires a server name indicator (SNI). We tried the both connection ways described in the "Connection to PostgreSQL through SSL in Delphi" manual

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