ODBC Driver ZOHO SSL
Today, im convert my Python Code for Connect into Zoho from (Windows Server 2012) to (Windows Server 2008) but there're error (On WS 2008) Error: ('HY000', '[HY000] [Devart][ODBC][Zoho CRM]The underlying connection was closed: Could not establish trust
Raspberry
Hi, I do not understand if it's possible use SQLite with Lazarus, but on ARM platform, like the RaspberryPi. In the source folders I see some Lazarus files and fpclinux64.o but not clear to me if compatible with ARM... Thank you
Can I use Odac with Delphi Community Edition to Access Oracle 19c Enterprise Edition?
is Delphi Enterprise edition is Must for Oracle 19c Enterprise Edition access? erkan
ODBC Driver for Salesforce
My organization purchased the ODBC Driver for Salesforce and we are happily retrieving data from Salesforce BUT we don't seem to be able to write data back to Salesforce. The log for both Salesforce and our application that is connected via Devart ODBC
Oracle error OCI-21500 and hard crash
I'm raising this again here in the new forum as we are still receiving this error after upgrading to the latest oracle 19.16 client. have an application using the latest version of dotconnect which is crashing randomly and being terminated by the .net
Writing to Salesforce Objects - will it trigger Account history in salesforce
Hello We are using ODBC driver to write to salesforce on Account object if needed. We also have account history enabled in salesforce but noticing none of changes triggered by back end odbc process is recorded in salesforce account tracking - is it
Devart Postres pgDataReader/PgDataAdapter Decimal value with Precision
Could someone please help me with the following question...
I migrated the Assembly Devart version to Postgres Express to version 8.0.0.0... after the changes the decimal value that is brought from the PgSqlDataAdapter is coming numerically with precision
VirtualTable/Query are empty after LOADED
Hello I just bought the VirtualDAV (v12.2) Components for my Delphi 11.2 Attached a small demo program, that shows my problem. I load/assigned the data in the LOADED Methode, after i entering on the FormCreate Methode the vtElementGrafik VirtualTable
UniDac 64-Bit MySQL
When linking a 64-Bit C++ project with MySQL UniDac support we get the following error, Unable to open file 'myprovider280.lib' To correct the problem, we have to copy, Devart\UniDAC\Lib\Win64\myprovider280.a to Devart\UniDAC\Lib\Win64\myprovider280.lib
Cann't get autoinc primary key value after UniQuery.Post when SQL include ORDER BY
Select * from table order by col1, Simple SQL like this are fine. Select table1.*, table2.xxxxx from table1 left join table2 left join table3 ORDER BY xxxxxx. When it is such a complex SQL statement, the self-incrementing primary key value is Null after
Change sqlite version
How to update sqlite version? For now sqlite 3.40 is newest but it's 3.36 in devart 6.0.x package.
9.3.0 - Virtual Table Errors
Hi, I detected errors in VirtualTable object. Sample application and information as follows: Delphi: Delphi 11 Unidac: 9.3.0 (nightbuild version) OS: Windows 11 There are 2 problems. One of them is that when we load data into the VirtualTable object at
Features supported
1. Does the driver use the postgres binary or string protocol? 2. What is the level of support for Arrays and PostGIS datatypes? 3. I understand that the driver connects directly, does it support connection using SSL? Thanks
query using "for json"
Hello, I use SDAC 10.0.2 with delphi 7, When I try follow query that return one row & one field (actually is TMemoField) and get field value as string I get part of actual data (2033 bytes). Can anyone knows what is wrong? select * from customer for
SOLVED - UNIDAC 9.1.1 - PostgreSQL 12 - 15 Digit Problem
I started seeing a bug I reported earlier in version 9.1.1 again. Can you help with this? Information: Delphi 11 PostgreSQL 12...15 Unidac 9.1.1 Before Report: https://forums.devart.com/viewtopic.php?f=28&t=54306 ScreenShot: Thanks.
Tmytable not drop
Hello, how do I make it so that a TMyTable that is active cannot be deleted with DROP TABLE ?
ODBC Connection SQLSERVER to HUBSPOT
Batch Update Oracle Nomal Mode and CLOB
Hi, I use batch update to update records in a query. My query have a CLOB field a the end like this //---- Sql : Update UQ.Sql.Text := 'UPDATE T_MESURES_STEP SET VALEUR = :VALEUR,CODE_REM = :CODE_REM,CODE_U = :CODE_U,METHODE
BDE to MyDac
I am considering converting a large application database to MySQL using MyDAC. I found this page via Google that says: "In MyDAC the interests of BDE application developers were taken into consideration. So starting to use MyDAC after working with BDE
Does the new forum keep track of what you have already read?
Does the new forum keep track of what you have already read? I am logged in.
Delphi Replace Components
I am trying to convert a large project To MySQL using MyDac. I am trying to use Delphi's Replace Components feature and I am getting 'Catastophic Failures.' I also tried it with GExperts add on tool and get the same result. I am wondering if anyone has
UniDAC components for FastReports (end-user designer) FMX 64-bit doesn't exists.
Delphi is a computer language that allows us to write applications for Windows, macOS X, iOS, or Android. https://www.embarcadero.com/products/delphi Universal Data Access Components from Devart (UniDAC) is a set of components that allows Delphi programmers
Are this forum working?
I Cant commit a new topic.
UNidac with Aurelias
Hi I am attempting to use the TMS Aurelius components to connect to Mysql 8 on Linux, using the Unidac components. When I use the Aurelius sqlite connection, everything works fine, however the moment I try and use unidac, it is impossible to start apache.
Oracle Direct and Windows 11
Hi, I have a problem with connection to Oracle in Direct Mode. It Work fine with Windows 10 but with Windows 11 I have this message : "(NET : Network error (cannot connect to server on host '192.168.0.4':0 requested address is not valid in this context
RecordCount and UniDirectional
Hi, I have some query with number of row > 25. With Oracle I use Oracle.FetchAll=True to get correct RecordCount but if I use also UniDirectional = True record is alway 25. PQ.SpecificOptions.Add('Oracle.FetchAll=True'); PQ.Sql := 'Some quetry with more
What is "Serializable Transaction"?
In "New in dbExpress Drivers: Support for RAD Studio 11 Alexandria Release 2 and Microsoft OLE DB Driver for SQL Server 19" https://blog.devart.com/new-in-dbexpres ... er-19.html "Also, we added support for the serializable transaction." What is "serializable
Using ILIKE
Hi there, How can I use "ILIKE" in a LINQ query in DotnetConnect for Postgres? If I try to use Devart.Data.PostgreSQL.Entity.PgSqlFunction.ILIKE, it throws an error "Method 'Boolean ILike(System.String, System.String)' is not supported for execution
Strange behaviour
Hello, I'm using ODBC driver from dynamics 365. I'm experiencing some strange behavior. For example, when I attach Dyn365 database as shared server on my SQL Server, in my queries the TOP 100 clause is ignored. So for example, the query: select top 100
Popular Articles
How to Download and Install a Previous Version of the Product
If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...
How to Connect to MySQL Server
In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...
How to Activate a Trial Version in dbForge Products
Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...
"Cannot obtain Oracle Client information from registry" Error
The error message "Cannot obtain Oracle Client information from registry" when working with Oracle typically indicates that either the Oracle Client is not installed on your system, or there is a mismatch in the bitness between your application and ...
How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools
If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...