EntityDac save entity to mariadb - using FireDac
I use entitydac context. in Delphi12 and entityDac 3.3.0 var predpokladanaoperace := entitycontext1.CreateAttachedEntity<TTOrderWork> ; predpokladanaoperace.OrderId := 'zakazka000001'; predpokladanaoperace.TsLastchange := now(); predpokladanaoperace.TsCreated
Timestamp with TZ field date shifted +66 hours
Hello, Please connect as SYS with direct TCP/IP to an Oracle 19c database. Use an TOraQuery with the following SQL: select /*+first_rows*/ ORIGINATING_TIMESTAMP, HOST_ADDRESS, container_name, module_id, process_id, message_text from v$diag_alert_ext where
unidac + oracle direct mode + non blocking mode
Hi, another question around non blocking mode. the actual working seetings - unidac + oracle db - direct mode - disconnected mode for me the non blocking mode doesn't work very smoothly as it blocks sometimes the entire main thread which the exact reason
Salesforce ODBC driver - select from ContentDocumentLink slow buggy
Hello! I am running this simple query in SSMS via a linked server against the ContentDocumentLink table. It its not only EXTREMEMLY slow, bit it does not respect the LIMIT clause and keeps slowly pulling more records into the output window maybe 30 seconds
MSAccess Direct Mode
Hi, With version 10.1.0 you add support of : MS Access data provider Added support for Direct mode How can I use it and is it working with old access database (.mdb) Regards,
Select and update
Hello I have a stored procedure that returns data and updates a table. How should I execute it to retrieve all the rows it returns and ensure that the changes are saved in the database? Thank you
unidac, oracle, direct mode, disconnected mode, non blocking - cancel query
Hi, i am using unidac to connect to oracle in direct mode, disconnected mode, non blocking and i have sometimes SELECT queries which are last long. I want to cancel them. The query will be triggered from the main/ui thread. How to do this? Do you have
VirtualQuery DataMaping Unidac 10.0
Hi, I use the code below : try //---- Création TableP_MESURES := TUniQuery.Create(Self); try //---- Création WQ := TVirtualQuery.Create(Self); //---- Source de données TableP_MESURES.Connection := FicheModuleDonnees.Connection; WQ.SourceDataSets.Add(P_VLC,
How to add the activation key to SQL Server without Visual Studio
Hello. We have SSIS Dataflow Components for SalesForce installed on an SSIS SQL Server. However Visual Studio is not installed. How can we activate the product without Visual Studio? I found one other thread on this topic that advised copying a .lic file
MAX number of connections reached
hi. I have a C# .net WebForms app with several hundred users. it is running on windows server 2016. my connection string looks like this: value="direct=True;Min Pool Size=5;Max Pool Size=200;Validate Connection=true;Connection Timeout=5;Default Command
Add a field named index to the DBF table
There is a dbf table with a foam structure. It is necessary to add a field with the name index. Variants UniQuery->SQL->Text ="ALTER TABLE \""+System::Ioutils::TPath::GetFileNameWithoutExtension(OpenDialog->FileName)+"\" ADD COLUMN &fldname CHAR(10);";
ORA-01745: invalid host/bind variable name when using the same variable multiple times in EF7 query Where()
Hi, were are currenly using Devart.Data.Oracle.EFCore v10.1.134.7 in combination with EF7 on net6.0. Whenever we use a query that uses the same variable 2 times or more in a Where() method we get an ORA-01745 exception. Example: var today = DateTime.Today;
Salesforce ODBC - Update Record
Whats the best way to update a record in salesforce using the ODBC driver? I have this setup as a linked sever in SQL Server Management Studio, and would like to update a salesforce record from a local table.
Connection lost
Hello all, I moved the databe from Windows to Linux. And after this move my application is getting lost connection error. Is there an option in MyConnection component to handle such a problem? After loosing the connection all queries are getting problems...
dbexpsda doesn't works with fields with space
Hi, My dbexpsda.dll gives an error using table fields with space like [Num. Registro] in SQL Server . Anyone can help me?
Problems with Batch Updates
Even in the latest version of mydac I have problems with batch updates. (I told you already on the old forum) The problems started when you released a "faster" and "optimized" batch update ;) Now I can reproduce the error in my app. I have a main app
IBDAC and multithreading
From FAQ "Are the IBDAC connection components thread-safe? Yes, IBDAC is thread-safe but there is a restriction. The same TIBCConnection object cannot be used in several threads. So if you have a multithreaded application, you should have a TIBCConnection
UniDAC 10 Data does not get written to PostgreSQL DB
I'm using PostgreSQL 15.1, Delphi 11.2 I have a simple application (64Bit, if that matters) that uses a connection, the PosgresProvider, TuniTable and a Datasource connected to a dbgrid and dbedit and the With 9.4.0 everything worked. With 10.0.0 I can
quick question about Connection Lifetime
I have a asp.net webforms app with several hunderd users, and I would like to shorten the connection life time. currently it is set to 1800, which is 30 minutes. I am wondering if setting "Connection Lifetime=300" is too agresive. that is 5 minutes of
dispose datacontext
I am disposing dc like this: private void DisposeDB() { if (DB != null) { if (DB.Connection != null) { DB.Connection.Close(); DB.Connection.Dispose(); } DB.Dispose(); DB = null; } } I am 100% sure I am a always uysing the "using" C# keyword to instentiate
performance monitor
may I use windows performance monitor to watch dotconnect oracle connections? I am using direct mode to connect to database. I would like to add some counters for dotconnect conections. do I have to install dotconnect on the server in order to use the
Performance Counters Support
hi. I would like to use performance monitor tool to monitor IIS connections on the server. how may I create counters for dotConnect for oracle? do I need to install dotconnect on the server? thank you
Czech accent characters
Hi, I have an issue with dotConnect for Oracle and Czech accent characters. I do not understand why on one computer I need "Unicode=true" settings in the dotconnect connection string (without it the Czech accent characters do not work) but on another
BUG UniDAC v10 : @@rowcount is incorrect
Hi, - Delphi 11.3 - UniDAC v10.0.0 - MS SQL 2022 "select @@rowcount" is incorrect with update, insert and delete. no problem with UniDAC v9.3.0 Update of 44811 rows : Deleting a row that does not exist : Thank you in advance Regards
Issue on Fresh installation of ADO.NET Data Providers whit VS 2022 x64 and win 11
Hi on first trial installation of ADO.NET Data Providers I have this issue when try to add on VS 2022 windows form a devart Uniconnection : Is it because it uses x86 references? Tks for any info....
UniDac - Hide SQL oracle from Sqlmonitor Applications
I Need to Block access SQL Scripts from External Applications like SQL Monitor or Other. It can do using Direct Access function from UniDac, bud its is more bureaucratic. There are some form to do this accessing with HostName from TNSName?
Unhandled exception. System.ArgumentNullException: Value cannot be null. (Parameter 'expr')
Hi Devart team, I am facing an issue in my .NET 7 application connecting to an Oracle Database using Devart.Data.Oracle.EF library. When I try to query the parent table that is configured using table-per-type (TPT) I got the next error: Unhandled exception.
Feature Request
Hello, before we started using UniDAC we have used the Direct Oracle Access components (DOA) from AllroundAutomations. The dataset of DOA has a nice feature regarding CachedUpdates. Before it applies any changes to the database in ApplyUpdates, it reads
AlwaysOn configuration
Which options are required to make UniDAC work properly with AlwaysOn SQL Server? If I'm correct options related to AON are: -Provider (should be set prNativeClient) -FailoverPartner, -MultiSubnetFailover We are running UniDAC (version 9.1.1) and our
Multiple DbContext in one transaction in NET6 Devart.Data.Oracle.EFCore 10.2.0.7
Hi, When trying to use multiple dbContexts in one transaction I get the following error when setting the transaction: dbContext.Database.UseTransaction(transaction) System.InvalidOperationException: 'The specified transaction is not associated with the
Support .NET 8
Hi With the release of the LTS .NET 8 version, is there a plan for support for .NET 8 dotConnect Universal? https://learn.microsoft.com/en-us/dotnet/core/whats-new/dotnet-8
dotConnect Oracle Entity Framework 8 and Oracle Database 11/12
There is already a question about the release of dotConnect Universal. This question is about dotConnect Oracle. Do you already have a release date planned? As Oracle dropped support for Database 11/12 in their EF 8 driver. Will your EF 8 driver keep
License issue
Hey, I'm having an LinqConnect professional license with expiration date 13th october 2022. Today I tried with the included version 5 using LinqConnect with PostgreSQL and it raised an LicenseException. So the question is, what happend ? As I can see
ODAC Direct Mode Bug: Selecting RAW columns through DB Link causes Access Violation
Hello, Using ODAC version 12.3.0 and Delphi 11.3 Using ODAC with DIRECT=TRUE TSmartQuery has Options.RawAsString=TRUE I have a table like this: CREATE TABLE HAS_RAW (RAW_COL RAW(30)); Insert into HAS_RAW (RAW_COL) Values ('43'); Insert into HAS_RAW (RAW_COL)
How to use TMyConnectionOptions with TMyConnection to set protocol to IPv4 (or IPv6)?
I'm using MySQL Data Access Components, standard edition, version 10.3.2 for Rad Studio 2009 (I'm also using the SSH components to get an encrypted connection) The docs here https://docs.devart.com/mydac/devart.mydac.tmyconnectionoptions.ipversion.htm
IP protocol used by MyDac TMyconnection changes from IPv4 to IPv6 (or vice versa) and database queries fail
Scenario My application obtains the public IP address of the user by running a small PHP script on the same server that hosts my database. I then programatically insert that IP address into the remote hosts table so that I can gain remote access to the
Firebird 5 released
Firebird 5 was released 2024-01-12. Now, when do we get an IBDAC update? ODS is compatible to FB4, but there are new SQLs, like partial indexes and "SKIP LOCKED". There are new backup options for parallel workers, which may be configured in TIBCBack
InvalidCastException with value types and logging applied to the DbContext
Hi, We are using Microsoft.EntityFrameworkCore 7.0.15 and Devart.Data.Oracle.EFCore 10.2.0.7. Some of our queries use value types in the where clause but don't work when we enable logging for the DbContext. I have a attached a small project which reproduces
C++ Builder 2010 Unable to connect to database
Hello, We are using C++ Builder 2010, Firebird 2.5.9 we are having some problems with mult-thread access with our current Firebird Driver (other driver) We are interested in testing you driver but we receive a strange exception after the trial info dialog
Remotely connect to xBase ODBC driver from an external service
Hi, I'm wanting to connect an ETL (Azure Data Factory) to a FoxPro database on an on-premise server. I see that some of your ODBC drivers provide connection options like port etc, but the xBase one doesn't. Does that mean that there's no way to connect
Next Page