Delphi SQL Database Access Components 10.3
Hi, We just updated to the new release, rolled out a new version to a client but the Tconnection will not connect on the SQL 2022 Express DB if i roll back to the version prior to this release it works fine, which we have had to do in this circumsta
Oracle Database Sync Is Very Slow Then Throw An Exception
Hallo, i'm using dotConnect for Oracle and dotConnect for SQLite to sync an huge Oracle database with an SQLite database using a windows service. By starting the windows service started the sync process. The Oracle 19c server and the windows service are
Problems with mapping types to ATTACHed SQLite databases (latest Devart.Data.SQLite.EFCore 6.0 on NET 7.0)
Hello. I've created a simple project (latest Devart.Data.SQLite.EFCore 6.0 on NET 7.0) with 3-level entities: public class UserRole { public Int64 Id { get; set; } public String Name { get; set; } public virtual IList<User> Users { get; set; } } public
Unidac Mysql Cache DNS
When the IP of a web address changes Unidac is looking for the previous IP. I am connecting Unidac with mysql via address mysql.kinghost.com When Kinghost changes the server's IP, Unidac continues to look for the previous IP address that is no longer
dbForge Report Writer
I an testing dbForge Studio Report Writer. I have built my first report reasonably well but I am having trouble with the formatting. I have a calculated field for the Total Taxes. I would like it to be in currency format and cannot find out how to do
TOP N query to Salesforce returning all records
Any ideas why the single table select query with TOP N would return ALL rows, while using a join (second query below) will limit to 100 returned rows? SELECT Top 100 c.Name, c.Email FROM [SALESFORCE]...Contact c SELECT Top 100 c.Name, c.Email, a.Name
ODBC driver conenction to excel power query. Access to REST API is restricted by iTheme Security settings
HI, any help with this please?
Firebird Get Identity field after a Post
I know you can use as Returning to get the Identity field when using an insert SQL. But I need to do it with a SELECT statement and an insert; eg uniquery.close; uniquery.options.RequiredFields := false; //because of Identity field uniquery.sql.clear;
dbForge Schema Compare for MariaDb 10.11.2
Hi, I've seen similar issue from a few weeks back but for DB Forge. You ended up sending a person link with a custom build. Do you have an option to do so for your Schema Compare customer? I recently updated my box and had to rebuild docker container
Timestamp With Time Zone Field not TSQLTimeStampOffsetField?
Hi, Is there any reason why the implementation of your TIBCTimeStampTZField is not based on the built in TSQLTimeStampOffsetField? There's no documentation on the TIBCTimeStampTZField either. With regards, Martijn
Force allias
Hello Sometimes tabla name not displayed and see 'Query' This is an example: SELECT * from ContractBalanceTX cbh where 1 = 1 And ContractBalanceProcessesId IN (select list FROM @contractbalanceprocess) AND ContractId IN (select list from @your_list) --(1053,
Salesforce ODBC SQL Server linked server not able to browse catalogs/tables in SSMS, but can query them
I'm not sure we have our linked server security setup correctly - our Salesforce user seems to be working correctly as we can query data from various tables, but our SQL Server linked server (using Salesforce ODBC driver) is not allowing us to browse
Does SSIS Data Flow supported in SQL 2022?
I get the following error in SQL 2022，any help would be appreciated:
Built-in Oracle spatial functions for EF Core
We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. Previously in LINQ queries we frequently used spatial functions which were nicely translated to SQL, such as Devart.Data.Oracle.Entity.OracleSpatialFunctions.SdoRelate(geometry1,
Ignore specific Tables, Views, Procedures, Etc.
I am doing a comparison/synchronization between a client's database and my local server. There are specific tables, views, procedures, etc. that are ONLY used on their servers, reference other servers/databases in their environment, etc, that I don't
Expand all SELECT *'s in large query
At my job I have inherited a large (13000+ line) query with numerous unions of the form: SELECT * FROM a UNION SELECT * FROM b. We are running into an issue where a and b can end up with different column orders causing this to fail. This is further complicated
InterBase Data Access Components 8.3.0 / Delphi XE8, Exe-File corrupted
- Download InterBase Data Access Components 8.3.0 for Delphi XE8 - File cannot be started - Error Message "The source file is corrupted"
SSHServer Demo
Hi, Is it possible to add a users home path to the demo? Thanks
Updated to Entity Developer 7, Code generation default value not working for String
Hi, We updated our version of Entity Developer from 5.8 to 7.0 and the code generation default value for String properties stopped working. It still works for ints. We are using EF6 Models with Sql Server, code first. Generates: However Generates: I tried
TUniQuery - Prepare and IsQuery on PostgreSQL
Hello. Does Prepare and IsQuery methods (of Query) work on PostgreSQL database? I'm using Unidac 9.3.0 on Delphi 11.1 Alexandria. Simple code like the one I've posted, works on Firebird, Oracle, MSSql server, but not working in PostgreSQL (PG version
Query/Table SavetoXML with large datasets
First, let me say this forum looks awful. Anyway, I am using uniTable.SavetoXML(name of file) and it is generally working fine - on small tables. With large tables I get an 'Out of memory' error. the system seems to be loading the whole table into memory
Memory leak in SecureBridge connection to a signelR hub
Hello, I have detected a memory leak in SecureBridge connecting to a SignalR hub. The memory leak is produced on each unexpected disconnection. The error can be traced in a simple way. 1. Connect a hub client to any server hub in IIS. 2. Setup the hub
SProcs using ODBC for QurickBooks
I'm trying to execute a sproc via a trigger to create a record in QuickBooks.... I'm getting "OLE DB provider "MSDASQL" for linked server "BT_QB" returned message "[Devart][ODBC]Optional feature not implemented". Doesn't the ODBC drivers for QuickBooks
How to ignore INITRANS with Oracle Schema Compare?
I'm comparing an 11.2 database to a 19.0 database. In the comparison view, this is the 11.2 db: and this is the 19.0 db: And this is the relevant part of the sync script: How can I eliminate INITRANS from the comparison?
In Version 6.0.3 is impossible to run transaction RO
Dears according to information provided by you I am starting read-only transactions by this command KPTrans = KPSessionName->BeginTransaction(5); It works perfectly till version 6.0.2, but the last version 6.0.3 doesnt work, and stay in RW transaction.
Is it possible to keep the parameters of a file downloaded through "ScSFTPClient1.DownloadFile"?
Is it possible to keep the parameters of a file downloaded through "ScSFTPClient1.DownloadFile"? Example: The A.zip file has a creation date of 2/5/2007 on the server. When downloading it, the downloaded file is having as current creation/modification
connectionstring, connnection properties and localdb
Hello, have con.ConnectString:='Provider=SQLNCLI11.1;Integrated Security=SSPI;Initial Catalog=somedatabase;Data Source=(localdb)\mssqllocaldb'; this works correctly. When i want to set this values as properties of object con (TMSConnection), i did not
Delphi 11.2, AnyDac 9.3.0, ReportBuilder 22.0
Hi. Trying to compiler rbUniDAC.dpk using Delphi 11.2 / AnyDac 9.3.0 / ReportBuilder 22.0 got the error message below: [dcc32 Fatal Error] daUniDAC.pas(21): E2411 Unit ppPDFDigitalSignatureDlg in package rbRCL2228 refers to unit Vcl.CustomizeDlg which
DBGrid Postgres
Hi, I've a problem to show some string in DBGrid Column number 3 si not show I have (MEMO) instead. My query : RequeteRapportAEnvoyer.Sql.Text := 'SELECT A.IN_TYPE,A.S_ID,A.IN_ID,A.IN_DATE,CAST(TRIM(CONCAT(CONCAT(B.T_PRENOM,'' ''),B.T_NOM)) AS VARCHAR(100))
firebird 4
from what version can i connect firebird 4 i have the version 4.2.3 wil wok
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
Next Page