Recent Topics
DBForge Monitor not showing some data
I use SSMS on a desktop computer to connect to certain machines, and dbForge Monitor 1.6.2 does not show me certain information on some machines: Do I need to have some port open, start some service to see this data? Thanks, Joan
Function 'sessionproperty' not supported after upgrade to 7.0.158
Hi We're working on Azure serverless SQL pools, and have been for a while. Recently SQL Complete updated to 7.0.158, and now after running each query in the editor I get an error "Function 'sessionproperty' is not supported" I am running ssms 20.2.3
reports duplication / encapsulation
If I wanted to create a report for each of 30 different locations based on a query that has a where statement something like WHERE Location = 1 what would be the easiest way to do it? If I save a report file such as location1.rdp and the query as location1.sql
Connecting to Oracle Autonomous instances with Unidac
Hello, We are using Unidac in Delphi 11 to connect to Oracle Autonomous instances in Direct mode but we can't get it to work. If we give "adb.region.oraclecloud.com" as the server and valid user/password credentials, we receive the following error: ora-03113
Anyone else questioning the point of renewal?
I work for a large organization and have gone through the DevArt ticket system with multiple different people that aren't really supporting me, just responding with lip service and no actual solutions or useful information along with the time zone barrier
SQL Complete - Is there a way to trigger a snippet while inside a comment block?
Is there a way to trigger a snippet while inside a comment block? for example in SSMS Select * from ... /* This is my comment block On the next line I want to start typing somthing that would trigger a snippet */ update ...
SQL Complete Execution History Search
Can the search be triggered manually instead of automatically after each keystroke? It's painful to wait for the search to complete after each keystroke before you can type in the next letter in the search term
Generate Script no longer exports the whole table: 10.0.46
dear devart, next to the catastrophic changes you made, which are intended, I found another issue which must be a bug in my eyes: when getting "CREATE TABLE" statements you no longer see triggers or anything else. I'm pretty sure - before the update -
dbForge Source Control adding extra Unicode characters
The Source Control inside dbForge has begun adding extra characters on the end of commits. How can we fix this? dbForge Studio for SQL Server Version: 6.5.16 Enterprise Azure DevOps And in Notepad:
SQL Query Causing "Execution Timeout Expired" even when connection execution timeout set to 0
I have a query I'm trying to run in dbForce for SQL Server that is causing an Execution TImeout Expired error after 30s, even though my connection settings are set to 0s. What's strange is I've had other queries that run well over that timeframe without
Azure Entra (AD) users not showing in sql server manager tab
In the Security Manager dashboard I can only see sql server authenticated users. The dashboard will not display the AD users that are in the database. I am logged in with the AD sql admin account, the same one I use to set and alter the AD users on the
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:
Next Page