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
Compiler Issues with LiteDAC Component
In my C++ Builder XE 11.2 project, I placed a LiteConnection component and attempted to compile an APK for Android 32-bit. During the compilation process, an error occurred: [bccaarm Fatal Error] DBAccess.hpp(17): 'Winapi.Windows.hpp' file not found.
Error No Entity Framework Provider found for Devart.Data.SQLite
Hi! I maintain a .NET Framework 4.8 app that uses DevArt DotConnect for SQLite. It uses Entity Framework to talk to a database where application logs are stored. Anyway, starting about a year ago something changed in the app's config that's causing an
Devart.Data.Oracle.OracleException : ORA-00920: invalid relational operator
Hi Devart team, I am getting the error Devart.Data.Oracle.OracleException : ORA-00920: invalid relational operator when querying the database using a bool property in a where clause like: var students = _dbContext.Students.Where(s => s.IsActive).ToList();
ODAC TOraQuery cannot popup window to enter SQL query
My environment is: Delphi 10.2 and C++Builder 10.2 Update 3 Devart Oracle Data Access Components 11.1.3 While I add a TOraquery to a form, and then in Object Inspector I click on SQL trying to bring up the editor window. Delphi dies. What I can do is
Built-in dbExpress Driver problem
I use dbExpress Driver for InterBase and Firebird 6.1 Source code. and Delphi XE use DbxIdaDriverLoader and compile An error occurred [DCC Error] IBCError.pas(29): E2003 Undeclared identifier: 'ECRError' in unit IBCError; How to resolve it? thanks!
dotConnect MySQL Info
2 questions with the dotConnect for MySqL 1) does dotConnect for sql work with the square brackets in mySQL? The devArt MySQL Odbc driver handles the square brackets but it looks like the [] are throwing an error? Example select * from [Company] 2) using
dbExpress very slow on one computer
Hi All, Normally I have no problem with the speed of the dbExpress drivers. But I have one customer where the connection to the database (MSSQL) is very slow (more than 10 times slower than others). He has the same setup as others, so I cannot pin point
Migratig from FibPlus
Hi I have a FibDataSet with CachedUpdate activated. and this code: Trans := Consulta.Transaction; Trans.Active := true; Consulta.Open; Trans.Active := false; when I close the transaction, the DataSet state is dsBrowse and all the data are still in DataSet.
Multiple dataset problem
Hi, I use TMSStoredProc and SP has multiple datasets. Besides, SP has some business logic and use Cursor to handle the logic. I tested to insert the records into physical table instead of #temptable in SP. I found it doesn’t insert any records into physical
How to move to a new computer?
I need to move the QuickBooks ODBC driver to a new computer. What is the process to do that?
WooCommerce connection to the ODBC driver
I want to control the data on my WooCommerce site using Microsoft Access. I installed the OCDB driver and I don't understand how to proceed further. I guess I know how to connect Access to the driver, but I don't understand how to connect the driver to
Query taking much longer in Direct Mode than when using an Oracle client
Hello, Our product gives the user a choice of using either Direct Mode or using an Oracle client. A customer has reported that when using Direct Mode, a particular query is taking 17 minutes, and when using an Oracle client, it takes only 18 seconds.
Memory not released after closing TSmartQuery with LOBs
Hello, Regarding this issue, created about 1.5 years ago on the old forum: https://forums.devart.com/viewtopic.php?f=5&t=44418 Your latest answer is: We have reported it to Oracle but have not gotten an answer from them. Can you ask again? Have
Linq Connect Update Timeline
Is there a timeline for an update to LinqConnect 5.-0.151 to support the recent updates to visual studio? Thanks -Pete
How to determine which version of dotConnect for Oracle is being used?
Hello, let me first give you my context as succinctly as possible. Our .Net Framework application uses dotConnect for Oracle NuGet package 9.X.X. When I joined the team and started developing for the app, I realized that certain queries took extremely
[bug] auto-where by RefreshRecord (v8.0.0)
auto-where by refreshrecord works incorrectly with: cross join SELECT bdea.dbrid ba_op FROM bdea CROSS JOIN ab2 WHERE ba_ix = :ab_ix :ab_ix(WideString[3])='100' WHERE ( ba_ix = :ab_ix) AND cross.dbrid = :ba_op :ab_ix(WideString[3])='100' :ba_op(WideString[3])='136'
change SQLwait cursor when autorefresh
hi Some of the TMyQuery have Autorefresh enabled. When the autorefresh is executed the cursor changes automaticly to crSQLWait. Is it possible the changes this into the crDefault so the user does not sees the crSQLWait cursor. OR Is it better to use a
Wrong display/update of TIMESTAMP WITH TIMEZONE data in diect mode
For demo, PLS create a table CREATE TABLE TS_TEST ( ID NUMBER (9,0) NOT NULL, TS TIMESTAMP(6), TS_TZ TIMESTAMP(6) WITH TIME ZONE, TS_L_TZ TIMESTAMP(6) WITH LOCAL TIME ZONE ); ALTER TABLE TS_TEST ADD ( CONSTRAINT "_PK" PRIMARY KEY ( ID ) ); And insert
Next Page