Recent Topics
dbForge doesn't release a file after importing it
dbForge doesn't release a file after importing it. I can't delete it because it says it's locked by dbForge. I have to use an unlocking tool or close dbForge. dbForge needs to release it after the import is done.
SQL Complete Formatter aligns identifier case regardless what is defined in database
Hi, I have come across situation where SQL Complete code formatter will align column name case to be identical when the column names are identical, even though in actual database the column name might be different. For example, if I have the following:
Find dialog. "Look in" option switched to "All open Documents"
After changing active tab "Look in" option in find dialog often switching to "All open Documents". why ? it is VERY inconvenient !! why would not process searching in current active tab by default ? thank you
F7 does not switch between document views
Using dbForge Pro for SQL version 6.5.16 under Win11 Pro. The current keyboard mapping uses F7 for the Object Viewer. I'd much rather have F7 switch among the available tabs in the current document (typically text and data when working with queries).
UniDac DBF Direct Connection - PACK Table
In the UniDac documentation, in the native DBF provider section a mention is made that PACK-ing of DBF tables (files) is supported. Searching the source code I came upon the TDBFDBase class which implements the PackTable method. I tried to use it by creating
UnpreparedExecute not set for migrations
Hello, I have ran into issue with dotConnect for PostgreSQL with EF Core. After adding a custom script to a migration, i get a Devart.Data.PostgreSql.PgSqlException with a message "cannot insert multiple commands into a prepared statement". I have the
Unidac - MSSQL - Linux
Hi everyone I am migrating a REST application (DMVC Framework) that uses Unidac to access a MS SQL Server 2022. When executing a query with data containing accented characters, all of them are replaced by "?". When compiled and executed on Windows, the
Salesforce ODBC - null-able columns marked as not null?
Your ODBC driver reports some columns as not null-able and then sends rows containing null values for them: Calendar.Name DuplicateRule.Language EntityDefinition.LastModifiedById FeedComment.HasEntityLinks FlowDefinitionView.LastModifiedDate Folder.Name
Ongoing problems with TIMESTAMP datatype
Hello, This problem with timestamps in the TZR format still exists in the latest version. https://forums.devart.com/viewtopic.php?t=36016 Similarly, I have had this request for years (the ability to configure time stamp format) https://forums.devart.com/viewtopic.php?f=5&t=44301&p=178343&hilit=tzr#p178343
SDAC Connection Pooling with TWebModule in Linux environment
We are trying to evaluate whether we can, and exactly how, we can use connection pooling with TWebModule in a Linux env (Apache specifically). We have essentially stripped all threading from our application as it does not seem to play well under Linux.
Metadata Caching and Refresh When Closing dbforge Application
Is there any ability / options to cache and restore database metadata when an instance of the dbforge application is closed and re-opened? Our primary Oracle database has thousands of objects across dozens of schemas, and it takes a long time for the
mysql restore of 20gb script
We're trying to restore a backup of 20GB. The restore dialog in DBForge says nothing about whether the restore is run in a transaction or not. Question is does it run in a single transaction and if so can we control this?
Assertion failure - Devart on Delphi 10.2 Tokyo
Hello, I am having trouble using Devart to connect to PostgreSQL. I am currently using Delphi 10.2 Tokyo and C++ Builder 10.2 Update 2. The error message is: Assertion failure (D:\Projects\Delphi\Dac\PostgreSql\Source\PgClasses.pas, line 4195). I would
Working with PowerShell/CLI
hi, Trying to automate the schema compare function. I used the wizard to generate the CLI Script. It's comparing script folder to an Azure Sql DB. The script generated is the following: &"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge
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!
Error: "Invalid parameter "
Hello. I'm using the SQL-Server dbExpress, version 9.3 with Delphi Athens. On my development computer the connection with the database is workink perfectly. However, when I tryed to execute the application in a different computer I get this error message
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
Next Page