Recent Topics
DB schema comparison script fails but Studio reports it has finished normally
I had made some alterations in the structure of a database, so i executed a schema comparison with another similar DB. I generated the differences script and executed it from within Studio. It said it had "finished successfully", but when i re-compared
Right Align Keywords?
I've created custom formatting for MySQL that makes reading the code a lot easier, but I'm not seeing any options to right align keywords? I see this is a feature in SQL Server Tools, but I don't believe it is an option in MySQL settings. Is there any
How to get the MySQL table structure
I am developing a MySQL database table structure synchronization function. The client will request the structure of the specified table on the server and receive it through the Json string. Then the client will compare whether the local table structure
Demo SFTPClient - Error "cannot send data to server"
Use demo SFTPClient When I upload a 25gb file after uploading 2gb an error occurs "cannot send data to server". The same error occurs when using the method ScSFTPClient.WriteFile --------------------------------- Embarcadero® RAD Studio 10.3 Version 26.0.36039.7899
TScWebSocketClient Negotiate/NTLM authentication
Hi I'm trialing SecureBridge library. I have a websocket server (based on c# HttpListener with AuthenticationScheme = AuthenticationSchemes.Negotiate | AuthenticationSchemes.Ntlm I have a websocket client written on Delphi using WinHTTP with such option:
ScSFTPClient - How to get the file size without having to download it?
Currently, I'm using ScSFTPClient.DownloadFile to download a file from a server to a local file. I'm then checking the file size post-download. Is there a way to get the file size of the targeted file without having to download it?
How to setup dedicated server in ODAC direct mode
Hello, we have implemented the use of 'direct mode' in our applications with ODAC, which is very useful to us. However, we would like to know what the equivalent of 'Dedicated Server' TNS connection type would be in ODAC direct mode
SQL Complete Formatting
Hi, Is it possible to format code where the values are all aligned? I've tried but could get it to work. From this... MERGE INTO [dbo].[SomeTable] AS [Target] USING ( VALUES ( 1 , N'AAA' , N'AAA' , 1 , 0 , N'CBE0001' , '2020-05-11T16:00:22.3466667') ,
Save as different framework model?
As I requested a year ago, the reason I bought this was to migrate to EF from Telerik but my models are significant in size. I just need the basic relations in order for me to migrate since they list in the hundreds if not thousands in my models as the
Arabic language
Hey devart The ODBC you present is very useful but when I'm useing it on microsoft access I found that arabic language apears as question marks like "حسين" apears "؟؟؟؟" so how can I make your ODBC support arabic language Thank you
Use Devart ODBC to retrieve and store Quickbooks access token
Hello, Is it possible to retrieve the access token that the ODBC connection uses? I was thinking I could use SQL Server Agent or other service to retrieve the access token and create 1x1 table with its value. Thank You for the help!
Access Violation - in Delphi 11 UP3 - after installing UNIDAC 10.4
Hello, after installing the latest UNIDAC version I am getting Access Violations when I try to install other components. I also have those problems within the RAD Studio when I click e.g. into the project tree - after de-installing UNIDAC - problems are
Keeping the Snippets when changing OS
IT is updating our OS and have mentioned this requires a wiping of the hard drive. Are my snippets I have created safe when I reinstall SQL Complete and sign in again?
Error when connection lost
We discussed this problem earlier on the old forum: https://forums.devart.com/viewtopic.php?t=40965 The problem is, that I already followed your hints. 1. Added MemData 2. MyConnection1.Options.LocalFailover:=TRUE; 3. RetryMode := rmReconnectExecute;
SQL Compare Fails trying to CREATE function referencing a table it is creating later in script.
Title says it all, SQL Compare Fails trying to CREATE a function referencing a table it is creating later in script. Why on earth would the order of operations be to add the function before creating a table it is referencing? Seems ridiculous. Is there
dbForge Data Compare via CrossOver crashes upon launching
Hi, I cannot get Data Compare for MySQL working under macOS via CrossOver. I followed the instructions (here: https://docs.devart.com/data-compare-for-mysql/getting-started/run-dbforge-datacompare-linux-macos/manual-installation.html and here: https://www.youtube.com/watch?v=Q05wQ2t3vXw&list=PLpO6-HKL9JxVXnlqLkk1jOSe3mf8U4kkF&index=4);
c++ builder compile error after unidac upgrade
Using c++ builder xe10.3.2, vcl win32 bits app. After update from unidac 9.2.1 to unidac 9.4.0 I got a compile error in standard includes: [bcc32 Error] ws2tcpip.h(604): E2015 Ambiguity between 'std::size_t' and 'Litecalluni::size_t' Any idea why?
Firebird 5
Hi, I would like to prepare/test for Firebird 5.0. When is a driver expected +/- ? Kind regards, Filip
I can't copy anything from the results from dbForge Search
I can't copy anything from the results of dbForge Search. There's no right mouse click menu and when I hit ctrl-c I get this error message.
SSIS Components for MySql - SSL CA Cert - How To Use?
Hello, we have a MySql Database that we'd like to connect to. The database asks us to activate the following property: require_secure_transport=ON Where can this property be set? Also, which format is requested in the "SSL CA Cert" option in the manager
[DEVART][ODBC][PostreSQL]Trial period is expired
hi, last year i tried devart odbc driver for postresql on a server with windows2012 R2, it was for a POC with an instance postressql for test. now i want to industialise solution and before buy devart odbc driver, i want to try access on the same but
TSmartQuery SQLTYPE property sometimes 0 when in Direct Mode
Hello, When in Direct mode, and running certain SQL in a TSmartQuery, the SQLType value is zero. Some examples are: CREATE INDEX test_ind ON TEST_TBL (EMPNO); ALTER TABLE TEST_TBL ADD (ddd DATE); It works correctly for these statements: create table test_tbl
Error "System.InvalidOperationException: Transaction already exists."
Hi, That error has already been mentioned here, but no solution. Wen can reproduce by doing this: //-------------------------------- try { //--step 1 try { Data1 dat1 = new() { field1 = 1, field2 = 2 }; ctx.Add(dat1); ctx.SaveChanges(); } catch(Exception
No DbUpdateConcurrencyException when OracleDbContextOptionsBuilder.MaxBatchSize > 1
Hi, we have an issue while enforcing optimistic concurrency in combination with an OracleDbContextOptionsBuilder.MaxBatchSize greater than 1 (eg. 50): there is no thrown DbUpdateConcurrencyException when there should be one. How to reproduce: Create an
Query Profile Mode but???
Hello, I am in try version with dbForge for a new project using postgresql database. I see you have query profile mode but I don't see catching statement when I process from my UI. What I mean, is it possibility to catch all incoming statement like SQL
SQL Server Always On feature
Do SDAC components for Delphi support SQL Server Always On feature? The "FailoverPartner" property was added for mirroring, but I am not sure if it would work with Always On.
Alerter on Postgres
HI. We have set up an alerter in Postgres (15) on linux ubuntu 22.04. The alerter works when we listen in psql on the server, but placing the Unidac alerter on our server application doesnt seem to do anything. I have put log messages in both the onerror
ODAC (direct mode) non-blocking
I am having an issue with ODAC non-blocking queries. Expected result: The .open method returns immediately. Actual result: The .open method does not return until the SELECT has completed the non-data transfer part of query. In practical terms, that means
TVirtualQuery Float field loaded as memo
Hello, I have a DataModule that I use to do some calculations and eventually display a chart. I have a TTable component with 2 Float fields (Rate and PieceRate). I assign this table to a TVirtualTable (vtPools). There are other tables as well. Next I
Is there a bug in SDAC Component ?
Field of type Data is treated as a widestring when the application runs on a computer other than the computer on which SDAC is installed. each reference to a date field generates string to date conversion errors, ONLY on the computer where delphi (XE")
Old DLL Reference (Devart.Data.PostgreSql)
Hello, in my Web Forms App I did upgrade to current Devart DLLs but there's somehow a hard reference to an older DLL and the only way I could solve it, was by using a DLL redirection - see below. Here's what I tried to solve it the right way: - I removed
SQL Schema Compare between revisions of TFVC
Im using Source Control on TFVC. When I'm trying a comparison between different changeset, the source is always empty and the result is a drop for every object in the target. For example between head and changeset 5 there's only a change But the tool
SecureBridge wws certificate validity
I am trialing SecureBridge WebSocket client. when I connect to a test server with wws the response from the server is "the certificate is not within its validity period". this is just a dev/testing environment so you can I for testing accept the error
Issue when migrating data
Hello, I face this error message for every table inside my schema. although I just created the schema structure only and all tables are empty. I did this step while leaving it without tables and let dbforge create the tables, miss the already configured
please add support for mariadb 10.11.2
thanks
SQL commands of dbForge Studio for MySQL GUI's backup action
Hi all, Is there a way to read what is the SQL commands of action click in dbForge Studio, like a backup click action on database backup and restore page? Regards, bobojin
"Auto refresh" when adding
Hi guys, This is a feature request (or a bug report?), it's been years I haven't had one due to your tool being too complete ;) When I create a new table, database... I have the refresh the database explorer. It'd be great if once the creation has succeeded,
execute procedure via dbforge studio give error cursor does not exist.
While executing the procedure via dbforge studio, it gives an error: Cursor <cursor_name> does not exist. But the same code runs in pgadmin, and it's working fine. call ea.usp_procedure_name(parm_1,parm_2,'ref_result_data1'); fetch all FROM ref_resu
Expecting Devart.Data.Oracle.OracleConnection but got Devart.Data.Oracle.Entity.av when using DbConnectionInterceptor
Version used: Used NuGet Package in .net 6 Project: Devart.Data.Oracle.EFCore 10.1.134.7 Problem: I need to Intercept the DbConnection to set some metadata but when using Microsoft.EntityFrameworkCore.Diagnostics.DbConnectionInterceptor instead of getting
[Devart][ODBC][Adaptive Server Enterprise]Invalid activation key ??Trial version
hello, We have successfully installed and efficiently configured Devart on our iMac M1 with the latest operating system, Ventura 13.4. As we opted for the trial version, we encountered a minor setback during a connection test—a vexing error message appeared:
Next Page