• Property EncryptedPassword does not exist

    Good afternoon, I have a problem with one of the legacy systems here at the company, it is unfortunately developed in Delphi 6. My problem is that I updated the Delphi ODAC that was in version 8.6 to version 11.4, but when updating, when trying to compile

  • Creating and Updating MySQL Database Schema on Remote Devices Without DBForge Installed

    Hi everyone, I am facing an issue with creating and updating a MySQL database schema on customer tablets that do not have DBForge installed. I have already created the schema using DBForge for MySQL and can export it, but I'm not sure how to create the

  • How do I insert an image file into a TVirtualTable Blob field?

    Hello, I know how to insert blobs into TUniQueries. But I could not find the way to do this in a TVirtualTable. It does not expose any AsProperty which can sugest I can use a LoadFromStream method. Thank you very much. Jayme Jeffman Filho

  • TDADataSet

    After reading Unidac 9.4.0 Revision History, I have a question: which unit TDADataSet class is declared?

  • dotconnect for Quickbooks

    I have doconnect for SQL Server. Can the dotconnect for Quickbooks co-exist? I got an error when I tried to install the Trial version.

  • Is there a way to remove decryption out of sqlite db

    Hi, I use dotconnect universal with sqlite and the Encryption of SQLiteCrypt: UniConnection conn = new UniConnection("Provider=SQLite; Data Source=database.db; Encryption=SQLiteCrypt; SQLiteCrypt License Key=00000-000-0000000-00000; FailIfMissing = false;

  • Cannot connect to Amazon Redshift

    We have been evaluating the dbForge studio as a solution for maintaining the databases and schemas in our DWH, which is Amazon Redshift. According to documentation, dbForge studio for Postgres should be able to connect to Redshift (as Redshift is postgres-based),

  • Unidac's TUniquery Can Not Filter Special Four decimal places on Oracle

    I have a TUniquery SQL is 'select 30.3706 as purchase_price, 30.3706 as retail_price from dual' and connect on the ORACLE 19c Enterprise， While I try to filter like 'purchase=30.76' or 'purchase_price>30.3706 and purchase_price<30.370600000000001', Both

  • Synchronize two sqlite databases .NET Core

    Im not able to use dbConnect to synchronize two sqlite databases in .NET Core

  • MySQL: Determine AutoIncrement column by using GetSchema

    Hi, I'd like to determine the existence of an auto-increment column in a table by using GetSchema. Could you please provide a small sample as I couldn't find any description of the various column attributes? Thanks in advance.

  • LinqConnect Migration Wizard in Visual Studio 2022 Community

    We bought a copy of LinqConnect in 2020, but it didn't work for us as there were a bunch of things that worked in LinqToSQL and failed in LinqConnect. I was hoping after a few years we might have more luck with the latest version as we still want to migrate

  • TscKey.ImportFrom(Stream); Error "Key is Broken"

    When I use TscKey.ImportFrom(FileName) everything works as expected, but if i copy the content of FileName into a constant it fails with "Key is broken" error. SecureBridge 10.2 Delphi XE7 procedure TForm7.Button1Click(Sender: TObject); const PUBLIC_KEY

  • [bug] auto-where by RefreshRecord

    After update from 7.0.1 to 7.4.0 started misidentifying where-statement and by RefreshRecord joins WHERE once more, instead of an additions! PgQuery.KeyFields := 'r_id';

  • TUntQuery Is there an asynchronous loading parameter？

    TADOQUERY.ExecuteOptions := [eoAsyncFetch]; // Asynchronous Read ，Do not block UI. TUniQuery，Do have similar parameters? Env：Windows+Delphi11.3

  • Syncing an Oracle 11g with Partitioning

    Hello, i'm trying to sync an Oracle 11g with Partitioning. The Provisioning works for a while (a few minutes) then throws an Exception: Devart.Data.Oracle.OracleException (0x80004005): ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user

  • MySQL ODBC Driver SSH Connection with keys

    I'm probably being pretty inept here, but I'm banging my head against the wall trying to get this to work. I'm able to setup an ODBC connection using the SSH tab (under the security tab) if I enter the server IP address, the username and the user password.

  • Delphi closes upon opening project SDAC problem.

    Hi i have a problem when i open a project that uses SDAC on Delphi 11.3 it automatically closes the IDE without any error. It clearly happens the moment it try's to access the SQL server as the SQL wait icon is then on screen. After about 10 seconds the

  • "Lost connection to mysql server during query" when Fetchall:=False

    A year ago I posted a similar question on the old forum. Now I think I can reproduce the error with a simple program. I add a master and a detail table. When I set Fetchall to TRUE everything works fine when I delete the master row. If I switch to Fetchall:=FALSE

  • TUniMetadata and database structure.

    Hi! Now I can get tables, columns, columns types and indexes. tables procedure var FUniMetaData: TUniMetaData; begin FUniMetaData := TUniMetaData.Create(nil); try FUniMetaData.Connection := FConnection; FUniMetaData.MetaDataKind := 'Tables'; FUniMetaData.Open;

  • Release notes on new Delphi Data Components

    Hi, first all let me say the new forum is nearly unusable. It might look modern, but it's horrid. There are new updates for all the Delphi Database Components, however nowhere can the release notes be found. Can you supply them ? (They used to be available

  • UniDac 9.4.0 cannot connect to SQL Server

    I have been using UniDac for years and I routinely connect to Firebird 3 and SQL Server databases (often at the same time). I just updated from UniDac 9.3.0. to 9.4.0. Now I cannot connect to the same SQL Server databases I have been connecting to for

  • Delphi SQL Database Access Components 10.3

    Hi, We just updated to the new release, rolled out a new version to a client but the Tconnection will not connect on the SQL 2022 Express DB if i roll back to the version prior to this release it works fine, which we have had to do in this circumsta

  • Oracle Database Sync Is Very Slow Then Throw An Exception

    Hallo, i'm using dotConnect for Oracle and dotConnect for SQLite to sync an huge Oracle database with an SQLite database using a windows service. By starting the windows service started the sync process. The Oracle 19c server and the windows service are

  • Problems with mapping types to ATTACHed SQLite databases (latest Devart.Data.SQLite.EFCore 6.0 on NET 7.0)

    Hello. I've created a simple project (latest Devart.Data.SQLite.EFCore 6.0 on NET 7.0) with 3-level entities: public class UserRole { public Int64 Id { get; set; } public String Name { get; set; } public virtual IList<User> Users { get; set; } } public

  • Unidac Mysql Cache DNS

    When the IP of a web address changes Unidac is looking for the previous IP. I am connecting Unidac with mysql via address mysql.kinghost.com When Kinghost changes the server's IP, Unidac continues to look for the previous IP address that is no longer

  • dbForge Report Writer

    I an testing dbForge Studio Report Writer. I have built my first report reasonably well but I am having trouble with the formatting. I have a calculated field for the Total Taxes. I would like it to be in currency format and cannot find out how to do

  • TOP N query to Salesforce returning all records

    Any ideas why the single table select query with TOP N would return ALL rows, while using a join (second query below) will limit to 100 returned rows? SELECT Top 100 c.Name, c.Email FROM [SALESFORCE]...Contact c SELECT Top 100 c.Name, c.Email, a.Name

  • ODBC driver conenction to excel power query. Access to REST API is restricted by iTheme Security settings

    HI, any help with this please?

  • Firebird Get Identity field after a Post

    I know you can use as Returning to get the Identity field when using an insert SQL. But I need to do it with a SELECT statement and an insert; eg uniquery.close; uniquery.options.RequiredFields := false; //because of Identity field uniquery.sql.clear;

  • dbForge Schema Compare for MariaDb 10.11.2

    Hi, I've seen similar issue from a few weeks back but for DB Forge. You ended up sending a person link with a custom build. Do you have an option to do so for your Schema Compare customer? I recently updated my box and had to rebuild docker container

  • Timestamp With Time Zone Field not TSQLTimeStampOffsetField?

    Hi, Is there any reason why the implementation of your TIBCTimeStampTZField is not based on the built in TSQLTimeStampOffsetField? There's no documentation on the TIBCTimeStampTZField either. With regards, Martijn

  • Force allias

    Hello Sometimes tabla name not displayed and see 'Query' This is an example: SELECT * from ContractBalanceTX cbh where 1 = 1 And ContractBalanceProcessesId IN (select list FROM @contractbalanceprocess) AND ContractId IN (select list from @your_list) --(1053,

  • Salesforce ODBC SQL Server linked server not able to browse catalogs/tables in SSMS, but can query them

    I'm not sure we have our linked server security setup correctly - our Salesforce user seems to be working correctly as we can query data from various tables, but our SQL Server linked server (using Salesforce ODBC driver) is not allowing us to browse

  • Does SSIS Data Flow supported in SQL 2022?

    I get the following error in SQL 2022，any help would be appreciated:

  • Built-in Oracle spatial functions for EF Core

    We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. Previously in LINQ queries we frequently used spatial functions which were nicely translated to SQL, such as Devart.Data.Oracle.Entity.OracleSpatialFunctions.SdoRelate(geometry1,

  • Ignore specific Tables, Views, Procedures, Etc.

    I am doing a comparison/synchronization between a client's database and my local server. There are specific tables, views, procedures, etc. that are ONLY used on their servers, reference other servers/databases in their environment, etc, that I don't

  • 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

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