• Unable to connect SQL server database

    I write a code on databricks python notebook to connect My SQL server database through ODBC but it's showing error as in attached file.  Pls provide me solution ASAP.

  • TRttiUtils : Documentation

    Could you please provide the documentation for the TRttiUtils class and an example of use TIA

  • STRING_TO_ARRAY

    i'm getting an "error" while trying to format a document SQL1.sql: Error (6,5): Unexpected symbol 'STRING_TO_ARRAY'

  • UniDac 64-Bit MySQL

    When linking a 64-Bit C++ project with MySQL UniDac support we get the following error, Unable to open file 'myprovider280.lib' To correct the problem, we have to copy, Devart\UniDAC\Lib\Win64\myprovider280.a to Devart\UniDAC\Lib\Win64\myprovider280.lib

  • Cann't get autoinc primary key value after UniQuery.Post when SQL include ORDER BY

    Select * from table order by col1,  Simple SQL like this are fine. Select table1.*, table2.xxxxx from table1 left join table2 left join table3 ORDER BY xxxxxx. When it is such a complex SQL statement, the self-incrementing primary key value is Null after

  • Change sqlite version

    How to update sqlite version? For now sqlite 3.40 is newest but it's 3.36 in devart 6.0.x package.

  • 9.3.0 - Virtual Table Errors

    Hi, I detected errors in VirtualTable object. Sample application and information as follows: Delphi: Delphi 11 Unidac: 9.3.0 (nightbuild version) OS: Windows 11 There are 2 problems. One of them is that when we load data into the VirtualTable object at

  • Features supported

    1. Does the driver use the postgres binary or string protocol? 2. What is the level of support for Arrays and PostGIS datatypes? 3. I understand that the driver connects directly, does it support connection using SSL?  Thanks 

  • query using "for json"

    Hello, I use SDAC 10.0.2 with delphi 7, When I try follow query that return one row & one field (actually is TMemoField) and get field value as string I get part of actual data (2033 bytes).  Can anyone knows what is wrong? select * from customer for

  • Sample size while mapping

    Hi I am trying to import a large dataset from a csv. When using the wizard, it is eventually setting the type and the max. lenght of each column, using a sample of 100 (?) lines. How can I tell the wizard to use a larger sample, like 10.000 lines?

  • SOLVED - UNIDAC 9.1.1 - PostgreSQL 12 - 15 Digit Problem

    I started seeing a bug I reported earlier in version 9.1.1 again. Can you help with this? Information:  Delphi 11   PostgreSQL 12...15  Unidac 9.1.1  Before Report: https://forums.devart.com/viewtopic.php?f=28&t=54306   ScreenShot: Thanks. 

  • Tmytable not drop

    Hello, how do I make it so that a TMyTable that is active cannot be deleted with DROP TABLE ?

  • ODBC Connection SQLSERVER to HUBSPOT

  • Schema Compare doesn't support unique indexes which contain CASE statements

    We have a unique index that contains a case statement: ADD UNIQUE INDEX uk__phone__org_id__phone_number(org_id, ((case when (`org_id` <> 2) then `phone_number` end))); We added this index to our database project and when we perform a schema compare between

  • Batch Update Oracle Nomal Mode and CLOB

    Hi, I use batch update to update records in a query. My query have a CLOB field a the end like this                  //---- Sql : Update                  UQ.Sql.Text := 'UPDATE T_MESURES_STEP SET VALEUR = :VALEUR,CODE_REM = :CODE_REM,CODE_U = :CODE_U,METHODE

  • BDE to MyDac

    I am considering converting a large application database to MySQL using MyDAC. I found this page via Google that says: "In MyDAC the interests of BDE application developers were taken into consideration. So starting to use MyDAC after working with BDE

  • Data Comparison. Describe Objects

    I have two databases with each schema containing 171,000 tables(Since it is an ERP application). I want to compare a select few tables only, but first I need to load all the objects.  Steps performed: 1. select New data comparison option 2. Select source

  • SQL Complete - Is there a way using the formatter to ensure spaces exist between brackets in the where clause

    Is there a way using the formatter to ensure spaces exist between brackets in the where clause? example: WHERE (Column1 = @Column1 Or Column1 > 0) would become WHERE ( Column1 = @Column1 Or Column1 > 0 )

  • dbforge for Vitess

    Hi Team, We are trying to use dbForge studio with an existing Vitess based MySQL cluster but are not able to view the database schema. Can someone please confirm if dbForge supports Vitess based MySQL cluster ? When adding our vitess db with our credentials,

  • Does the new forum keep track of what you have already read?

    Does the new forum keep track of what you have already read? I am logged in.

  • Delphi Replace Components

    I am trying to convert a large project To MySQL using MyDac. I am trying to use Delphi's Replace Components feature and I am getting 'Catastophic Failures.' I also tried it with GExperts add on tool and get the same result. I am wondering if anyone has

  • UniDAC components for FastReports (end-user designer) FMX 64-bit doesn't exists.

    Delphi is a computer language that allows us to write applications for Windows, macOS X, iOS, or Android. https://www.embarcadero.com/products/delphi Universal Data Access Components from Devart (UniDAC) is a set of components that allows Delphi programmers

  • Are this forum working?

    I Cant commit a new topic.

  • UNidac with Aurelias

    Hi I am attempting to use the TMS Aurelius components to connect to Mysql 8 on Linux, using the Unidac components. When I use the Aurelius sqlite connection, everything works fine, however the moment I try and use unidac, it is impossible to start apache.

  • Generate Entities Prefixed with Schema Name

    Hello,  We are evaluating Entity Developer for purchase. We currently use "EF Core Power Tools". One of the few nice things about it is that when using Database First, it generates entity names that are prefixed with the schema name followed by an underscore.

  • Oracle Direct and Windows 11

    Hi, I have a problem with connection to Oracle in Direct Mode. It Work fine with Windows 10 but with Windows 11 I have this message : "(NET : Network error (cannot connect to server on host '192.168.0.4':0 requested address is not valid in this context

  • RecordCount and UniDirectional

    Hi, I have some query with number of row > 25. With Oracle I use Oracle.FetchAll=True to get correct RecordCount but if I use also UniDirectional = True record is alway 25. PQ.SpecificOptions.Add('Oracle.FetchAll=True'); PQ.Sql := 'Some quetry with more

  • What is "Serializable Transaction"?

    In "New in dbExpress Drivers: Support for RAD Studio 11 Alexandria Release 2 and Microsoft OLE DB Driver for SQL Server 19" https://blog.devart.com/new-in-dbexpres ... er-19.html "Also, we added support for the serializable transaction." What is "serializable

  • Using ILIKE

    Hi there, How can I use "ILIKE" in a LINQ query in DotnetConnect for Postgres?  If I try to use Devart.Data.PostgreSQL.Entity.PgSqlFunction.ILIKE, it throws an error "Method 'Boolean ILike(System.String, System.String)' is not supported for execution

  • Connect to Microsoft Analysis Services

    Is it possible to connect to Microsoft Analysis Services using dbForge Studio? I'd like to use dbForge to query SQL data in Analysis Services

  • Strange behaviour

    Hello, I'm using ODBC driver from dynamics 365. I'm experiencing some strange behavior. For example, when I attach Dyn365 database as shared server on my SQL Server, in my queries the TOP 100 clause is ignored. So for example, the query: select top 100

  • dbForge for SQL Server

    Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server

  • dbForge for MySQL

    Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL

  • dbForge for Oracle

    Discussion of open issues, suggestions, and bugs regarding database management and development tools for Oracle

  • dbForge for PostgreSQL

    Discussion of open issues, suggestions and bugs regarding database management and administration tools for PostgreSQL

  • Code Compare

    Discussion of open issues, suggestions and bugs regarding file and folder merge tool – Code Compare

  • Review Assistant

    Discussion of open issues, suggestions and bugs regarding code review tool for Visual Studio – Review Assistant

  • LINQ Insight

    Discussion of issues, suggestions and bugs of LINQ Insight, Visual Studio add-in for design-time executing LINQ statements, that simplifies debugging LINQ

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