Recent Topics
Firebird 4
from what version can i connect to firebird 4
User defined functions in Entity Framework Core 7.0
Hello. I'm porting my code from "classic" Entity Framework 6.4 to Entity Framework Core 7.0. What is replacement for the following code (User defined functions setup)? Most classes doesn't exist in both Devart.Data.SQLite and Microsoft.EntityFrameworkCore
Assert error in UNIDAC
Hi Connecting to postgres through UNIDAC. Query is taken from DB monitor. Insert to same table with same fields works fine. query : update eeli_1.t1009_packages("t1009_id","fd","td","t1002_id","t0106_id","package_name","start_sn","stop_sn","bar_code","user_id","in_date","comments","unit_name","s_id","pd_id","del_user_id","del_in_date","min_unit_name","code","min_unit_count")
.Net 7 support
Do dotConnect for Oracle support .Net 7? If not when will you will support it? Thanks.
Devart.Data.MySql & .NET 7 support
Hello, .NET 7 is out and we would like to upgrade our projects. Unfortunately the Devart.Data.MySql.EFCore package seems to not be compatible with it. Do you plan to have a compatible version any time soon ? Regards
Entity Framework Core 7 (EF7) / .NET 7.0 support
Hello, are there any estimates when Entity Developer will start supporting Entity Framework Core 7 (EF7) and .NET 7.0? Thank you
SLOW START DELPHI APPLICATION
Hello, My Delphi Embarcadero application uses TUniQuery, to access 2 Interbase Tables, and TUniTable to access 2 DBF Tables. The application is getting slower and slower and slower when starts, more than 2 minutes. Every day is slower than the day before.
PostgreSQL 15.x support
Does anybody use the current version with the latest PostgreSQL 15.x versions? I'm still using 13.x and I have to migrate a server. So I just want to be sure, if there may be any issues UniDAC - PostgreSQL 15.x? When will there be a release with offical
Firebird ODBC driver can't open table using with BDE on Delphi11.2
When open database I tested Firebird ODBC driver using with BDE on Delphi11.2. I get error when openning TTable, "Dynamic SQL Error. Column unkown ID at line 1, column 8." I create database on Firebird 3.0.10, then create OBDC DataSoure using ODBC administrator
Relation Many-To-Many from Diagram Devart version 7
Hi all, I am working with the latest version of devart 7, with .net core 6 MVC, Visual Studio 2022 and with Sql server 2019. I need to relate two Many-to-Many tables and in the middle table I need to add more fields besides the two Ids of the related
BigQuery ODBC driver | Data truncation
Hello, My company has recently purchased and installed the ODBC Driver for Google BigQuery. We are pushing data from BigQuery into a SQL Server database. It is working well for small datasets, however when we try to query for large datasets (e.g. 2 million
The new forum is awful and totally unreadable.
Hello, The new forum is totally unreadable. - posts are mixed between components, - number of post about UniDac since the new forum started seems to no showing all posts (only few posts) , - the topics are not organized i table (ie no columns for viewers,
Deployment issue, System.TypeLoadException
We recently updated our web application from dotConnect for MySQL 8.17 to 9.0.0 (with EF5). Everything works fine on dev machines but not when deployed to the web server (Windows Server 2012): System.Data.EntityCommandCompilationException: An error occurred
On Save of a view the editor / formatter adds backticks (grave accents) around names - How do I stop this?
Hi guys, When saving a view, the auto formatted adds backticks (`) around object names eg. `ea`.`ParentEntityId` AS `ParentEntityId` I want to turn this off (unless necessary, like a name with a space) so the line reads like; ea.ParentEntityId AS ParentEntityId
SQL Query Hangs when adding anything beyond Select *
Using the Excel Add-in to pull and refresh BigCommerce sales data for orders with status = 'shipped' when selecting columns for a preview, the query executes fine. However, when adding any filters/order by logic, the query is stuck on 'executing query'.
dotConnect for postgresql 8.0 not compatible with NetTopologySuite?
I used dotConnect version 7.17 with NetTopologySuite 1.14 + GeoAPI 1.7.4. I update dotConnect to version 8.0. Now I can't run my application: When I compile I have the warning warning MSB3277: détection de conflits non résolus entre différentes versions
Inconsistent metadata - Connecting to Firebird from SQL Server Management Studio using ODBC Driver for Firebird
We have a Firebird 3.0.8 database we want to add as a linked server to SQL Server Management Studio. We downloaded the 'ODBC Driver for Firebird 3.3' and created a ODBC Data-Source: The database used in this test is a clean firebird 3.0.8 database with
MySQL 8.0+ : Compare and Generate Schema without Integer Display Width
As noted Old DevArtForum topic "Integer width deprecated" > In mySQL 8, there is a Warning, when creating a field with integer incl. precision. > "Warning: #1681 Integer display width is deprecated and will be removed in a future release." Can DevArt
Output the Search (Find a database object) to a file, table, excel, clipboard
After doing a "Search" (Find Database Object) thru my database, I'm unable to copy the results. Is this just not possible? Or, do I need to request a feature/enhancement?
Is it possible to convert back from EDML to EDMX?
Is it possible to convert back from EDML to EDMX? If so, what are the steps? I'm in a situation where I have to change one of our applications back to just using ODP .NET Data Provider and Entity Framework 6 default in Visual Studio.
How i can know if specific File Exists on server?
Hello again, How i can know if specific File Exists on server with ScSFTPClient? I need to check if a specific file exists or not on the server. How can I do it?
Question/Problem dbForge keeps asking for an old connection when opening .sql file
In the past I have used another connection to work with dbForge. The connection has changed, I removed the old one from the database explorer and even when I'm using the new one, when opening a .sql file it keeps asking for the old one and I have to manually
SSH Connection with Public key not working
Hello, I am using dbForge Studio 2022 for MySQL Enterprise Edition 9.1.21 and trying to connect to a MariaDB server on a remote Arch Linux server via SSH. On that server, SSH is configured to accept public key authentication. When using the standard Windows
Setup Linked Server in MSSQL Server with ODBC MySQL driver
Hi, currently I'm trying to setup a linked server connection in Microsoft SQL Server 2019 to access a MySQL Database via the ODBC driver. I've followed Connecting SQL Server Management Studio to MySQL via ODBC (devart.com) & Windows DSN Configuration
sFTP with Progressbar
Hello, I need a example of "ScSFTPClient1.DownloadFile" and "ScSFTPClient1.UploadFile" with a Progressbar do view the progress of file transfer. I Appreciate your attention.
Error in demo for SFTP
Hello, I'm trying to understand how the SFTP component is working, but í get some errors when running the demo. Please advice.
dbForge Enterprise via MySQL
Hi, I am on the process of migration using the copy database. Picture for reference. I am stuck with those red line that have percentage and not showing errors to troubleshoot. Btw, I am using a free trial and plan to buy license but i am testing it
How to ensure TScSSHClient and TMyConnection both open and / or close at the same time
I like the way opening a TMyQuery automatically opens the TMyConnection that it is connected to. Does TScSSHClient do the same thing? ie if I have TMyConnection. IOhandler -> TScFileStorage.Client -> TScSSHClient will calling TMyConnection.Connect automatically
How does the securebridge demo know which key is the one downloaded from the server?
I have eventually managed to get the securebridge demo (Documents\Devart\MyDAC for RAD Studio\Demos\TechnologySpecific\SecureBridge\Demo) working after deleting references to IdeVer.inc. I am now trying to understand how it does the things the sample
Error while accessing foxpro tables from sql server as linked server
Provider OLE DB "MSDASQL" for linked server "XXXX" returnes the message "[Devart][ODBC][xBase]Cannot open file "c:\temp\table.dbf". Unable to access file. The file is being used by another process". Message 7350, level 16, status 2, procedure test, row
Weird Issue, happening once in a while...
hello, once a month or so, one user (out of 100) faces issues to login into one schema (out of 50 in the average) of one database (out of 100). Happens suddenly without any change to this user, schema or database. This 'lock' disappears after a few hours,
How to make a Order and Order Items report
I have two tables: Orders: OrderID Name Address etc. Order Items: Item ID Item Name Qty etc. How do I make a report that shows the Order and then all the Items on the Order? In the Detail Band, I can only see one record, not all the records in the Order.
Read-only mode for Salesforce driver
Hi I noticed this old post from around 4 years ago - Is there a plan to support the above? Thanks.
executeScalar() isn't recognized using sqliteCommand
I'm trying the dotconnect for sqlite trial. I've defined a sqliteCommand &I'm trying sqliteCommand.executeSalar() but executeSalar() isn't coming up when I type .e after the command instance.
Full-text index support in dbForge Studio 2022 for SQL Server
Are there any plans to add support for full-text indexes in dbForge Studio 2022 for SQL Server as found in SSMS?
ODBC SalesForce Error state: 'HY000'. Native Error Code: 0. [Devart][ODBC][Salesforce]Access violation at address 1875A1E3 in module module 'DevartODBCSalesforce.dll'. Write of address FEC50020
Hello, the last month we opened a ticket as we had this kind of error. They told us to update to 3.1, but we still have the same problem. Randomly, our SSIS process will stop, showing us that error. Our only solution so far is to be always aware of the
DBF Provider Deleted Flag
Hi, 1. How can this be set to show/hide deleted records? 2. How can deleted records be identified in a table? Thanks
Help adding QuickBook invoice using DotConnect
I receive the following error: System.NullReferenceException HResult=0x80004003 Message=Object reference not set to an instance of an object. Source=BaptistTrumpetInvoicingV2 StackTrace: at EOL.BaptistTumpetInvoicing.GenerateSubscriptionInvoices.AddQBInvoice(Customer
Why is documentation so poor?
Why is the documentation so bad? For example, on the page https://docs.devart.com/sbridge/, under Securebridge Alphabetical Object and Component List (at least I think that's what it is as the left hand side panel is too narrow to display long topic names)
How to pass a Parm to the Query
I have a sales sheet. The Devart Qry brings in a table SMB_Budget. I want to filter that table on a salesman (smb_salesman). Is this possible, and if so, what is the approach I should use? The salesman number will be in a Cell in the excel spreadsheet
Next Page