• Delphi TMSStoredProc parameter issues

  Hello, we are replacing ADO with SDAC in our application. I cannot get one thing work.. myAdvStoredProcedure := TMSStoredProc.Create(nil); myAdvStoredProcedure.StoredProcName := 'GetCustomerTest'; myAdvStoredProcedure.Params.Clear; myAdvStoredProcedure.Params.CreateParam(ftInteger,

• Issue with Schema Comparison and Synonyms

  I'm schema-comparing two databases (i'm using Schema comparison from within SQL Server Studio). Database A and B exist in two different servers/instances (let's say S1 and S2). Database A has a synonym to Database C (in the same server - S1) but Database

• SQLite binaries for Linux

  Hi, We are developing an application using .NET 8 and EF Core. When installing dotConnect there are sqlite3 binaries only for Windows. Do you also provide binaries for Linux? Cheers, Paul

• UniDAC SQLite Float type issue on Windows ARM virtual maschine

  Hello! I am working since years on a Mac (M1) with VM-Tool Parallels within a Windows ARM version. Recently I have a problem with updating any float values in the database. It's really strange. If I want to update 1 field with type "float", "double",

• How to save comparisons in Code Compare?

  So I often have to compare 2 folder directories and I feel that there should be a quick comparison that automatically loads the 2 folder paths rather than me have to select 1 in each side. Has this functionality been implemented? Seems like an obvious

• How to hide the column type in the suggestion list in SQL Complete?

  How to hide the column type in the suggestion list in SQL Complete?

• Unidac + Firebird: error if unicode is used in SQL query

  With UniDac 9.4 (demo), Delphi 11 and Firebird 4 If I use some characters in a query I get a Dynamic SQL Error SQL error code = -206 Attached a "working" example! It's my fault or a bug? Thanks Nicola

• Entity Framework Error

  Hi, I am trying to update the schema through ORM, however I got the below error, it seems the connection is good, please advise. EF version: 6.1.3 VS version: 2022

• Using dbForge to set up CI/CD for MySQL

  Hey, everybody! Can you please tell me if there are any possibilities to customize CI/CD with dbForge ? I've a situation where I've a remote database on Amazon RDS and a local database. Before dbForge I had to work with SSDT and there was an option to

• How to TUniconnection convert to adodb._connection (VBA)?

  How to TUniconnection convert to adodb._connection (VBA)? Unidac for Delphi12 (ver: 9.4)

• Where can I view Java Classes in dbforge Studio for Oracle Database Explorer?

  I can easily expand and select Java classes to view the source code in Oracle SQL Developer. But, how to do it in dbforge Studio for Oracle?

• SSMS 20.0 Support

  I was trying to use SSMS 20.0 (3/19/2024), along with dbForge SQL Complete, but I can't get it to work. Can you please add support to get this to work? My workaround is to use SSMS 19.3. Thanks, Jacob

• dotConnect for Quickbooks: All of a sudden my App no longer connects and will not reconnect.

  How do I reconnect my ADO.NET fir QB provider?

• dbForge MySql backup error: parsing failed

  I have a backup project I've used many times to create a backup of my data. I don't think any versions have changed (of mySql or dbForge). Now, though, I get an error: "Parsing failed on named ." There appear to be blank spaces in the error message, as

• Devart license not found on new laptops

  We have an issue where the following exception is thrown: "License not found. Please view "Licensing" topic in dotConnect for SQLite documentation for details or contact Devart technical support." and System.Data.Entity.Core.ProviderIncompatibleException:

• MariaDB 10.6.18 with dotConnect MySQL

  Hallo, we are using dotConnect and try to connect to a MariaDB 10.6.18 with SSL. We have dotConnect MySQL 8.10, and we get the error-message: SSL connection error (2026): The server hello message uses a protocol that was not recognized. There was no problem

• New User: Following EntityiDAC PDF - Issues

  I am trying to follow the demo in the EntityDAC pdf using a sql server. I am to this step: "Then select the EntityConnection component, specify the path to the database in the ConnectionString property and set other properties as follows:" I am populating

• Support for Azure MFA (Azure EntraID) log in in connection manager

  Hello, It looks like currently the only way to create a login using MFA in the connection managers is to create an application account in Azure AD (now EntraID) and use the ApplicationID in the connection manager. There does not appear to be an ability

• DotConnect for Postgresql with Entity Developer - How use ConnectionLost Event

  Hi, I am using DotConnect for Postgresql with Entity Developer (edml Data Model) in an ASP.NET Framework, C# and Entity Framework 5.0 application; Sometimes the connection with the Postgresql database is lost, how can I use the ConnectionLost Event in

• Salesforce ODBC + MSSQL linked server - select column metadata?

  Via the CLI tool `isql` I was able to retrieve column metadata using the "HELP TableName" command / query, but trying to send the same query via MSSQL linked server only produces an error: SELECT * FROM OPENQUERY (SF_LINKED_SERVER_NAME, 'HELP Account')

• Issue with DescribeParams on SQL Server 2022

  Hi, we are migrating from SQL Server 2012 to SQL Server 2022 and have a problem with using property DescribeParams of TMSQuery component and calling Prepare. MSQuery1.Options.DescribeParams := True; MSQuery1.SQL.Clear; MSQuery1.SQL.Add('SELECT TOP 10

• Python Connectors Talk

  Share your questions, ideas, and experiences with our mobile application here. We’re eager to hear your thoughts and suggestions for improvement! Ready to listen to your feedback!

• Connection to MongoDB gives me authentication error

  Hi, (I could've sworn I asked this question but my post seems to have disappeared.) Please note I am using Delphi 10.3 (still on a Win8.1 system). On the MongoDB system, using mongoshell: use testdb db.createUser( { user: "testx", pwd: passwordPrompt(),

• wrongly generated Oracle sql query EF core NET8

  I am currently upgrading or application that is made in framework 4.8 to NET8 and i have some issues with the Entity framework part where the generated sql from the linq query is incorrect. The logic with boolean seems to be the problem, I am not sure

• Add SQLite DB relative path to app.config

  I have a versioned project shared across a small team and I'd like to avoid using absolute paths for my connection string. Instead I'd like to use either an environment variable or a relative path based on where the project is located. My question is

• dbForge does not seem to understand HeatWave specific commands

  We are migrating from MySql on-premises to Oracle Cloud with Heatwave. When we perform a DB comparison, we get errors on tables that contain fields to be excluded from HeatWave with the NOT SECONDARY keyword assigned to the fields. Also, in stored procedures,

• Using TUniQuery w/ MongoDB

  Hi, Having taken a look at https://docs.devart.com/unidac/using-mongodb.htm#tuniconnection, I'm still struggling as the amount of information is somewhat limited (particularly the examples). I have the following code: procedure TForm1.Button1Click(Sender:

• Support for Open Telemetry?

  OPD.net supports Open Telemetry. Most other database providers now also support this. Does dotconnect also support open telemetry? If not, this would be a very important and good feature for the future. Regards Hansjörg

• Can't create a new SSIS Connection Manager

  The connection type "DevartSqlServer" specified for connection manager is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling

• Error connecting from Schema Compare 1.4.839 to PostgreSQL 14 using Pritunl

  I'm trying to connect to PostgreSQL 14 from Schema Compare 1.4.839 using Pritunl (VPN client). So I have many network adapters / IP addresses on my laptop. When I'm trying to connect to PostgreSQL server with Pritunl is on, I get an error: no pg_hba.conf

• Devart.Data.Oracle v9.0.12.0 to v10.3.10.0: The same update doesn't always commit

  Hello, I am creating this topic because we've been having issues ever since we deployed in Production a few weeks ago. One of the biggest change we brought was a change of versions of Devart from v9.0.12.0 to v10.3.10.0. However, I've rolled back to v9.0.12.0

• Unknown error in OLEDBAccess

  We use the latest version of SDAC The program written as a service With several threads in Windows. Sometimes this address is announced and closed accidentally while working Assertion failure (D:\ProjectsClone2\Delphi\Dac\SqlServer\Source\OLEDBAccess.pas,

• EF Classic 6.5.x support of Microsoft.Data.SqlClient

  We recently got a new 6.5.x release of Entity Framework (Classic) that adds support for using Microsoft.Data.SqlClient instead of System.Data.SqlClient as the DB provider. It would be great if we could get a simple support for that in EntityDeveloper,

• Access Database "Direct" mode DDL statements not supported

  Delphi 7 with UniDac 10.2.1. We are trying to create a view in an Access database using the TUniSQL component. We are using the new "Direct" mode (which is really wonderful, by the way, because it gets around the 32bit/64bit Access Database Driver problem).

• Salesforce ODBC - How to work with *ChangeEvent tables?

  Hi there! We've recently bought our Devart Salesforce ODBC license and set it up so we can query our Salesforce via Microsoft SQL LinkedServer. I've now seen that nearly every Object has an additional ObjectChangeEvent table and I was wondering how we

• Is is possible add 'OFFSET' or any other word to reserverd keywords in dbForje Studion for MySQL 9.0?

  Is is possible add 'OFFSET' or any other word to reserverd keywords in dbForje Studion for MySQL 9.0? OFFSET now keyword in MariaDB and needs to be quoted https://jira.mariadb.org/browse/MDEV-25556

• woocommerce - unauthorized

  Hello, We've just installed the Woocommerce ODBC driver, configured it with domain name, customer key and customer secret, but we keep getting the following error message The remote server returned an error 401 : unauthorized The same credentials work

• Unprepared Execute False by default > why statements are prepared by default

  Why UnpreparedExecute is *False* by default. So you always prepare statements by default? If i understand the help correctly, this will call an additional "PREPARE". (https://www.postgresql.org/docs/current/sql-prepare.html) This is in most cases not

• [bug] with real data type

  hello, PgQuery.SQL.Text := 'SELECT 0::real'; PgQuery.Options.UnpreparedExecute := true; if not(PgConnection.Connected) then PgConnection.Connect; PgQuery.Open; It will crash at opening with an exception! and sometimes (in some queries using real data

• AzureAD Interactive Authentication

  Hi, I'm attempting to get AzureAD Interactive Authentication (auADInteractive) working with SDAC connecting to a SQL Azure database. At the moment it always asks for my password and then a two factor auth challenge. This happens every time I start the

• 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

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

• 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

• 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

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