DDL Search works on comments on views but not stored procedures
As the title states, I can search comments left in views but not in stored procedures. For example we lable all sprocs and views with "author: [INSERT NAME HERE]", yet a search for author only returns the views and not stored procedures.
Data comparison - Req "treat null" option to be split
In Data Comparison tool, the "treat null and empty string as the same" option needs to be split into 3 options. Option 1, for strings: Treat null and "<string defined by the user - default = EMPTY STRING>" as the same value Option 2, for numbers: Treat
Unable to attach the Transact-SQL debugger.
I just started getting this error about 5 days ago, I have no idea why? I used to be able to debug my T-SQL using the "play" button, now I can't?? I was following this thread here until you moved forums a few days ago. What I don't understand is that
Package load exception after upgrading to Visual Studio 17.4.1
I just upgraded to VS 17.4.1 and now I am getting a 'devart code compare' did not load correctly.
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;
support rad 12
need support for rad 12
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.
dbForge Studio for PostgreSQL
does dbForge Studio for PostgreSQL Data Editor allow you to update bytea columns?
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...
SecureBridge for Delphi 12
Hello, When is the plan to release Secure Bridge for Delphi 12? Regards, Bojan
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
SSIS package task error with HardDelete
I've created a Devart SalesForce Destination task with the HardDelete action. When I attempt to execute, it throws an error of: "...failed with error code 0x80131500 while processing "input"... ." The regular Delete action works just fine. Are there special
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
Replacing long server nams with an alias in tabs' captions
Some of my server names are very long. For example managed instances names end with 'database.windows.net' They make the tabs very wide and harder to read. Is there a way to instead of using $Server$ in the SSMS Caption setting to use an alias? So instead
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
**WARNING**: DO NOT INSTALL version 10.0.46 - usability is dead!
hi there, you might have seen the latest update with tons of changes and maybe, like me, you were super happy in the first place to realize, that the team did a great job fixing so many bugs and adding new features. but after using the new version for
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.
Entity Framework Core 8 (EF8) / .NET 8.x support
I am wondering when .Net 8 support will be released for Entity Developer? Do we have an ETA on that yet?
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
scFTPClient: Active-Connection ListDir -> ErroNo.: 530 ..Please login with USER and PASS
SBridge Version 10.3.1 Following scFTPClient-properties are defined: Hostname, Username, Password, UsePassive true/false (makes no difference) TLSMode = tmDisableTLS Connect Active = true when calling ListDir, the error occurs. What's wrong. I can't find
How to add DefaultValue attribute
Hi, I am using Entity Developer 7.2.10, in DB First on EF Core 7 and Data Annotations for Validation Framework. I want to add the standard attribute: [DefaultValue(false)] to a boolean field, but this is not available in the properties at all. I am aware
BiDirectionalSync
we are using two databases in which one is source database (central database) and the other is destination database (store database). And we are preforming bidirectional sync between central and store database, the problem occurred where the data existed
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
EF Core 8 / .Net 8 support
Hello, Do you have any roadmap or release date about supporting EF Core 8 ? Currently it's not possible to run a project with Devart.Data.Mysql (9.1.151.7) and EF Core 8.0. Thank you.
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
Next Page