• Expand all SELECT *'s in large query

  At my job I have inherited a large (13000+ line) query with numerous unions of the form: SELECT * FROM a UNION SELECT * FROM b. We are running into an issue where a and b can end up with different column orders causing this to fail. This is further complicated

• InterBase Data Access Components 8.3.0 / Delphi XE8, Exe-File corrupted

  - Download InterBase Data Access Components 8.3.0 for Delphi XE8 - File cannot be started - Error Message "The source file is corrupted"

• SSHServer Demo

  Hi, Is it possible to add a users home path to the demo? Thanks

• Updated to Entity Developer 7, Code generation default value not working for String

  Hi, We updated our version of Entity Developer from 5.8 to 7.0 and the code generation default value for String properties stopped working. It still works for ints. We are using EF6 Models with Sql Server, code first. Generates: However Generates: I tried

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

• Next Page

• Most Discussed Topics

• dbExpress Driver for SQL Server support for TLS 1.3

  Does dbExpress Driver for SQL Server supports TLS 1.3?

• SQL Complete not appearing in SSMS 20 on ARM64

  Running Windows 11 ARM64 and SQL Complete installs quite happily but then does not appear in SSMS20. SQL Complete does appear and function in Visual Studio 2022.

• Why Does dbForge Studio Say a Query has 302 Records Retrieved?

  Paginal mode is off. A query can return thousands or hundreds of thousands of rows but the grid always reports 302 until you start scrolling through the data.

• ODAC - base class for BeforeOpen

  Hi there. I'm trying to build an interposer class für TOraQuery. I couldn't find the correct base class, though. TOraQuery = class(Ora.TOraQuery) //TOraQuery = class(TMemDataSet) //TOraQuery = class(TCustomDADataSet) //TOraQuery = class(TOraDataset) //TOraQuery

• Stop tab rows from shifting in dbForge Studio

  I have "Show tabs in multiple rows" on. Is there a way to stop the tab row of a clicked tab from always being moved to the bottom row? It's not helpful having tab positions always being moved around and no other IDE I use does this.

• Popular Topics

• dbExpress Driver for SQL Server support for TLS 1.3

  Does dbExpress Driver for SQL Server supports TLS 1.3?

• Table Designer in dbForge Studio

  When the property pane has focus in the table designer, hitting Tab should go to the next property, not the script pane.

• SQL Complete not appearing in SSMS 20 on ARM64

  Running Windows 11 ARM64 and SQL Complete installs quite happily but then does not appear in SSMS20. SQL Complete does appear and function in Visual Studio 2022.

• TscSSLServer broadcast to clients

  I have a TscSSLServer with connected TscSSLClients. The Clients can send a message to the Server. And the Server can send a message to the Client in its AfterSessionConnect event. But if I try to send a message to the connected Clients via a forms button

• ODAC - base class for BeforeOpen

  Hi there. I'm trying to build an interposer class für TOraQuery. I couldn't find the correct base class, though. TOraQuery = class(Ora.TOraQuery) //TOraQuery = class(TMemDataSet) //TOraQuery = class(TCustomDADataSet) //TOraQuery = class(TOraDataset) //TOraQuery

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