DbForge studio for Oracle connection issue with proxy user
I have oracle DB that is installed on server and want to connect to it via proxy user but it's seems like the application can't connect to the DB even the same connection string is working fine on other application. Please note that I have no DBA privilege
Change order of ApplyUpdate
Hi Using CachedUpdate I need to have the delete statements to be fired before the inserts, is this possible? if not, i try to delete the deleted records before i can applyUpdates, but when i call apply after that i get error record to be deleted cant
dotConnect C# MySQL: Setting charset at global level?
I'm using the generated great TableAdapters in C#, where I had errors with my Hungarian strings (containing á, é letters) until I added any of these before opening the connection: this.Adapter.InsertCommand.Connection.Unicode = true; this.Adapter.InsertCommand.Connection.Charset
Access Direct Mode Connection Fails if Database has a Query (View)
We get EAssertionFailed with a message beginning "jTYPE_ATTRIBUTE" (JetTable.pas line 5126) when using an Access database in Direct mode, but only if there is a query defined in the database. We are using UniDAC 10.3.1 for Rad Studio 10.4. Recent release
TUniLoader
I'm using TUniLoader with SQL Server and it works fine. I would to know when the component finishes writing data on the database. Is it at the end of OnPutData event?
Handling of NaN > DevArt Connection Exception
Hi, PostgreSQL DataAcess Components if there is "NaN" in a Numeric column (that is allowed per default by postgres). Devart will fail. The following easy example shows the problem, DevArt is unable to open this dataset. If there is one row in 1000000
Upgrading SSIS Data flow for Salesforce Issue with License
Hello, We are using the SSIS data flow component 1.7.x for salesforce. It has been working for years. Now we have migrated servers (SQL2014=>SQL2019) and when deploying the SSIS Package and scheduling it to run using SQL Server agent we get "Cannot find
Unexpected SqlParameterExpression implementation when using Oracle spatial functions in EF Core 8
We are planning to upgrade EF Core 6 to EF Core 8 along with upgrade from .NET 6 to .NET 8. We frequently use Oracle spatial functions: "SDO_RELATE" and "SDO_WITHIN_DISTANCE", which unfortunately do not have built-in support in dotConnect for Oracle according
Salesforce ODBC - null-able columns marked as not null?
Your ODBC driver reports some columns as not null-able and then sends rows containing null values for them: Calendar.Name DuplicateRule.Language EntityDefinition.LastModifiedById FeedComment.HasEntityLinks FlowDefinitionView.LastModifiedDate Folder.Name
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)))
Error: "Invalid parameter "
Hello. I'm using the SQL-Server dbExpress, version 9.3 with Delphi Athens. On my development computer the connection with the database is workink perfectly. However, when I tryed to execute the application in a different computer I get this error message
Unidaq Provider for NexusDB Embedded in Delphi 12.3
I'm trying to use UniDaq in Delphi12.3 to connect to an embedded NexusDB. I followed the instructions and recompiled nexusprovider290.bpk, which created a new nexusprovider290.bpl file in the ${DELPHICOMMONDIR}\Bpl folder, which is included in the path
How to use dotConnect for Oracle Express Edition?
I am using dotConnect for Oracle Express edition, Can I reference to the library using NuGet or have to install manually?
dbExpress Driver for SQL Server support for TLS 1.3
Does dbExpress Driver for SQL Server supports TLS 1.3?
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)
ODAC - base class for BeforeOpen
Hi there. I'm trying to build an interposer class für TOraQuery. I couldn't find the correct base class, though. TOraQuery = class(Ora.TOraQuery) //TOraQuery = class(TMemDataSet) //TOraQuery = class(TCustomDADataSet) //TOraQuery = class(TOraDataset) //TOraQuery
Reset/Set Sequence in PostgresQL programmatically from c#
Is there a way to programmatically (c#) to update a sequence value in postgresql? I know from a sql perspective, you can do something like: SELECT setval('my_sequence', 10, TRUE); How do you do this with the devart.postgresql dotConnect for Postgres
#28000Access denied for user @localhost (using password: NO)
I have a large application where i : i have 14 datamodules. there's 1 main datamodule which contains the MyConnection component which is set at runtime and at design-time the connectionstring is empty every datamodule has a OnCreate event on all datamodules
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),
A collection of enum array values get translated as (NULL, NULL ...)
Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database
module 'devart.sqlserver' has no attribute 'license'
the problem: import devart.sqlserver print(devart.sqlserver.license.summary) result: Traceback (most recent call last): File "<stdin>", line 1, in <module> AttributeError: module 'devart.sqlserver' has no attribute 'license'
How to specify Time Zone format
Hello, It looks like there is now a way to specify time zone format in ODAC. How can I specify it in my code, if I want timestamps in query results (like a TSmartQuery attached to a grid) to always have a specific format. I want to use TZR, to solve the
Devart Salesforce Source Editor Query
Is there a way to select from account where createddate = GetDate. I am looking to only retrieve records from today. This query doesn't work in the Source Editor select * from account where CreatedDate >= CAST(GETDATE() AS DATE)
Findkey in Cloned DataSet work?
Hello, I would like to confirm a question. Does the FindKey method work on a cloned dataset? In my tests, it does not work. In the IBDAC documentation, a restriction is that the cloned dataset does not allow the use of filters. Is the fact that FindKey
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
MyDAC login problems
I am using MyDAC 12.4.0 with Delphi 10.2 Using MyConnection1 and Myconnection Dialog Anytime there is a login mistake, wrong password or user, the second attempt throws the flowing error: assertion failure "d:\jenkins\workspace\DAC\MyDAC\Delphi\Dac\Common\Source\CRVioTcpSSL.pas"
.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
dotConnect for MySQL parses sbyte incorrectly
Hello, I've recently bought dotConnect for MySQL and this is the first problem. All versions are current, .NET 8 with EF Core 9 and Devart's 9.4.191.9 My database has some columns that are tinyint in MySQL, which has the range -128...127. dotConnect's
dac290.bpl and pgdac290.bpl not compiled into exe
hello one and all, I'm getting back into Delphi, 12 right now, after last use with XE2. I started with 1 in 1995. anyway, I am evaluating PgDAV for direct connection into psql. when I copy and run the exe unto a native win11 machine and run it, the message
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
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
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
Update SQLite Direct ?
Hello, Any ideas why you don't update the SQLite direct to the latest version ? Thank you
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
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
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"
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
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
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
Next Page