• Can I use dotConnect Universal with Entity Framework?

  Hello, I'm very new to your product and I consider using it in our project. We need to have the ability to switch between two different databases - Oracle and Postgre. My question is would that be possible with dotConnect Universal while also working

• Support .gitignore in dbForge Source Control (Feature Request)

  Please follow .gitignore for SQL Objects. For instance, we have a convention to deprecate objects by prefixing them with "zzz_old_YYYYmmdd" and then waiting a few months before finally deleting them. Source Control doesn't follow the .gitignore file so

• License issue when upgrading from EF Core 7 to 8

  Hi, I am working on an application that uses the Devart.Data.Oracle.EFCore nuget package to read data from an Oracle 10g data base. Originally, my application was based on .NET 6.0 and Entity Framework 7. Recently .NET 8.0 was approved for usage within

• "The client code page 65001 does not have a corresponding SQL Server Collation. InMemory Rowset creation failed."

  A customer has set a Windows setting that was marked as beta, but is probably now required by several applications: Control Panel > Clock and Region > Region > Administrative tab > Change system locale button > Beta:Use Unicode UTF-8 for worldwide language

• Error Adding DevartNHibernate Model

  Hallo I'm using Visual Studsio Community 2022 And Entity Developer I uninstall it and check the Template Folders for existing ZIP Files and reinstall it with Admin USer Rights. But with the NHibernate Template I get this error: The EF Core Model works.

• OperationalError: Trial period has expired

  Hi guys! I'm trying use devart.ase lib for python (3.10) and i get this message: "OperationalError: Trial period has expired." Is this lib free for use? if not, how much is? and how can i get a valid license? Thank you in advance

• Encrypted data is corrupt

  I am considering purchasing a SecureBridge license to use in an older project developed with Delphi 7, I have installed the trial version. But this code gives error: Encrypted data is corrupt procedure TForm1.Button1Click(Sender: TObject); Var Request:

• Unidac 10.1 (in)compatibility issue with Delphi 12.1 in 64bits mode

  Hello, We came across an issue while trying to use Unidac from packages compiled with Delphi 12.1 (Version 29.0.51961.7529) on 64bits windows platform. At launch, the package tries to resolve a symbol called __init_record_FILENAME, which, was apparently

• How to use UniDAC to connect to Borland's Paradox database

  Hello everyone, I'm maintaining a legacy project, developed in Delphi 7, and using the Paradox database (plzl.DB). I now need to migrate the database using the UniDAC component, but I found that there is no Paradox option in the ProviderName property.

• SQL Complete - Management Studio 20?

  I just migrated to a new machine, and by default installed the current release of SQL Server Management Studio, which is version 20.0. When I installed SQL Complete, it doesn't add itself to SSMS; is this because version 20 is not yet supported? If this

