Recent Topics
DbForge studio for Oracle connection issue with proxy user
I have oracle DB that is installed on server and want to connect to it via proxy user but it's seems like the application can't connect to the DB even the same connection string is working fine on other application. Please note that I have no DBA privilege
dotConnect C# MySQL: Setting charset at global level?
I'm using the generated great TableAdapters in C#, where I had errors with my Hungarian strings (containing á, é letters) until I added any of these before opening the connection: this.Adapter.InsertCommand.Connection.Unicode = true; this.Adapter.InsertCommand.Connection.Charset
AI Assistant code generation incorrect (missing chars)
I've been working with testing query optimization this morning and finding that the generated queries are not displaying the greater than or less than symbols. For example, a condition 'WHERE someNum <> 0' gets generated as 'WHERE someNum 0'. Any way
UUID V4 and V7 are now available, Is it in DBForge ? If not, can it please be added
HI ! I see that UUID_V4 and UUID_V7 are now implemented in MariaDB v 11.7 (11.8.2 is the current release) https://mariadb.org/always-use-the-right-uuid/ Does DBForge have the ability to set the UUID as V4 or V7 in the table builder ? If not, can we get
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
connection "forgot" parameter "enable DBMS output"
Hi, after automatic reconnection connection "forgot" parameter "enable DBMS output". dbforge studio for oracle 2025.1.34
Changing any paramaters in a NEW unsaved stored procedure, cleaars all of the SQL code section
HI ! This is for DBForge studio 2025.1.134 It did the same thing in 1.124 as well. I thought I saw this posted already. I went looking for it but could not find it. so posting it here. If you create a new stored procedure, then go to the SQL code section
Access Direct Mode Connection Fails if Database has a Query (View)
We get EAssertionFailed with a message beginning "jTYPE_ATTRIBUTE" (JetTable.pas line 5126) when using an Access database in Direct mode, but only if there is a query defined in the database. We are using UniDAC 10.3.1 for Rad Studio 10.4. Recent release
Feature Suggestions : DBForge MySQL - Table Template
HI ! I have an idea for a feature enhancement. (currently using 2025.1.124) We design many of our database tables with several of the identical fields. id int(11) NOT NULL AUTO_INCREMENT, DateUpdated datetime NOT NULL, IDUpdated int(11) NOT NULL, VisitorID
DBForge MySQL - BOOL fields converted to TinyINT(1) on their own
HI ! Not sure If this is a bug or a new feature. But I just noticed that ALL of my fields that I created as Boolean types, converted themselves to TinyInt(1). Every one of them in the entire database. This is 2025.1.124. Is this supposed to happen ?
TUniLoader
I'm using TUniLoader with SQL Server and it works fine. I would to know when the component finishes writing data on the database. Is it at the end of OnPutData event?
Query Builder overwrites my text and generates a query with errors?
dbForge Studio for MS SQL version 7.1.63 (Windows 11) Steps to Reproduce: 1. New Query 2. Add tables to the Query Builder 3. Give tables alias 4. Join on fields as needed 5. View text tab and qualify fields with alias (manually type them in) 6. Return
Feature Suggestions : DBForge MySQL - Table Designer SQL Direct Edit/Paste
As In my other post about how we design many tables with the same basic fields of data, It would be very nice to be able to open up a new table, create the fields we want, and then paste in directly in the SQL section a template of multiple fields. For
Cannot decrypt procedures on Azure SQL
I have the free Decryptor product and would like to use it on Azure SQL. Whenever I try, I get the error message "dbforge SQL encryptor DBCC command 'DBINFO' is not supported in this version of SQL Server." Is the decryptor compatible with Azure SQL.
DBForge MySQL - Linking Tables with FK shows up in random spots
HI! First time posting here, NEW User ! Whoo Hoo ! I just installed the latest of DBForge Studio for MySQL - 2025.1.124 I like the product. So far, I am very happy I noticed something though and wondering if this can be looked at and changed. When I create
Restoring Tabs After Restart Getting Worse
dbForge Studio for SQL Server 2025.1.124 seems to be noticeably worse at restoring tabs after a restart. I'm down to two sql tabs being restored from about the ten I had yesterday after a couple of restarts.
ScFTPClient.Upload - Change the folder or file permissions on a web space
Is there a way to change the folder or file permissions on a web space to 755 or 644 using the ScFTPClient component ( sendcmd? ). Can you send me an example for C++ Builder XE4. Thank you.
SQL Complete No Longer Shows Column List For Trigger Tables
I could've sworn SQL Complete used to show the column names for the inserted/deleted tables in the list members CREATE TRIGGER [dbo].[tu_Contact_StandingId] ON [dbo].[Contact] AFTER UPDATE AS BEGIN IF UPDATE(StandingId) BEGIN INSERT CapitaTransaction
New AI Feature in dbForge Studio for SQL Server
Good start but a bit rough when actually using it, both in terms of UX and output. My first prompt, "Explain this query", resulted in a 500 internal server error. I figured out I had to include the query with the prompt but in these cases, Studio should
Handling of NaN > DevArt Connection Exception
Hi, PostgreSQL DataAcess Components if there is "NaN" in a Numeric column (that is allowed per default by postgres). Devart will fail. The following easy example shows the problem, DevArt is unable to open this dataset. If there is one row in 1000000
SQL Complete Support for Synapse/Serverless
We are moving our SQL Servers to Synapse/Fabric, and are using the Serverless options. However SQL Complete does not work with these. Are there any plans on making it compatible?
Upgrading SSIS Data flow for Salesforce Issue with License
Hello, We are using the SSIS data flow component 1.7.x for salesforce. It has been working for years. Now we have migrated servers (SQL2014=>SQL2019) and when deploying the SSIS Package and scheduling it to run using SQL Server agent we get "Cannot find
exec current statement for pl/sql bloc containing JSON_OBJECT cause error
hi, running this block via execute current statement cause error 1 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; <an identifier> <a double-quoted delimited-identifier> The symbol ";" was substituted for "end-of-file"
How to compile a db object loaded from a file?
I can't find any documentation on how to use DB Forge Studio for Oracle to load a package spec and body from a file on my PC and then compile it. It only seems possible to create them from scratch or to edit existing objects. My team keeps all of our
Unexpected SqlParameterExpression implementation when using Oracle spatial functions in EF Core 8
We are planning to upgrade EF Core 6 to EF Core 8 along with upgrade from .NET 6 to .NET 8. We frequently use Oracle spatial functions: "SDO_RELATE" and "SDO_WITHIN_DISTANCE", which unfortunately do not have built-in support in dotConnect for Oracle according
"Go to definition" jumps to the package specification, not the package body, like a shift+F12
Hi. Thank you for last update DBForge studio for Oracle to 6.0.85. Great job. Fixed many bugs. But at the same time a new problem appeared - "Go to definition" (F12) makes jump to package spec. (like a shift+F12) rather then to package body, . Reloading
[FEATURE REQUEST] Add Chat-GPT to the Editor !
hey devart team, if you make this possible, i guess all people will say only one thing to you:
magic disappearing Data Viewer window
after jumping from Find and Replace window to Data viewer (mouse click) it magic disappear (get empty) dbForge studio for Oracle 6.0.85
When connect via SSH to Mikrotik, the byte stream is broken
For example, when executing the command: ip/service/print detail proplist=port value-list where name=api We get the result: ip/service/print detail proplist=port value-list where name= [admin@MikroTik] > ip/service/print detail proplist=port value-list
create new database,user
Hello, i download dBforge studio for postgres and try to create database, table or user but there is no option for that as Mysql tool. so i missed something or it is limitation in this product? if it is limitation, are you going to develop it so that
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
Debug SP in SQL Studio
Hi I am trying to debug SP in Studio for SQL Server it is workign well and, I also can see veriable value which declare in SP like int or nvarchar veriables. but if i ma using tbale veribale like , CREATE TABLE #TempValidation ( TempValidationID INT IDENTITY(1,
Unidac connect to Oracle with LOAD_BALANCE
Hi, it's the first time I have to connect to an Oracle server in a datacenter with Load_Balance feature; I have received this connection string: PROD_SIT_DB_PROD= (DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.148)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.149)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=178.168.75.150)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PDB.subset.vcnphx.oraclevcn.com)))
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
Unidaq Provider for NexusDB Embedded in Delphi 12.3
I'm trying to use UniDaq in Delphi12.3 to connect to an embedded NexusDB. I followed the instructions and recompiled nexusprovider290.bpk, which created a new nexusprovider290.bpl file in the ${DELPHICOMMONDIR}\Bpl folder, which is included in the path
LinqConnect - change database at runtime keeping a single connection
Hi, I am testing a trial version of LinqConnect. I have a bunch of databases which all have the same table structures. In EF Core, I can create one DbContext and easily switch between the databases using ChangeDatabase: MyDbContext.Database.GetDbConnection().ChangeDatabase(<MyDatabase>);
How to use dotConnect for Oracle Express Edition?
I am using dotConnect for Oracle Express edition, Can I reference to the library using NuGet or have to install manually?
Stop tab rows from shifting in dbForge Studio
I have "Show tabs in multiple rows" on. Is there a way to stop the tab row of a clicked tab from always being moved to the bottom row? It's not helpful having tab positions always being moved around and no other IDE I use does this.
dbExpress Driver for SQL Server support for TLS 1.3
Does dbExpress Driver for SQL Server supports TLS 1.3?
Python xbase connector Trial period has expired in the running computer
Hello, I am using the devart_xbase_connector-1.2.0-cp312-cp312-win_amd64 activated in my development computer (Laptop) and it works normally. I have created a utility program that does various things in a fox-pro database which I run on my other PC (Desktop)
Next Page