Recent Topics
"Profile server events" tool require VIEW SERVER STATE permission
"Profile server events" tool require VIEW SERVER STATE permission. But at the same time the original ms "SQL server Profiler" perfect work under the same account without VIEW SERVER STATE permission
'Invalid parameter specified' on prepared query with a double
In our project we get an Exception: 'Invalid parameters specified'. We've determined that this is specifically when we use a double variable. In the scenarios below the first two instances of TPgQuery are executing properly, however on opening the third
ConnectDialog
Hello, when trying to open the connection to the database, if it fails, it shows me the ConnectDialog even though I don't have any associated TConnectDialog component, I need it to mark the exception and not show the ConnectDialog. How do I do this?
[9.1.21] Unresolved error when using JSON_TABLE function against simple scalar JSON array.
For some strange reason, the following valid and correct JSON_TABLE command generates an error when executing the following statement in a new query window or stored procedure. SET @json = CONVERT('[1095, 1106, 1193, 1288, 1357, 1385, 1390]', JSON); SELECT
Why should I buy Devart ODBC for SQL Server when I can get the MS equivalent for free?
Hi guys. I would be interested in purchasing the Devart ODBC driver for SQL Server, but I can't see it has a real advantage over the MS equivalent. Indeed, the server version price will raise from May 15th. Please, would you make it clear for me what
ODBC for Firebird: Problem with case sensitive table and field names
Hi, We've downloaded the trial version of the ODBC driver for Firebird. We are using Firebird 4. We are interested in purchasing the ODBC driver for Firebird, but it depends if the problem that we are seeing can be fixed. We are testing PowerBI with the
Number(20) cannot be read!
Hi, using c++ builder 10.3.2, unidac 9.2.1. I have an oracle table with column number (20) populated with numbers having 17 digits create table pelidetail(id number(9), peliid number(10), sortweight number(20), primary key(id)); insert into pelidetail
SQL Server LockTimeout not working?
I am using Delphi XE10.3.2 with UniDac 9.3.0. SQL Server We have a problem with a MS SQL Server Stored Procedure that frequently comes up with a "Lock request time out period exceeded." error. The SP basically does a lot of table Truncates and then INSERT
BREAKING CHANGE - Default Encrypt with Microsoft OLE DB-Driver 19 for SQL-Server
Hello I create a database connection with all standard parameters (TUniConnection.SpecificOptions) to MS SQL Server MyConnect := TUniConnection.Create; MyConnect.ProviderName := 'SQL Server'; MyConnect.Database := <DBName>; MyConnect.Username := <DBUser>;
Unidac 9.4 and SQL-Server
I'm trying to connect to a SQL-Server database. This works without any problems with Unidac 9.3.0. After installing Unidac 9.4.0 the application crashes. The reported error is 2.5 Type : EMSError 2.6 Message : TCP Provider:_Es konnte keine Verbindung
dbforge schema compare for mysql not generating html from command line
dbforge schema compare does only generate an empty report when running it from command line. From gui, everything works fine. The comparison itself looks fine, log files look good, just the report is not created properly. the generation seems to abort
PgDAC on MAcOs
Hi am testing your Demo Mobile program with Delphi Alexandria 11.3 and PgDAC Version 7.4.0 using Mac Pro Book M2 chip . In this Demo on postgres Schema fish when i use Greek language on Mac not appear correctly Mac Running Windows Running
SetEmptyStrToNull does not work correctly
Hi, we have a problem with varchar fields, wich are not set to null even if we set SetEmptyStrToNull to true. If the value of a field is an empty string it all works correctly, but if we have an fields with a string with only spaces, then the field value
Memory leak in UNIDAC connecting to Oracle
Hello, I'm facing a memory leak in Unidac accesong to Oracle: 1. Oracle 12C 2. Delphi 11.3 First of all, on client side my customer was facing a problem after days the system is running and doing one task that executes every minute, a NET. Invalid pointer
Learning : How to save a Virtual table in SQL Tables
Sometimes we need to store a memory table (Virtual table is the best :) ) in a field of a database table. I present these 2 sub-programs and how to use them as a review. //--------- Wide string to TStringStream
procedure TDMT.WS2Mem(S: string; Var K
How to browse Linked Servers - SQL Server
I’m using dbForge for SQL Server Enterprise, how can I use this to browse Linked Server objects? I can do this with SSMS’s Object Browser, but I’d like to not have to switch between 2 db tools.
Build Solution In MS hosted
Bonjour We have solutions .Net with differentes TargetFramework and version Devart Exemple Solution Number 1 TargetFramework : .Net 4.7.2 Devart version : 8.5.583.6 Version=7.1.40.0 Solution Number 2 TargetFramework : .Net 4.0 Devart Version=8.5.583.6
EntityDac 3.2.0 and Firebird 2.0.7
EntityDac 3.2.0 Firebird 2.0.7 IBDAC 8.3.0 Expression: From(ti).Where(ti.TRANSID = AId).OrderBy(ti.ID).Select(); Result: SELECT t1.ID ID, t1.TRANSID TRANSID, t1.ITEMCODE ITEMCODE, t1.OPIS OPIS, t1.OPISDOD OPISDOD, t1.KWOTA KWOTA, t1.SZTUKI SZTUKI, t1.WAGA
MySQL Router SSL Handshake error dotconnect mysql
I am trying upgrade my development machine and need to reinstall dot connect on the new machine, however, I cannot get dotconnect to work with mysql router - even though it's setup the exact same on the current development environment. I always receive
TMyDump from v8 to 5.7 charset problem
Hi Is there a way to specify the charset and collation when perforing a backup and restore? We have a clean set of data that we use for install that is on a Mysql 8 server but ur clients are using 5.7 We get the following error. I could perform a replace
missing compatible file : libdevartodbcase.2.1.4.dylib
Hello, we installed odbc driver for sybase 2.1.4 on macos M1 bigsur 11.6 and the error below is generated when trying to connect excel to sybase DSN : Could you please help us with this urgent issue Thanks in advance for your attention Kind regards,
Property EncryptedPassword does not exist
Good afternoon, I have a problem with one of the legacy systems here at the company, it is unfortunately developed in Delphi 6. My problem is that I updated the Delphi ODAC that was in version 8.6 to version 11.4, but when updating, when trying to compile
Creating and Updating MySQL Database Schema on Remote Devices Without DBForge Installed
Hi everyone, I am facing an issue with creating and updating a MySQL database schema on customer tablets that do not have DBForge installed. I have already created the schema using DBForge for MySQL and can export it, but I'm not sure how to create the
How do I insert an image file into a TVirtualTable Blob field?
Hello, I know how to insert blobs into TUniQueries. But I could not find the way to do this in a TVirtualTable. It does not expose any AsProperty which can sugest I can use a LoadFromStream method. Thank you very much. Jayme Jeffman Filho
TDADataSet
After reading Unidac 9.4.0 Revision History, I have a question: which unit TDADataSet class is declared?
dotconnect for Quickbooks
I have doconnect for SQL Server. Can the dotconnect for Quickbooks co-exist? I got an error when I tried to install the Trial version.
Is there a way to remove decryption out of sqlite db
Hi, I use dotconnect universal with sqlite and the Encryption of SQLiteCrypt: UniConnection conn = new UniConnection("Provider=SQLite; Data Source=database.db; Encryption=SQLiteCrypt; SQLiteCrypt License Key=00000-000-0000000-00000; FailIfMissing = false;
Cannot connect to Amazon Redshift
We have been evaluating the dbForge studio as a solution for maintaining the databases and schemas in our DWH, which is Amazon Redshift. According to documentation, dbForge studio for Postgres should be able to connect to Redshift (as Redshift is postgres-based),
Unidac's TUniquery Can Not Filter Special Four decimal places on Oracle
I have a TUniquery SQL is 'select 30.3706 as purchase_price, 30.3706 as retail_price from dual' and connect on the ORACLE 19c Enterprise， While I try to filter like 'purchase=30.76' or 'purchase_price>30.3706 and purchase_price<30.370600000000001', Both
Synchronize two sqlite databases .NET Core
Im not able to use dbConnect to synchronize two sqlite databases in .NET Core
MySQL: Determine AutoIncrement column by using GetSchema
Hi, I'd like to determine the existence of an auto-increment column in a table by using GetSchema. Could you please provide a small sample as I couldn't find any description of the various column attributes? Thanks in advance.
LinqConnect Migration Wizard in Visual Studio 2022 Community
We bought a copy of LinqConnect in 2020, but it didn't work for us as there were a bunch of things that worked in LinqToSQL and failed in LinqConnect. I was hoping after a few years we might have more luck with the latest version as we still want to migrate
TscKey.ImportFrom(Stream); Error "Key is Broken"
When I use TscKey.ImportFrom(FileName) everything works as expected, but if i copy the content of FileName into a constant it fails with "Key is broken" error. SecureBridge 10.2 Delphi XE7 procedure TForm7.Button1Click(Sender: TObject); const PUBLIC_KEY
[bug] auto-where by RefreshRecord
After update from 7.0.1 to 7.4.0 started misidentifying where-statement and by RefreshRecord joins WHERE once more, instead of an additions! PgQuery.KeyFields := 'r_id';
TUntQuery Is there an asynchronous loading parameter？
TADOQUERY.ExecuteOptions := [eoAsyncFetch]; // Asynchronous Read ，Do not block UI. TUniQuery，Do have similar parameters? Env：Windows+Delphi11.3
Syncing an Oracle 11g with Partitioning
Hello, i'm trying to sync an Oracle 11g with Partitioning. The Provisioning works for a while (a few minutes) then throws an Exception: Devart.Data.Oracle.OracleException (0x80004005): ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user
MySQL ODBC Driver SSH Connection with keys
I'm probably being pretty inept here, but I'm banging my head against the wall trying to get this to work. I'm able to setup an ODBC connection using the SSH tab (under the security tab) if I enter the server IP address, the username and the user password.
Delphi closes upon opening project SDAC problem.
Hi i have a problem when i open a project that uses SDAC on Delphi 11.3 it automatically closes the IDE without any error. It clearly happens the moment it try's to access the SQL server as the SQL wait icon is then on screen. After about 10 seconds the
"Lost connection to mysql server during query" when Fetchall:=False
A year ago I posted a similar question on the old forum. Now I think I can reproduce the error with a simple program. I add a master and a detail table. When I set Fetchall to TRUE everything works fine when I delete the master row. If I switch to Fetchall:=FALSE
TUniMetadata and database structure.
Hi! Now I can get tables, columns, columns types and indexes. tables procedure var FUniMetaData: TUniMetaData; begin FUniMetaData := TUniMetaData.Create(nil); try FUniMetaData.Connection := FConnection; FUniMetaData.MetaDataKind := 'Tables'; FUniMetaData.Open;
Next Page