• Keep getting an exception of "ORA-00971: missing SET keyword" where SET keyword is there.

  Hello friends, I keep getting an exception of "ORA-00971: missing SET keyword" for the following source code. I have no idea why. As you can see, it has SET keyword. Any ideas? Thank you so much! try { OracleConnection connection = new OracleConnection(_connectionString);

• How can detect which driver is used by active TMSConnection?

  Hello, How can detect which driver is just used by active TMSConnection from code.. For example if is used Native client 11 or Native client 10 or Ole db provider, or SQL server OLE DB driver 19 or 18....... etc... need something like this showmessage('Iam

• Is DbForge for postgres unfinished ?

  There is no designer for creating objects like: Tables PK and FK indexes triggers Functions Domains See this post from the year 2021 where it said it was in the plans and it's been 2 years. forums.devart.com/viewtopic.php?f=51&t=47836 I am very interested

• Schema compare not syncing

  Using the MySQL Schema compare I have a field in a view which does not sync, it sees the difference every time but does not update it. the difference is: CAST(LEFT(`assets`.`AssLocation`, 30) AS char(30) CHARSET utf8) AS `Asst_Locn`, and CAST(LEFT(`assets`.`AssLocation`,

• constraint failed virutalquery

  Hi, With the code below : //---- Ouverture de la tables des paramètres (L_PARAM_AS is a TUniTable component on L_PARAM_AS table in attach file) L_PARAM_AS.Open; //---- RequeteParametreDispo is a TVirtualQuery with L_PARAM_AS in source dataset RequeteParametreDispo.Sql.Text

• SQL Statement Parsing Error

  Greetings; In version 10.1.0 of UniDac I have a problem in type conversions with PostgreSQL, this problem was not present in the previous version. Example: "SELECT id, name::text FROM customer" In the example SQL statement I get an error in the "name::text"

• Solution for .NET entity framework database connection using web API

  We have a windows .NET application which is built using Entity framework and WCF. Looking for Database connectivity tool to stablish secure connection with SQL Server Database using web API

• Firebird - RETURNING not working

  Hello. I'm having problem in Firebird with RETURNING value with latest Unidac 10.1.0 on Delphi 11 update 3. Problem occurs when "same" query is used for SELECT and INSERT/UPDATE. I've attach db.txt with sample table T1 with three fields (ID,f1,f2). Here

• UniDAC loading and saving Delphi TMemo

  How can I load and then save a Delphi TMemo contents into an sqlite table?

• Entity Developer and Composite Keys

  Hello, Is there are way within Entity Developer, prior to code generation, to flag attributes, and remove the warnings e.g. Northwind db (image) so my generated code mappings won't have an issue. Thanks.

• performance of simple "select count(*) from ....."

  I run a simple "select count(*) from mytable", but it is quite slow. sqlite3 database. If I do it with sqlitestudio 3.3.3 I get the answer instantaneous. 264000 records. With unidac it takes 6 secs, when I set unidirectional = false or it is much worse

• GetDate() error for Dynamics ODBC Driver

  I'm getting an error message when I use GetDate() in a SQL query I'm writing using the ODBC driver. Basically I only want to pull records created today. Has anyone run into this issue and found a work around? Thanks

• ItemInventory missing custom fields in QuickBooks Desktop

  I'm trying to select from ItemInventory with a python script and I'm finding that the table structure is different, when I use the DevArt driver rather than the QODBC driver. Particularly, the custom fields are missing. I'm not seeing any settings in

• SocketException with dotConnect for Magento while Opening Connection

  Hello, I am experiencing a Socket connection error with ADO.NET provider for dotConnect for Magento while opening a connection. Interestingly there is no problem connecting to the database with MySQL Nuget package by Oracle. The Connection Errors are:

• I can't use UniDac in Linux application.

  Hi everyone. I have a REST application in Delphi Athens 12, in Windows works very well (connected to PostgreSQL 14 in Ubuntu 22.04 64bits). I make the same application to Ubuntu 22.04 64bits (Target plataform), the application starts well, but in the

• Color schema for matching brackets like in Azure Data Studio

  Is there an option (or is it at least planned) in dbForge Studio for SQL Server to use different colors for matching brackets like in Azure Data Studio?

• Security Banners

  From https://www.devart.com/odac/revision_history.html.... Added support for connect to servers with enabled Security Banners in the Direct mode Hello, Can you provide some details on this? I would like to be able to display the banners in my application,

• How to configure automatic formatting of function words in a text editor?

  Hi, dbForge Studio for MySQL v.10.0.150 There is a problem with the word "SET" . How can i customize text editor to print this word in upper case automatically? The parameter "Automatically format words while typing" is on. I print SET in upper case mannualy,

• [10.0.46] run a second query (by hotkey) in the same editor does not work (without hitting the hotkey twice)

  hi devart, i do hope this is a bug and not another great example of "industrial standards". if you have a regular edit tab open and have a query there that you can run with the hotkey that runs a query where the cursor is - and you write a 2nd query and

• additional quotes when copying from the data editor

  v.10.0.60 example SELECT JSON_OBJECT("key1", 'val1', "key2", 'val2') UNION SELECT JSON_OBJECT("key3", 3, "key4", 4); 1. when copying a value from one line everything is ok 2. When you copy several lines, additional quotes are inserted

• Type mismatch for SBadTimeZoneID

  The second Parameter in the string SBadTimeZoneID (= 'Invalid Time Zone ID: (%d, %d)' ) is of type decimal. In the unit IBCCall.pas, the function TTimeZoneUtils.TimeZoneIDToTimeZoneName(...): String contains the line RaiseError(Format(SBadTimeZoneID,

• TUniConnection.AssignConnect(TOraSession) ?

  Hi, is there any way to assign an active TOraSession to a TUniConnection instance? There is a need to use both components with the same session.

• Debugger failed with timeout

  hi. I have problem with "step into" while debug code : "Debugger failed with timeout" What's wrong ? Thank you.

• code completion for procedure parameters

  Hi. code completion for procedure parameters don't work ( dbForge Studio 2024 for Oracle v. 4.6.15 refresh suggestions, ctrl+space does not help also sometimes in some sessions code completions stops working completely ( Thank you.

• what grants required for "Navigate to definition" ?

  Hi, i have had error while trying to "Navigate to definition" what grants required for "Navigate to definition" ? and are they necessary ? Another IDE successfully perform operation like this under the same user . You should understand that not all users

• ODBC Driver for BigCommerce

  We are currently evaluating the ODBC driver for BigCommerce 2.4. Our products table in BigCommerce Enterprise has 500,000+ records and would like to query it. We are using a criteria in our query to display 1 product or 1 SKU but it doesn't show up (or

• How does IBDAC handle RETURNING in Firebird 5 if there is more than an row returned?

  https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-compat-returning says: Client-side INSERT … SELECT, UPDATE, DELETE, MERGE and UPDATE OR INSERT queries containing the RETURNING clause may now return multiple

• UniDAC: SQLite extension error

  Im trying add pivot table extension "pivot_vtab" (https://antonz.org/sqlite-pivot-table/) to my sqlite, according to item "3. Pivot extension" in manual. I compiled DLL, in UniConnection did load an extension, see manual here: https://docs.devart.com/unidac/using-sqlite.htm.

• TScSFTPClient: Append file on server in new line

  Hello, TLDR: How do I properly append a file on server in a new line using TScSFTPClient? I replaced my Indy-FTP-Clients with SecureBridge and I am currently working on an instance in which a textfile on a server is appended with the data of a local text

• Connecting to PostgreSQL or MSSQL Using Oracle Database Link and ODBC Driver

  I want to connect PostgreSQl and MSSQL in Oracle using dblink. I do everything from this page https://docs.devart.com/odbc/postgresql/oracle_dblink.htm and it doesn't work. Please help

• Next Page

• Most Discussed Topics

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

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

• 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

• 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

• 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

• Sql Complete v2025.1.134 won't switch to express license

  I updated to v2025.1.134 for SSMS 21 but somehow my Express license was reset and I'm now back in the "Enterprise" license trial mode. The previous solution of setting HKEY_CURRENT_USER\Software\Devart\dbForge SQL Complete\Activation\UseExpress to 1 isn't

• Change order of ApplyUpdate

  Hi Using CachedUpdate I need to have the delete statements to be fired before the inserts, is this possible? if not, i try to delete the deleted records before i can applyUpdates, but when i call apply after that i get error record to be deleted cant

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