• Opening reviewed file

    Hello, when reviewing file, it always opens some temporary file under AppData folder instead of that one in Repository Directory. Why is it so? Issue is that that one temporary file si missing its context and therefore I cannot easily navigate to definitions

  • UniDac - Delphi 11.3 - OpenSSL - Linux

    Hello Community, We'd like to upgrade our Ubuntu Docker containers from V 18.04 to someting newer. We'd also like to use newer SSL components, but it seems like UniDac (MySqlConnector) only works with OpenSSL 1.x.x. Can someone shed some light on that

  • OLAP Connection to Azure Analysis Services Data Cube on macOS

    On Windows we're successfully connecting an Excel pivot table to an Azure Analysis Services data cube using Excel's built in functionality. It generates the following connection string: OLEDB;Provider=MSOLAP.8;Persist Security Info=True;Initial Catalog=***;Data

  • Error while running schema comparison (PostgreSQL)

    Hello! The same error exists in dbForge Schema Compare for PostgreSQL and in the dbForge Studio. As I can see these both tools using the same files: Devart.DbForge.DbObjects.dll Devart.DbForge.DbObjects.PostgreSql.dll I have sent Error Report yesterday.

  • Exception when generating diff report for PostgreSQL from command line

    Evaluating schema compare tool using PostgreSQL 14.7 local databases. Can successfully generate HTML report from User interface, but same process is failing when generating via command line. We want to plug this into our build server pipeline, so command

  • Importing CSV with french boolean

    Hi, I'm testing dbForge studio for PosgreSQL. I'm trying to impot CSV file with french boolean value in a column ('VRAI', 'FAUX')... but it fails How can I handle that ? (PS : I cannot change the source CSV file)

  • What is Query API for and what does SQL_ATTR_MAX_ROWS allowing you to do? I have ZOHO CRM

    What is Query API for and what does SQL_ATTR_MAX_ROWS allowing you to do? I have ZOHO CRM

  • Oracle - Query Type class '____' cannot have primary key.

    In the Oracle Entity Developer, I'm getting this error on some tables: Query Type class '____' cannot have primary key. The table does have a primary key in Oracle, but it is a varchar column. How can this table be used?

  • Mac DevArt -> Postgres connectivity issues

    I've attempted to connect using the Devart Mac to Postgres driver. I've followed the instructions in the documentation. Upon hitting the test connection button I'm met with the error invalid activation key: I just downloaded the trial version on Friday

  • SOQL Query Syntax Issues

    Trying to get all fields from our ACCOUNT table limiting it by 200 and getting an error in SSMS. Syntax: SELECT * FROM OPENQUERY(XXXX,'SOQL:SELECT FIELDS(ALL) FROM Account LIMIT 200') (where XXXX is the Linked Server) OLE DB provider "MSDASQL" for linked

  • MSSQL Managment Studio can link to Zoho CRM, I can see all the tables but I cannot access the fields

    On the 2 ends Zoho and MSSQL I am the administrator with full privileges. -- [ZOHOCRM].[default]..[Users] contains no columns that can be selected or the current user does not have permissions on that object. GO Please see attached document.

  • Zoho CRM ODBC error when trying to update Subform

    I am trying to update the values in a subform. The subform data is in a string field of the primary form's table, formatted as a JSON array of objects -- each object being a row of the subform table. When trying to modify the field via an Update query,

  • Unknown Database error when running initial migration

    Connection string is: "Server=127.0.0.1;Database=MyDatabase;Uid=username;Pwd=secret;" Entity Framework Core 7 My SQL version 8.0.32 Initial migration is scaffolded using `add-migration`. However `update-database` fails with error: "Unknown Database MyDatabase"

  • Attaching dbForge to a new version of SQL Server

    My company pushed SQL Management Studio 19.0.1 to my computer but left SQL Management Studio 18.5 also installed. I cannot install or uninstall any software on my own. I've tried re-installing dbForge SQL Complete, but it remains connected to the 18.5

  • Database Explorer does not show all objects, even if 'Show All Objects' option is enabled for the connection.

    Hi Team! I faced an issue with Database Explorer View when it does not show all objects, even if 'Show All Objects' option is enabled for the connection. The problem seems relates to the fact that query: SELECT * FROM ALL_OBJECTS WHERE OWNER = 'MY_SCHEME'

  • SSIS package created with Devart cannot be opened in VS2017 after Devart Addon is installed.

    SSIS package created with Devart cannot be opened in VS2017 after Devart Addon is installed.

  • SOQL Queries with Salesforce ODBC Driver

    Hi, I have connected the ODBC driver as a linked server in MS SQL Server and can read/write Salesforce data. Is there a way to issue a SOQL query directly to Salesforce from SQL Server using the ODBC driver or does one have to rely on the ODBC driver

  • cant open View Table

    My view table has quite a lot of lines and sub queries. Once i created it, i cannot open it via SQL, Editor or Generate script as CREATE. It just keep loading and eventually not responding. Kindly advise. below is sample query of how the view table looks

  • Oracle trial license key

    Hi, After having installed and used DevArt Oracle driver for EF I tried to renew my trial license key without success. I uninistalled software (clean program files and program data folders) and installed again using dcoracle.exe downloaded from your site.

  • "Profile server events" tool require VIEW SERVER STATE permission

    "Profile server events" tool require VIEW SERVER STATE permission. But at the same time the original ms "SQL server Profiler" perfect work under the same account without VIEW SERVER STATE permission

  • 'Invalid parameter specified' on prepared query with a double

    In our project we get an Exception: 'Invalid parameters specified'. We've determined that this is specifically when we use a double variable. In the scenarios below the first two instances of TPgQuery are executing properly, however on opening the third

  • ConnectDialog

    Hello, when trying to open the connection to the database, if it fails, it shows me the ConnectDialog even though I don't have any associated TConnectDialog component, I need it to mark the exception and not show the ConnectDialog. How do I do this?

  • [9.1.21] Unresolved error when using JSON_TABLE function against simple scalar JSON array.

    For some strange reason, the following valid and correct JSON_TABLE command generates an error when executing the following statement in a new query window or stored procedure. SET @json = CONVERT('[1095, 1106, 1193, 1288, 1357, 1385, 1390]', JSON); SELECT

  • Why should I buy Devart ODBC for SQL Server when I can get the MS equivalent for free?

    Hi guys. I would be interested in purchasing the Devart ODBC driver for SQL Server, but I can't see it has a real advantage over the MS equivalent. Indeed, the server version price will raise from May 15th. Please, would you make it clear for me what

  • ODBC for Firebird: Problem with case sensitive table and field names

    Hi, We've downloaded the trial version of the ODBC driver for Firebird. We are using Firebird 4. We are interested in purchasing the ODBC driver for Firebird, but it depends if the problem that we are seeing can be fixed. We are testing PowerBI with the

  • Number(20) cannot be read!

    Hi, using c++ builder 10.3.2, unidac 9.2.1. I have an oracle table with column number (20) populated with numbers having 17 digits create table pelidetail(id number(9), peliid number(10), sortweight number(20), primary key(id)); insert into pelidetail

  • SQL Server LockTimeout not working?

    I am using Delphi XE10.3.2 with UniDac 9.3.0. SQL Server We have a problem with a MS SQL Server Stored Procedure that frequently comes up with a "Lock request time out period exceeded." error. The SP basically does a lot of table Truncates and then INSERT

  • BREAKING CHANGE - Default Encrypt with Microsoft OLE DB-Driver 19 for SQL-Server

    Hello I create a database connection with all standard parameters (TUniConnection.SpecificOptions) to MS SQL Server MyConnect := TUniConnection.Create; MyConnect.ProviderName := 'SQL Server'; MyConnect.Database := <DBName>; MyConnect.Username := <DBUser>;

  • Unidac 9.4 and SQL-Server

    I'm trying to connect to a SQL-Server database. This works without any problems with Unidac 9.3.0. After installing Unidac 9.4.0 the application crashes. The reported error is 2.5 Type : EMSError 2.6 Message : TCP Provider:_Es konnte keine Verbindung

  • dbforge schema compare for mysql not generating html from command line

    dbforge schema compare does only generate an empty report when running it from command line. From gui, everything works fine. The comparison itself looks fine, log files look good, just the report is not created properly. the generation seems to abort

  • PgDAC on MAcOs

    Hi am testing your Demo Mobile program with Delphi Alexandria 11.3 and PgDAC Version 7.4.0 using Mac Pro Book M2 chip . In this Demo on postgres Schema fish when i use Greek language on Mac not appear correctly Mac Running Windows Running

  • SetEmptyStrToNull does not work correctly

    Hi, we have a problem with varchar fields, wich are not set to null even if we set SetEmptyStrToNull to true. If the value of a field is an empty string it all works correctly, but if we have an fields with a string with only spaces, then the field value

  • Memory leak in UNIDAC connecting to Oracle

    Hello, I'm facing a memory leak in Unidac accesong to Oracle: 1. Oracle 12C 2. Delphi 11.3 First of all, on client side my customer was facing a problem after days the system is running and doing one task that executes every minute, a NET. Invalid pointer

  • Learning : How to save a Virtual table in SQL Tables

    Sometimes we need to store a memory table (Virtual table is the best :) ) in a field of a database table. I present these 2 sub-programs and how to use them as a review. //--------- Wide string to TStringStream procedure TDMT.WS2Mem(S: string; Var K

  • How to browse Linked Servers - SQL Server

    I’m using dbForge for SQL Server Enterprise, how can I use this to browse Linked Server objects? I can do this with SSMS’s Object Browser, but I’d like to not have to switch between 2 db tools.

  • Build Solution In MS hosted

    Bonjour We have solutions .Net with differentes TargetFramework and version Devart Exemple Solution Number 1 TargetFramework : .Net 4.7.2 Devart version : 8.5.583.6 Version=7.1.40.0 Solution Number 2 TargetFramework : .Net 4.0 Devart Version=8.5.583.6

  • EntityDac 3.2.0 and Firebird 2.0.7

    EntityDac 3.2.0 Firebird 2.0.7 IBDAC 8.3.0 Expression: From(ti).Where(ti.TRANSID = AId).OrderBy(ti.ID).Select(); Result: SELECT t1.ID ID, t1.TRANSID TRANSID, t1.ITEMCODE ITEMCODE, t1.OPIS OPIS, t1.OPISDOD OPISDOD, t1.KWOTA KWOTA, t1.SZTUKI SZTUKI, t1.WAGA

  • MySQL Router SSL Handshake error dotconnect mysql

    I am trying upgrade my development machine and need to reinstall dot connect on the new machine, however, I cannot get dotconnect to work with mysql router - even though it's setup the exact same on the current development environment. I always receive

  • TMyDump from v8 to 5.7 charset problem

    Hi Is there a way to specify the charset and collation when perforing a backup and restore? We have a clean set of data that we use for install that is on a Mysql 8 server but ur clients are using 5.7 We get the following error. I could perform a replace

  • missing compatible file : libdevartodbcase.2.1.4.dylib

    Hello, we installed odbc driver for sybase 2.1.4 on macos M1 bigsur 11.6 and the error below is generated when trying to connect excel to sybase DSN : Could you please help us with this urgent issue Thanks in advance for your attention Kind regards,

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