Recent Topics
Computer crashes when opening SSMS
The two members of my team (including myself), who have dbForge SQL Complete installed, are having issues with our computers crashing every time we open SSMS 20.2. Since it's happening just to the two of us with dbForge, we're suspecting that it's the
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)))
DotConnect for SQLite TransactionScope
Hi, I am trying to use TransactionScope together with EFCore but I am getting this error: System.InvalidOperationException : Cannot enlist local transaction, because current global transaction already contains distributed transactions. Stack Trace: DbConnectionClosed.Open(DbConnectionBase
Passing parameters to TUniStoredProc without SELECT privilege
Hello. I have MySQL database with some of the stored procedures for accessing data in it. The only global privilege enabled is EXECUTE, others are disabled. I'm trying to call a stored procedure in MySQL database with the help of TUniStoredProc using
Table names always renamed as lowercase versus PascalCase
Is there a way to turn off this automatic table renaming to lowercase? When creating or modifying tables in dbForget Studio for MySQL v10.1.165, it always renames my tables as lowercase or camelCase. Our coding standards are PascalCase, which is causing
Update SQLite Direct ?
Hello, Any ideas why you don't update the SQLite direct to the latest version ? Thank you
SSMS 21 Support
I'm starting to test SSMS 21. Is there a roadmap of when you might add support for SSMS 21?
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
invalid bytes count error - DotConnect for Oracle
Hi, we moved from Oracle 12c to 19c and upgraded Devart.Data.Oracle to 10.0.0.0 and to Devaty.Data.Oracle EntirtE6 and we getting that error invalid bytes count right at the start up, during getting user profiles from database. What can be a reason for
How to get entire BLOB content with dbExpress
I have a Firebird 3.x database with UTF8 characters, connected with Devart dbExpress from a Delphi Intraweb program and cannot get it to display more than one character of a BLOB memo field. Presumably I need to set something different when connecting
.NET 9 - Devart.Data.Oracle.EfCore - NullReferenceException
Hi, On EFCore 9, with today driver v10.4.191.9, many operators are failing with this error : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression.PushdownIntoSubqueryInternal(Boolean
MyDAC MyConnection ignores Password
In various circumstances, the TMyConnection "Password" field doesn't seem to work properly. 1. In the Delphi Object Inspector, right after I enter a password into the Password field, if I then set Connected to True, a connect dialog pops up with the Password
MyDAC and SDAC question
I am trying to retrieve data from MS SQL Server (about 40000 records) and copy them to TDictionary as fast as possible. My problem is that it is slow and some setting changes give strange results. What I do is: 1. I open TMSQuery object MSQArt, it takes
IGGM - Is Diablo 4 Season 8 Really An Exciting Boss Challenge?
On March 11, the game developer released the PTR of Diablo 4 Season 8. After a week of experience, players have different opinions on the content of the new season. Diablo 4 Season 8: Belial's Return is speculated to be officially released at the end
POECurrency - What Surprises Will PoE 2 Patch 0.2.0 Bring Us?
The trailer for PoE 2 Patch 0.2.0 has been released. The female character running in the forest with a spear has aroused many players' expectations for this update. The official release date is not far away. Perhaps players can get a glimpse of more from
MyDAC Bug 12.4.0
I just switched to the new release and re-compiled my projects. Now I get this error, when I start my program: assertion failure "d:\jenkins\workspace\DAC\MyDAC\Delphi\Dac\Common\Source\CRVioTcpSSL.pas"
The keyword "then" causes inserting ifthen snippet
Hi, "then" keyword causes to inserting "ifthen" snippet dbforge for oracle 6.0.85
SSMS Results Grid > copy as Excel format
The "Copy Data As" results grid options have been very useful for years, but one extra thing would still be super nice to have: "Copy As Excel". I'm sure everyone has seen issues with data types when copying directly from SSMS into Excel, often changing
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)
no prompts for package procedure parameters
dbforge for oracle 6.0.85 and prev
memory !!
Hi, dbborge for oracle 6.0.85 something wrong with memory consumption and this is not related to large dataset suddenly dbforge was freezing for some minutes and i needed to kill process i have catched same case two times , previous version dbforge have
how to specify the version of sql server used when generating synchronization script
My Sql Server install is 2019. When I generate a synchronization script, I need to specify that the script generated works with Sql Server 2014 (other sql installs on different computers). I am currently using dbForge Schema Compare for Sql Server Professional
Unitable isindex and lookup do not work
Hello, i am using a UniDac UniTable to access a SQL server database. To view the structure of the table i need to know which fields are index fields and which ones are lookup connections. The tunitable has two properties which should give this information:
UniDAC 10.3.2 - Returning - Firebird 4 / Firebird 5
With 10.1.0 “Added support for multiple rows being returned by DML with the RETURNING clause” was introduced. I have now noticed that in a query with returning with Firebird 4 the returning is in the params (fields empty) and with Firebird 5 in the fields
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
scroll problem in table editor
hi, as for me something wrong with panel scrolling in table editor also good place for field comment is main column list rather column property. It's only my opinion of course. Thank you
UniDAC 10.4 Source Installation
Hi, I am trying to use Make.bat using Make.bat Delphi WIN32 but get the error: Embarcadero Delphi for Win32 compiler version 36.0 Copyright (c) 1983,2025 Embarcadero Technologies, Inc. odbcprovider290.dpk(28) Fatal: E2225 Never-build package 'rtl' must
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 place an image in the background of a report and have the data visible on the image?
Hello, I'm trying out dbForge Studio for SQL Server and want to place a background image on the entire report page. I'm using the image object to insert the image I need, but when I place it in the background and add fields over the image, they don't
no possibility to reset check box "not null" in table editor
Hi,scenario: 1 open table editor - ok 2 add new field - ok 3 set "not null" check box - ok 4 jump to another field - ok 5 return to my new field - ok 6 try to reset "not null" check box - ok 7 jump to another field - fiasco - "not null" check box return
document outline break down
this line break down document outline dbforge for oracle 6.0.85
"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
Prevent ODAC from appearing in Delphi main menu
Hello, After I install ODAC components into Delphi, "ODAC" is inserted into Delphi's main menu. Is there a way to prevent (or remove) this? Thanks John Dorlon
Delphi 12.3 64bit-IDE support
Hi when can we expect the design-time controls for the 64bit IDE of Delphi 12.3 for the Delphi Data components ? Kind regards, Erik
ORA-00918: column ambiguously defined for paging mode (
hi, i got error while getting next page of query result. for first page i have warning - it's Ok. but for next page i have ERROR 1 ORA-00918: column ambiguously defined SQL3.sql 3 8 Yes, i really have repeating column names, but without paging or for
header of tab sometimes not in visible position !!!
Hi, sometimes the tab header is not in visible position after opening new tab and need to scroll tabs for finding it.
'relation "__EFMigrationsHistory" already exists' when running multiple migration sets
Hello, I am working on upgrading my company's application, based on dotConnect for PostgreSQL, from EF6 to EF Core. The application has multiple modules with migrations for module-specific entities and all migrations are applied to the same database.
[PgDAC] Error when executing SQL Query in table with blob files
Hi there, hope you'll ok. I recently started using PgDAC for queries that works with blob files, especially using the "execute" command of PostgreSQL (version 16). When i execute the query, i'm getting the following error: "ERROR: Assertion failure (D:\Jenkins\workspace\DAC\PgDAC\Delphi\Dac\PostgreSql\Source\PgSQLProtocol.pas,
New BOOLEAN datatype not supported with Oracle 23ai client
Hello, I am using the latest version of ODAC and Delphi. When I connect to an Oracle 23ai database, using an Oracle 23ai client, and I select (using TSmartQuery) from a table that has a column of datatype BOOLEAN (for example: Select * from user_domain_cols),
TScFTPClient 'FTP server error occurred: TLS required, configure with AUTH first.'
Get the EScFTPError 'FTP server error occurred: TLS required, configure with AUTH first' FFtpClient.TLSMode := tmRequireExplicitTLS FFtpClient.SSLOptions.IgnoreServerCertificateConstraints := true; FFtpClient.SSLOptions.IgnoreServerCertificateInsecurity
Next Page