• Multiple Query

    Hi I have a following problem: trying to utilize multiple query feature but getting error about incorrect sql syntax (ORA-00933). I want to pass few sql queries into one command, then execute reader, fetch data from first query, then call NextResult and

  • Cancel Subscription

    I'd like to cancel my annual subscription for MySQL Database COmponents. Where can I do this?

  • How to make Code Compare Ignore closing/opening braces openings or endings?

  • facing issue as Cannot describe stored procedure arguments

    Hi Team, we are facing the same issue which is mentioned in below link, this is created around 2 years ago. Do not find any solution/fix provided. please help in understand the resiolution required. For reference we are adding the Procedure for reference.

  • Unable to create entity model

    Hi, Using Visual Studio; When I try to add a new Devart Entity Model; I can create a model using the thick client app and open it in Visual Studio but the entities are not generated and I do not see Run Custom Tool.

  • Как правильно работать c компонент Encryption Unidac Firebird3?

    Добрый день Подскажите пожалуйста как правильно работать c компонент Encryption Unidac Firebird3? то что работал Ibdac перестал работать Unidac База Firebird 3 тип поля VARCHAR(2000) CHARACTER SET OCTETS COLLATE OCTETS В Ibdac работает но в Unidac после

  • Snapshot functionality or getting sqlite3* connection handle from SQLiteConnection

    I need the snapshot functionality offered by SQLite as described here: https://www.sqlite.org/c3ref/snapshot_get.html but in context of a SQLiteConnection in turn used with Enity Framework 6. As far as I can see dotConnect for SQLite does not support

  • IndexFieldNames

    Hi, I need "natural sort" as a sorting algorithm to use with IndexFieldNames. For natural sort see: https://en.wikipedia.org/wiki/Natural_sort_order I have an article number field as varchar. Some of my customers have article numbers with mixed letters

  • Is there a way to extract whole postgres schema without the data ?

    Hello I am looking for a solution to extract all my postgres schema to a file. DDL format would be nice. Thank you for help!

  • Installation Questions

    I am installing dcoracle101pro.exe on a server that functions as a development environment as well as a production web server. When I attempted the installation it said that it was going to remove any old versions and I told it to go ahead and then another

  • Export results from dbForge Search within SSMS

    Hi I've done a search for the name of a table, and have a list of around 40 results. I need to go through each of these items and check / update some code. However, I'm not going to get it all done today, so I'd like to export the list of results to a

  • Automatic Timestamp Macro

    Hi, I found this topic and I think this is still a problem with UniDac: https://forums.devart.com/viewtopic.php?f=28&t=38112 When I use an SQL like ".... {timestamp '......'] ..." this works fine except for one client where I get an error: La conversion

  • Paginal mode when running stored procedures

    Is it possible to for paginal mode to be on by default when running a stored procedure? I have it enabled via Tools...Options...Data Editor...General...Use paginal mode by default and this works for standard queries but when I execute a stored procedure

  • How to translate SQLite messages

    Hi, I use UniDAC to deal with SQLite databases. I use direct mode. If there is any error I use EUniError(E).ErrorCode but it is not detailed. (usually returns 1). E.Message holds detailed message in English. How to intercept to be able to get real error

  • Can a "dotConnect for Oracle" license be transfered from 1 developer to another developer

    We're planning to buy a "dotConnect for Oracle" license type Team (up to 4 developers) for the company, and we analizyng the following scenario: If the 4 licenses are assigned to 4 different developers in the company, and at some point 1 of the developer

  • EF7: query (with JSON and CLOB) is much slower with directmode=true than without directmode

    When querying an oracle view that has a CLOB which stores JSON using a connectstring with direct=true is much slower then without direct=true. <PackageReference Include="Devart.Data.Oracle.EFCore" Version="10.1.134.7" /> <PackageReference Include="Microsoft.EntityFrameworkCore"

  • Feature Request - Object Bookmarks

    It would be very useful to be able to bookmark objects in the Database Explorer. It can get tedious moving between different objects in different tables in different servers... It would be useful to be able to right-click and bookmark an object (table,

  • How to setup encrypt connection on DBExpress Devart SQL Server?

    Hello! I tried to add on params of TSQLConnection: (using Devart SQL Server) Trust Server Certificate=True; Use Encryption for Data=True;Login Prompt=False and Encrypt=True TrustServerCertificate=True but no effect on connection. I verified by this SQL:

  • dbExpress Trial Period

    Good morning, I'm trying to use the dbexpress trial with my software, but when i try to use it on my software i receives an message saying that the trial period has expired, even if i dont have other dbxpress installation on the pc. I already tried to

  • Oracle RAC connectivity issue (regression)

    Hi Devart Team, In early 2021 we updated our dorConnect for Oracle dependency to 9.14.1180 due to a client not being able to connect to their Oracle RAC database with our software. After the update all was good. Late last year we again updated our dotConnect

  • Table sorting

    One of my favorite live sex cam sites features daily live shows from popular porn stars, adding an extra level of excitement. https://cammilf.net/curvy https://bbwcamchat.org/chat/dirty_sara17 https://bbwcam.site/crossdresser

  • F2613 Unit 'ScBridge' not found error

    Hello - I have just Installed SecureBridge 10.3.1 in Delphi 11.3. I see the components in the IDE. When I target/run a Windows 32 app it works fine. When I run a Windows 64 app, Android 32, or Android 64 I get the error F2613 Unit 'ScBridge' not found.

  • Best practice to work with SQL Server transactions

    Hello, what's the best way to perform a transaction with a TMSQuery? See the following source code: try LQuery := LDatenHandler.GetQuery; // returns an TMSQuery object try LQuery.SQL.Clear; LQuery.SQL.Add('Begin transaction'); LQuery.SQL.Add('INSERT INTO

  • Is SQL Complete going to be created as an extension for Azure Data Studio?

    Are there plans to port over the functionality of "SQL Complete" for SSMS into Azure Data Studio as an extension? Azure Data Studio vs dbForge SQL Complete: Which One’s Best at Code Completion? Thanks!

  • Devart SSIS Data Flow Components for Salesforce trial was expired

    Good morning, We have several SSIS that stopped working after a month. We have the Devart license working in our computer using Visual Studio, but when we execute the SSIS from the server, it is throwing this error: "Tarea Flujo de datos:Error: There

  • How to use Kerberos auth

    I've got an Aurora postgres database set up to use Kerberos authentication. How can I configure dbForge to connect with Kerberos?

  • Could not load file or assembly 'Devart.Data.Oracle.Entity.EF5'

    Hi, we moved from devart 8.4 to version 10.0 so current entity dll is devart.data.oracle.enity.EF6 but after running program on a new user environment we're getting below error although we never had or used such dll devart.data.oracle.enity.EF5 - no idea

  • Insert to oracle 21 -> -922337203685478 value instead of 1.99 (exactly 1,99)

    Hello, we have a problem with entering values to fields. The value 1.99 is entered into the table as null or as -922337203685478. We are using a 32 bit client - there is a problem on it. On the 64 client it is fine, unfortunately we cannot use it. Current

  • Delphi 6 - How to specify HomeName

    Hi, I know that the HomeName option is only available for Delphi 2007 and higher IDE versions, but there is a workaround to specifiy an Oracle Home in Delphi 6, using last version of dbexpoda.dll? Thanks.

  • Long response time for a query

    Hi, Last year, I posted a question on the old forums and the answer was: you need to install the latest version... Which we did in September (version 9.16.1434). Now we're back in that period where our application is used a lot and we're still experiencing

  • Table Mapping Generator

    Hi All, during the generation of the mapping for a Database in EF Core v 7, importing the tables in model we have an error because is inserted a wrong value into a table definition. The wrong value is: .UseTptMappingStrategy() another problem is that

  • ExecuteDeleteAsync Error

    Hello, every time i try to use ExecuteDeleteAsync in EF7 , for example context.TABLE_NAME.Where(x => x.ID == id).ExecuteDeleteAsync(cancellationToken: cancellationToken) i get error like : System.InvalidCastException: Unable to cast object of type 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.DeleteExpression'

  • Saving NULL geometries in Oracle DB with EF Core

    We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. When saving an entity using EF Core (using UseNetTopologySuite on the DbContext) where a column of type Geometry is NULL, it results in the following error: Microsoft.EntityFrameworkCore.DbUpdateException:

  • Performance on PostgreSQL connection

    Good afternoon! We use TUniConnection in our applications, using in most cases the PostgreSQL database. We are experiencing problems related to slowness, especially when our customers use VPN for the connection. We are currently using the parameters below:

  • EMyError

    Hey there, I think that the online documentation for EMyError is *very* incomplete. There is no mention, for example, of a "Message" property, which I've seen you mention in some help topics. Can you please point me where I can find the structure of EMyError

  • NET:IOHandler is not specified

    A user is receiving this error message when attempting to connect to the database using a TOraSession in DIRECT mode. Can you tell me what this error means and how to resolve it? I am using the most recent ODAC version on Delphi 11.3 compiling in 64 bit.

  • Modify TStringField for ANSI / UTF translation

    I am using the latest UniDac version with Delphi 12.3 on an oracle database (db2 / sqlserver planned) There are many old cobol applications running which not support UniCode, so data is written as AnsiString using the codepage setting of the windows client.

  • [ASE] Error on connection: Finally we got Status param!!! Analyze it.

    Hi everyone, I'm currently trying to connect to a ASE Sybase database running on version 17.0.10.5963. I've installed the devart ASE driver as version 3.3.0. When trying to connect with different connection strings from Python, C Sharp and when testing

  • Firebird ODBC devartodbcfireird.dll access violation

    Hi, I need to update my 2 servers with ODBC for V4 of Firebird. When I test on my workstation running Windows 11 Home, I have success. When I install and run on both Windows Server 2008 64bit and Windows 2012 64bit, they both get the same access violation

  • How to delete from SFDC Object in SSIS

    Hi there. I have built out a suite of integrations using SSIS, SQL Server, and Devart for SFDC. It is working well. However, I need to clear out one SFDC object before I load it again. I am the kind of guy who needs a worked example when I hit a brick

  • Next Page

  • Most Discussed Topics

  • 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

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

  • 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

  • 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

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