Recent Topics
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
V7.0.158 has broken Intellisense support when working with SQL Queries
Myself and another developer in my company upgraded from v6.x to v7.x and now intellisense for selection of Tables/Fields via the dropdown in the SQL editor no longer work? The dropdown shows completely unrelated options and NONE of them help with table/field
UniDac with Quickbooks QODBC - Enterprise
I am trying to use the QODBC driver to create a "simple" report for Positive Pay for the bank using Delphi, UniDac, and QODBC. I can connect to the QB DB, but opening the BillPaymentChecks table only returns ONE record. Presumably the top/first record.
Set connection parameters via command line
Hello, we would like to use dbForge for MySQL with PAM solution (not Percona) that requires setting connection parameters via command line (username, password, dbname) to launch dbForge for MySQL application on Windows. Is that possible?
Oracle 19.24 + ASO + DirectMode
Hi I just applied Oracle 19.24 (Security Patch July 2024) to my database and the direct mode no longer work If I disable native encryption it works. Test case: $conn = New-Object Devart.Data.Oracle.OracleConnection('Direct=true;User Id=test;Password=***;Port=1521;Service
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
Intellisense/Suggestions for Locally Created Temp Tables?
I create local temp tables and query from them often in my script. In my previous installations of SSMS with (and without) SQL Complete, I was able to write "SELECT * FROM #" and would receive suggestions for available temp tables to query, including
HasConversion not working with EF Core 8 when converting an Enum
Hi, We're using HasConversion<string> to convert an Enum to string and vice versa but it's throwing an Exception. We've also tried the following syntax : .HasConversion( v => v.ToString(), v => (EUserType)Enum.Parse(typeof(EUserType), v)); But we're getting
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 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
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
Errors testing backup db with 20+ tables total 10GB
Hi, My first question evaluation dbForge Studio for MySQL, after a few days testing other stuff through the evaluation of ENTERPRISE. The "only" special circumstance is that it is on a MariaDB 10.4 db enginge with tables in innodb. I have verified that
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).
Can you change the name on a United Airlines ticket? FAQ OTA FAST SUPPORT [[[UNITED™ ]]
Can you change the name on a United Airlines ticket? To change the name on your airline ticket, Dial at +1 - 888 - 908 - 0815 (AA) or visit the United website and select the "Manage My Booking" option, call customer support at +1 - 888 - 908 - 0815, or
Can you change the name on a United Airlines ticket? FAQ OTA FAST SUPPORT [[[[UNITED]]]
Can you change the name on a United Airlines ticket? To change the name on your airline ticket, Dial at +1 - 888 - 908 - 0815 (AA) or visit the United website and select the "Manage My Booking" option, call customer support at +1 - 888 - 908 - 0815, or
After database upgrade from 19c to 23c, connection in Direct mode gives "NET: Invalid input arguments" error
Hello, A user has a database that was upgraded from 19c to 23c. When the database was on 19c, he could connect using our application (using ODAC in DIRECT mode). Then the database was upgraded to 23c, and now he gets the above error. He says that he can
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
SSL connection problem in dbForge Studio for MySQL
Hello. I have a problem with SSL connection in dbForge Studio for MySQL on one of my machines. An account in the database has 'REQUIRE X509' option, so it's required to specify a client key, certificate and optionally CA to connect. I have specified all
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
Trial Period expired
Hello! We have been using the ODBC driver for SalesForce (SQL Server) for almost a year and it has started in the last 24 hours giving the trial period expired error. Our license is valid until 2026, has anyone experienced this before?
Invalid SQL when ordering on a calculated boolean field: "ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering on a calculated boolean field. This is an example of the invalid SQL: SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m0" WHERE "m0".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END) "HasMoreThenOneModel",
Ora error when filtering/ordering on a calculated boolean field: "ORA-00933: SQL command not properly ended"/"ORA-00920: invalid relational operator"
We are experiencing malformed SQL when ordering/filtering on a calculated boolean field. This is an example of the invalid SQL SELECT "c".ID, "c".NAME "Brand", (CASE WHEN ( SELECT COUNT(*) FROM MODELS "m" WHERE "m".CAR_ID = "c".ID) > 1 THEN 1 ELSE 0 END)
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
System.AccessViolationException when having parallel db writes using Devart.Data.SQLite.EFCore
Hi, I've observed and AccessViolationException when running unit tests in parallel. Investigating this I found out that creating multiple different databases, or even inserting new entities in a database, in parallel can cause this exception: Fatal error.
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.
DateTimeOffset.Date does not correctly truncate time in dotConnect for PostgreSQL
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. We have been using multiple methods from the DbFunctions class, many of which were removed in EF Core. From my understanding, DateTimeOffset.Date
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
Next Page