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
Issue when comparing temporal table dbForge Schema Compare
Hello, I encounter an issue while comparing GIT branch VS SQL Server database especially with temporal table alter on dbForge Schema Compare while "Synchronize" action. I unchecked both "Ignore history table" and "Ignore history table name" options and
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();
SQL Complete Snippets - How to insert the text on your clipboard?
In other tools I've used similar to SQL Complete there's always been a placeholder that would insert what you have copied into the snippet. For instance if I copied the text "Table1" and used this snippet SELECT TOP 100 * FROM #Clipboard# I would get
debug is not working
after purchasing license debug is not working in sql 19
ScSignalRHubConnection
Hello, I wonder if the unit ScSignalRHubConnection supports the ASP.NET Core SignalR protocol for connecting to the server. Thank you and Best Regards Boris
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!
Why no active back button after a failed data import?
After an import fails for whatever reason in the Import Data option, the back button is always disabled. I can only click on the Finish button and it takes me out. This means I have to start all over again and repeat this workflow until there are no more
Importing fixed width flat file should default to the columns and their sizes in the destination table
I am trying to import a flat file with fixed width columns. I created beforehand a table to accept this data and defined the columns with sizes that match the field size to be imported, in the import wizard I had to manually define all the positions and
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?
SQL Complete - Can the code snippet auto-complete function be customized with a key other than 'Tab'?
Dear Devart, Hello. I am a user who is considering using sql complete this time. I asked you a question about using Code snippet in SQL Complete. As a result of checking the manual, it is confirmed that the snippet is automatically completed if you enter
Data Export - All Floats Become "General"
I'm using dbForget Studio for PostgreSQL Professional Edition v. 3.1.618. When I use the data export tool, all floating point numbers in all output formats simply become the word "General" - no numbers; just the word. Anyone see that before? I tried restarting
Minor visual issue in data comparison
Data comparison, Mapping tab. Pressing ... on a table which has a comparison key, opens the mapping window. In there, see the problem portrayed in the image attached to this post.
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
Is it possible to add a report to a data syncronization?
I am currently working on a project in which I am using the script of the following article to synchronize two databases: Compare Two Database Schema in SQL Server on a Schedule (devart.com) I was looking for more articles and I found this second article
Is it possible to connect to oceanbase?
I got a error message by test connection "Unknown table 'PLUGINS' in information_schema (code 1109)"
Source Control Conflicts - Grants added on end
Hello, When running source control some tables, procedures etc. are flagged as conflicting. Clicking get local/remote does nothing as they seem to come back on refresh. The conflict seems to be grant permissions being added on my local database (automatically)
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.
TScMailMessage adds In-Reply-To if Message-ID exists
Hi, As far as I know In-Reply-To header should be used in replies. Now If I add Message-ID to specialheaders it also copies it's value to In-Reply-To header In ScMailMessage.pas procedure GenerateHeader there is piece of code.. if FHeaders.Names['In-Reply-To']
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'
Exception "The CRL is not found"
Hello, we are using SecureBridge 10.0.1 for Delphi. A few days ago, on some Clients the function WebRequest.GetResponse.ReadAsString raises an exception "The CRL is not found". On other clients the function works fine. Da you have any idea, how to fix
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
Can't install LINQ Insight, error reports Visual Studio not installed
Hello, I have downloaded a trial version of LINQ Insight for evaluation from your website. When I launch the installation I get the following message, despite having Visual Studio 2022 installed. Is this product not compatible with this version of Visual
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
dbexpida.dll version 6.1.0 fro FirebirdSQL
Afert change dbexpida.dll 6.0.4.0 to 6.1.0.0 in some situation I get EListError in module dbexpida.dll at 0001ab0e List index out of bounds(4) This is raise in method function TCustomSQLDataSet.GetFieldData(FieldNo: Integer; Buffer: Pointer): Boolean;
When using TScHubConnection in dll, the main window closes and gets stuck.
I use TScHubConnection in the dll loaded by the exe to connect to the server. When the exe is closed, the window freezes directly and the process must be forced to end. I tried modifying the EventsCallMode, all modes have no effect. Help!
ODAC Pooling
Hi, Greetings! I'm trying to use ODAC connection pool feature, but im having a hard time figuring out how it works. Is there any demo or sample project that shows how it's done? Thanks in advance Rogerio
Next Page