Recent Topics
dbForge does not seem to understand HeatWave specific commands
We are migrating from MySql on-premises to Oracle Cloud with Heatwave. When we perform a DB comparison, we get errors on tables that contain fields to be excluded from HeatWave with the NOT SECONDARY keyword assigned to the fields. Also, in stored procedures,
Using TUniQuery w/ MongoDB
Hi, Having taken a look at https://docs.devart.com/unidac/using-mongodb.htm#tuniconnection, I'm still struggling as the amount of information is somewhat limited (particularly the examples). I have the following code: procedure TForm1.Button1Click(Sender:
Support for Open Telemetry?
OPD.net supports Open Telemetry. Most other database providers now also support this. Does dotconnect also support open telemetry? If not, this would be a very important and good feature for the future. Regards Hansjörg
Can't create a new SSIS Connection Manager
The connection type "DevartSqlServer" specified for connection manager is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling
Error connecting from Schema Compare 1.4.839 to PostgreSQL 14 using Pritunl
I'm trying to connect to PostgreSQL 14 from Schema Compare 1.4.839 using Pritunl (VPN client). So I have many network adapters / IP addresses on my laptop. When I'm trying to connect to PostgreSQL server with Pritunl is on, I get an error: no pg_hba.conf
Devart.Data.Oracle v9.0.12.0 to v10.3.10.0: The same update doesn't always commit
Hello, I am creating this topic because we've been having issues ever since we deployed in Production a few weeks ago. One of the biggest change we brought was a change of versions of Devart from v9.0.12.0 to v10.3.10.0. However, I've rolled back to v9.0.12.0
Unknown error in OLEDBAccess
We use the latest version of SDAC The program written as a service With several threads in Windows. Sometimes this address is announced and closed accidentally while working Assertion failure (D:\ProjectsClone2\Delphi\Dac\SqlServer\Source\OLEDBAccess.pas,
EF Classic 6.5.x support of Microsoft.Data.SqlClient
We recently got a new 6.5.x release of Entity Framework (Classic) that adds support for using Microsoft.Data.SqlClient instead of System.Data.SqlClient as the DB provider. It would be great if we could get a simple support for that in EntityDeveloper,
Access Database "Direct" mode DDL statements not supported
Delphi 7 with UniDac 10.2.1. We are trying to create a view in an Access database using the TUniSQL component. We are using the new "Direct" mode (which is really wonderful, by the way, because it gets around the 32bit/64bit Access Database Driver problem).
Salesforce ODBC - How to work with *ChangeEvent tables?
Hi there! We've recently bought our Devart Salesforce ODBC license and set it up so we can query our Salesforce via Microsoft SQL LinkedServer. I've now seen that nearly every Object has an additional ObjectChangeEvent table and I was wondering how we
Is is possible add 'OFFSET' or any other word to reserverd keywords in dbForje Studion for MySQL 9.0?
Is is possible add 'OFFSET' or any other word to reserverd keywords in dbForje Studion for MySQL 9.0? OFFSET now keyword in MariaDB and needs to be quoted https://jira.mariadb.org/browse/MDEV-25556
woocommerce - unauthorized
Hello, We've just installed the Woocommerce ODBC driver, configured it with domain name, customer key and customer secret, but we keep getting the following error message The remote server returned an error 401 : unauthorized The same credentials work
Unprepared Execute False by default > why statements are prepared by default
Why UnpreparedExecute is *False* by default. So you always prepare statements by default? If i understand the help correctly, this will call an additional "PREPARE". (https://www.postgresql.org/docs/current/sql-prepare.html) This is in most cases not
[bug] with real data type
hello, PgQuery.SQL.Text := 'SELECT 0::real'; PgQuery.Options.UnpreparedExecute := true; if not(PgConnection.Connected) then PgConnection.Connect; PgQuery.Open; It will crash at opening with an exception! and sometimes (in some queries using real data
AzureAD Interactive Authentication
Hi, I'm attempting to get AzureAD Interactive Authentication (auADInteractive) working with SDAC connecting to a SQL Azure database. At the moment it always asks for my password and then a two factor auth challenge. This happens every time I start the
"CROSS APPLY" is not supported in Postgresql?
Hello If I use a LINQ query over 2 tables, I get an error 42601: syntax error at "APPLY" It seems that the SQL contains "CROSS APPLY" which is unknown in Postgresql. How can I avoid that ? Never had that problem with the previous versions (.NET Framework)
Visual Studio 2022 error not loading Devart.Data.PostgreSql.Vs.dll (dotConnect for PostgreSQL 8.1 Express)
Hi, I cannot find this topic in FAQ. So I posted here. It will always appear when I start Visual Studio even when with empty project. Please advice if this error can be ignored. Regards Samuel Toh
Not for profit volunteer developer
I'm doing some volunteer database work and the NFP wants to connect the DevArt plugin from their shopify account to their Microsoft Access database. I have full rights to a sandbox store, but I'm getting an error message -7711 from Access when I try to
dbForge SQL Monitor documentation
Hi, in the support page I can Read <<For a complete description of the tab, refer to the Top Queries, Monitor Window topic>> So where are these complete descriptions of functionality? Thanks a lot
Is there a code sample on how to use multiple DbContext
Hi devart team I am developing an ASP.Net Core application using .Net 8.0 and DevArt.Data.Oracle 10.3.10 and DevArt.Data.Oracle.EFCore 10.3.10.8. I have two projects each has a DbContext. In the program.cs for both DbContext services.AddDbContext<DatabaseContext>(options
Unidac in a Windows Service?
I have spent a lot of time trying to get a couple of applications using Unidac to work as a service. I can get these applications to work ok in GUI mode, but they will not run as a service. I can install the service ok, but when I try to Start the service,
Entity developer (NHibernate) 7.1.151 generating wrong SQL at Update the Database from Model
Hello If you add an association between two entities with composite primary keys, entity developer (NHibernate) 7.1.151 will generate the wrong sql script at "Update the Database from Model". Example (Assoc is One Cat to Many Dogs, ISet) The generated
SFTP Client Timeout
Hello, We have an application which uses an scSFTPClient component to transfer files to our bank. This program has been in use for years and never had a problem. Today, we had two files fail due to a reported timeout. Our timeout value is set to 30. After
Devart.Data.Oracle.EF6: Can it have .Net Framework support in Nuget?
Hello, I am currently updating our dotConnect for Oracle (DevArt.Data.Oracle) package to 10.3.10 in our .NET Framework 4.6.2 solution. I would also like to update Devart.Data.Oracle.EF6 to 10.3.10 but the dependencies in nuget requires .NET Standard 2.1:
OracleSQLCompatibility with EF Core 8
Hi, I am working on an application that uses the Devart.Data.Oracle.EFCore nuget package to read data from an Oracle data base. I want to update the application to EFCore 8 but I have a problem with Contains in LINQ queries when I use a older Oracle database.
Where is the TCRSSHIOHandler component?
Hello, I would like to use SecureBridge to recreate your example Connecting to MySQL Through SSH in Delphi in Delphi. Unfortunately, I do not have a TCRSSHIOHandler component. I am working with D12.1, dbForge Studio for MySQL Professional, SecureBridge
Unidac do not connect to NEON database site.
In Delphi I can connect using FIREDAC components and its works fine. But I need use UNIDAC (TUNICONNECTION). And when I try to connect with NEON DATABASE, using the exact same connections informations, this error shows up (SSL_do_handshake = -1) I had
How to properly sync sequence values from production to development?
I synchronize the Oracle Database 12c R2 from production to development weekly. However, I am encountering a problem where the current sequence values from production cannot be synchronized to the development instance. Is there an option in the wizard
Can't start win64 version
When I start the win64 version, the following error message is shown and the Entity Developer does not open.
SQLite data access issue
I have successfully installed the Devart SQLite ODBC driver and I can connect to the SQLite database using MS Access. I can update data and delete rows but I am having 2 issues I hope you can help me with. · I am unable to add new rows to any SQLite table
Unidac Postgres - Postgres 14 and older UniDAC postgres
I had to rebuild my old dev environment and installed newer Postgres version, previously had 9.x and went to 14. I have resolved the error, but want to share my solution here. this link let When developing with older unidac 8.4 I ran into issue where
SQLite upper() function Unicode
Hello, SQLite doesn't support unicode SQL upper() function. My question: is there a way in UniDAC to enable it? Example: current: select upper('aou-äöü') -> 'AOU-äöü' expected: select upper('aou-äöü') -> 'AOU-ÄÖÜ' Some suggestion? Br, /Werner
TUniConnection feature request
Hello Please add TUniConnection.CommandTimeout specific option for SQL Server because ConnectionTimeout and CommandTimeout are not the same things. See MSClassesUni.pas, line 1246 It's need for Connection.ExecProc and Connection.ExecProcEx
Visual Studio Error
I get the following error in VS 2022 any help would be appreciated:
Evaluating SQL Source Control - Linked server on Get Latest
Hello! I am trying to run a get latest command in the Source Control module - there's 1 stored procedure it's trying to update my local DB with that has a linked server. The linked server does not allow distributed transactions and I saw that the tool
PostgreSQL: "Unexpected server response : ¹."
The question is how can I avoid this exception? UniDAC 10.1.0 with PosgreSQL server. I try to return a blob field of PosgreSQL type bytea using this code with TUniQuery.Create(nil) do try Connection := ucDL; SQL.Add('SELECT ' + FieldN + ' FROM ' + sNumeTabelComenzi
Strange Refresh Failed error message
Hello, I have a TOraQuery component, with a relatively simple select. It joins tables for the master table called ATB. select atb.rowid, atb.*, sby.c_nev1 c_belep_szintnev, bko.c_nev c_szervezetnev, saj.c_nev1 c_uzemkodnev, bkp.c_nev c_onelszamolonev,
Access violation Unidac in 64bit
I can't connect by using the TUniconnection compornent. My connection makes connection editor. 32 bit is ok, but 64bit is fail. My Environment is Win 11 & Delphi 12.1 & Unidac 10.2.1
Connection Pool is used like this ?
---------------------------------------------------------------------------------------- program api; {$MODE DELPHI}{$H+} uses cthreads, db.dataset; begin db.dataset.PoolConexao; end. ----------------------------------------------------------------------------------------
Regression in UniDAC 10.2+ with PostgreSQL
Hello, When running our database test suite I noticed multiple EOutOfRangeArgument exceptions being thrown by UniDAC (10.2 and 10.2.1) with PostgreSQL (v13.14). When executing the same SQL requests (simple UPDATE statement) directly against the database
Next Page