Recent Topics
TMSTable.post problem: Operation Aborted. How to get more detailed information ?
Hello, Using an TMSTable with 82 fields, and 1 keyfield (integer), I'm able to Insert, Delete and Edit, but when I execute Post, the operation fails with exception: Operation Aborted and no further information. If I delete the record and then Insert,
Issue with Inserting Current Time Using Now Function in Timestamp Column in Delphi 12 and UniDac 10.0.0
I have a problem with compiling in Delphi 12 with UniDAC 10.0.0. Everything works in Delphi 11 with UniDac 9.4.0. Database is Postgres. When I want to insert the current time into a table item that is of the timestamp type using the Now function, an error
PYODBC sample code for Devart & QuickBooks Online
I am just starting to work with Devart (moving from QODBC). I am using PYODBC with Python and QBO. I am looking for some sample code for queries particularly journal entries. Surely someone else besides me is doing this, but I am not able to find any
BLOB With VirutalQuery Oracle
Hi, I need to use VitrualQuery to transfert Tables, table with clob et blob, but if I done the folowing code. With Postgres at the end Table2.Memo is filled by with Oracle is Empty. If I execute 'INSERT INTO TABLE2 SELECT * FROM TABLE1' in sqlplus it
Amazon Redshift ENCODE issue
Redshift tables DDL generation Note: ENCODE encoding The compression encoding for a column. ENCODE AUTO is the default for tables. Amazon Redshift automatically manages compression encoding for all columns in the table. If you specify compression encoding
Cant connect to my MySQL
I am absolutly doing something wrong, but i cant connect to my MySQL with "dbForge Query Builder for MySQL" or its impossible to connect to small server like 'USB Webserver'? Its get me error 1146
Running Report Created by dbForge Studio for SQL Server in different environments
I created report using dbForge Studio for SQL Server on development server. How can I run the same report on testing server. Both development and testing servers have the same exact structures, just different data.
dbExpress 6.1.0 possible regression
Hello, After updating our Delphi 11.3 application from the 6.0.3 of dbExpress to 6.1.0 for Firebird (v. 4.0.4) a problem occurred: Sample code: Query.SQL.Text := 'select * from TableX order by KeyField'; Query.Open; Query.First; // not needed; only for
Delphi 12 components
Hello, Delphi 12 has been out for 3 days and I see that it is not possible to download SDAC components for this new version. When can I expect components for version 12 ? I'm a bit surprised that there are no components on the same day that Delphi comes
F2063: could not compile used unit 'MyAccess'
I'm using the new MyDAC 12.0 professioal in Delphi 12.0. I get this error. The same for the unit 'DbAccess'. This version of MyDAC in Delphi 11.3 works fine. Is something wrong with the paths? Incompatible .dcu ?
Oracle.EFCore: saving to DB fails with error "NetTopologySuite spatial service is not registered"
Hi, I am currently trying to migrate my Blazor Entity Framework Identity app from Oracle Managed EF package to Devart EF package. Reading from DB seems to work fine, however, I can't update any rows in DB getting the following exception: 13:27:08.90 fail:
EF7: issue with case/when in version 10.1.151.7 (ORA-00920 : invalid relational operator)
Hi, In version 10.1.151.7 a wrong query is generated. We currently use version 10.1.134.7 which doesn't have this issue. The generated query looks as follows (in bold the incorrect part): ---- SELECT "l".A "A", "l".B "B", (CASE WHEN "l".C THEN 2 ELSE
Compiled query errors
Hello, After I 'v updated DB connector from version "10.1.134.7" to "10.1.151.7" , I started to get errors on compiled queries. I'm using EF7 on NET7. In the previous version, everything worked pretty well. Example of call: private static readonly Func<Model,
Need help using Transaction Log tool with a TDE encrypted MSSQL server.
I've purchased dbForge Transaction Log. Our production database uses TDE for encryption. I cannot open the logs for either the online or offline DBs. I believe this is normal behavior because the DB is TDE encrypted. I tried to get around this by creating
Handling of a bit array
Hello, recently we moved from 7.24.2066 to 8.1.151. Is there a difference now in handling a bit array? In the database there is a field of type "bit(7)". When filling a datatable (PgSqlDataAdapter.Fill), there is a different result in the corresponding
AccessViolationException in OCI mode, Devart 10, EF 6.4.4, Oracle 19
Hello Devart team. We are using Devart.Data.Oracle 10.0.0.0 for .NET Framework + EntityFramework 6.4.4. Our application is targeted to .NET Framework 4.8 and runs as 32 bit service process with "Local System" permissions. Devart.Data.Oracle runs in OCI
Connecting to QBO Sandbox
I am working with the trial and just setting things up. I can connect to the Live QBO environment but when I try to connect to the Dev environment (sandbox) I get the following error. I do have a sandbox account under the same userID as my prod account.
RAD Studio 12 support
Any idea how soon after launch that MySQLDAC (Delphi Components) will be updated to be used in RAD Studio 12 ? Or can it be installed in RAD 12 now?
UniDAC Update - Delphi 12
Delphi 12 has been released. When can we expect an update of the UniDAC components?
SDAC version 11.0.0 not yet available for Delphi 12
Hello, I have received the notification that SQL Server Data Access version 11.0.0 and VirtualDac 13.0.0. is available for download. When I go to my profile to download the version I noticed that the Delphi 12.0.0 version is available for download.
TUniQuery - how to assign JSON object to it?
Can someone please give me an example how to assign a JSON object (got from HTTP response query) to TUniQuery component? In Delphi (10). Thanks.
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 4. call ea.usp_procedure_name(parm_1,parm_2,'ref_result_data1'); fetch all FROM ref_result_data1;
Oracle 11 XE - Error ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
Hello, I have a problem with Oracle 11 Express Edition after upgrade ODAC from 10.1.3 to version 12.3.0 (Delphi 10.2). When I try to update a table with a CLOB field, I get ORA-24816 error (Expanded non LONG bind data supplied after actual LONG or LOB
Setting Servername with Port doesn't change port sind 10.2
With older version we only could set the servername in form of "server.local,1434" and the connection could be opened. When I use Version 10.2 the Port of the connection still stays on default 1433. Connection can than not be opened.
cannot insert unicode value in table (Mydac 9.1.3 for RAD Studio 10.2)
Hi, I have create a very simple database to test inserting unicode characters: CREATE TABLE `tencodingtest` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `value_as_utf8` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `value_as_utf16` varchar(30)
[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:
Source Control - missing user permission changes
When using the Source Control Manager in SQL Server Management Studio, it doesn't pick up changes made to database User security. I added an existing database user to the db_datareader roll in management studio and Source Control Manager shows no changes
How to know which SQL driver was selected by prAuto ?
Hello All, Is there any way to find out which sql driver the MSConnection have selected, when it is connected and the provider option is set to prAuto ? Some drivers are not suitable for datatypes like ftDate and ftTime, and I would like to know which
Exclude objects from schema/data compare from command line
This is a follow on question to https://forums.devart.com/viewtopic.php?f=33&t=39489 In that post it reads You can create a filters list that will be used in the command line using the key: CODE: SELECT ALL /schemacompare ... /Filter:"C:\Filter.scflt"In
Get All Schemas for a Database in Postgres
Hi, I use the code below to get all Database for Postgres : //---- Effacement Database.Clear; //---- Création de la base de données TC := TUniConnection.Create(Self); try //---- PostgreSQL if not (Port.IsNullT or Server.IsNullT or UserName.IsNullT or
Securebridge SFTP Client Access Violation
Hi, We have been getting Access Violations when using the SFTP client component in a MFT server. Sow what happens is the server has 4 queue threads and files get processed by the destinations they have, so when a file has a SFTP relay destination it creates
Tools For Versioning MySQL Stored Procedures
Greetings, currently with our particular business issues we need a way to versioning the stored procedures of our databases (Amazon MySQL RDS), we are making this process through GIT but still we have to update manually the modified procedures but this
Salesforce ODBC driver "unexpected NULL value" error if Name column NULL?
I am using driver version 3.3.0 17-Aug-23. When I try to select the Name column from the Calendar object and the Name column is NULL, the driver gives me the following error. SELECT * FROM OPENQUERY ([SF_CPQ_PROD],'SELECT Id, Name FROM Calendar'); An
10.3.1 question
Can you provide more details on the sshclient AV bug that was fixed? Reason I ask is I am seeing AV with the SSHclient with SFTP Client when I connect to the same host a lot in a short time frame. so there could be 10 plus SSH/SFTP client objects created
SQL Search
Hi, I have a question about SQL Search, I have not found this information anywhere. Do you know what permissions (in SQL) are needed to make it work) some one has a list like this? VIEW ANY COLUMN ENCRYPTION KEY DEFINITION VIEW ANY COLUMN MASTER KEY DEFINITION
How can I query the WorkstationID value assigned in a connection string using T-SQL?
I am assigning the ApplicationName and WorkstaionID properties on a SqlConnectionStringBuilder. I can query the ApplicationName from sys.dm_exec_sessions. I would like be able to query the WorkstationID value using T-SQL, also. My goal is to be able to
Azure Active Directory Integrated Authentication
Is it possible to connect to Azure SQL through Active Directory Integrated Authentication with dbExpress? I tried to add a Custom String=Authentication=ActiveDirectoryIntegrated;Use Encryption for Data=True; to a TCRSQLConnection, but it gave the error
Problem when adding new Linked Table (from DEAR to MS Access) using DEVART ODBC
I have two linked tables already in the database. These were added in an earlier version of MS Access. However, when I add another linked table it comes up with #Deleted# in every field and record. I use the same ODBC driver and have the same linked Table
Schema/Data Comparison: importing table mapping from other comparison file
I have spent about half an hour in schema comparison screen to map the tables of two databases that have significant differences (the one is an upgrade of the other, with several changes). Now that i have finished, i find myself in need to perform a data
How can I prove that a SSH connection made by SecureBridge + ODAC is actually SSH
Hello Devart, We have recently added Secure Bridge to our product which uses ODAC to connect to an Oracle database. A security-minded customer wants be be certain that the connection is actually SSH. How can this be demonstrated beyond just "you can connect,
Next Page