EntityDac 3.2.0 and Firebird 2.0.7
EntityDac 3.2.0 Firebird 2.0.7 IBDAC 8.3.0 Expression: From(ti).Where(ti.TRANSID = AId).OrderBy(ti.ID).Select(); Result: SELECT t1.ID ID, t1.TRANSID TRANSID, t1.ITEMCODE ITEMCODE, t1.OPIS OPIS, t1.OPISDOD OPISDOD, t1.KWOTA KWOTA, t1.SZTUKI SZTUKI, t1.WAGA
MySQL Router SSL Handshake error dotconnect mysql
I am trying upgrade my development machine and need to reinstall dot connect on the new machine, however, I cannot get dotconnect to work with mysql router - even though it's setup the exact same on the current development environment. I always receive
TMyDump from v8 to 5.7 charset problem
Hi Is there a way to specify the charset and collation when perforing a backup and restore? We have a clean set of data that we use for install that is on a Mysql 8 server but ur clients are using 5.7 We get the following error. I could perform a replace
missing compatible file : libdevartodbcase.2.1.4.dylib
Hello, we installed odbc driver for sybase 2.1.4 on macos M1 bigsur 11.6 and the error below is generated when trying to connect excel to sybase DSN : Could you please help us with this urgent issue Thanks in advance for your attention Kind regards,
Property EncryptedPassword does not exist
Good afternoon, I have a problem with one of the legacy systems here at the company, it is unfortunately developed in Delphi 6. My problem is that I updated the Delphi ODAC that was in version 8.6 to version 11.4, but when updating, when trying to compile
Creating and Updating MySQL Database Schema on Remote Devices Without DBForge Installed
Hi everyone, I am facing an issue with creating and updating a MySQL database schema on customer tablets that do not have DBForge installed. I have already created the schema using DBForge for MySQL and can export it, but I'm not sure how to create the
How do I insert an image file into a TVirtualTable Blob field?
Hello, I know how to insert blobs into TUniQueries. But I could not find the way to do this in a TVirtualTable. It does not expose any AsProperty which can sugest I can use a LoadFromStream method. Thank you very much. Jayme Jeffman Filho
TDADataSet
After reading Unidac 9.4.0 Revision History, I have a question: which unit TDADataSet class is declared?
dotconnect for Quickbooks
I have doconnect for SQL Server. Can the dotconnect for Quickbooks co-exist? I got an error when I tried to install the Trial version.
Is there a way to remove decryption out of sqlite db
Hi, I use dotconnect universal with sqlite and the Encryption of SQLiteCrypt: UniConnection conn = new UniConnection("Provider=SQLite; Data Source=database.db; Encryption=SQLiteCrypt; SQLiteCrypt License Key=00000-000-0000000-00000; FailIfMissing = false;
Cannot connect to Amazon Redshift
We have been evaluating the dbForge studio as a solution for maintaining the databases and schemas in our DWH, which is Amazon Redshift. According to documentation, dbForge studio for Postgres should be able to connect to Redshift (as Redshift is postgres-based),
Unidac's TUniquery Can Not Filter Special Four decimal places on Oracle
I have a TUniquery SQL is 'select 30.3706 as purchase_price, 30.3706 as retail_price from dual' and connect on the ORACLE 19c Enterprise， While I try to filter like 'purchase=30.76' or 'purchase_price>30.3706 and purchase_price<30.370600000000001', Both
Synchronize two sqlite databases .NET Core
Im not able to use dbConnect to synchronize two sqlite databases in .NET Core
MySQL: Determine AutoIncrement column by using GetSchema
Hi, I'd like to determine the existence of an auto-increment column in a table by using GetSchema. Could you please provide a small sample as I couldn't find any description of the various column attributes? Thanks in advance.
LinqConnect Migration Wizard in Visual Studio 2022 Community
We bought a copy of LinqConnect in 2020, but it didn't work for us as there were a bunch of things that worked in LinqToSQL and failed in LinqConnect. I was hoping after a few years we might have more luck with the latest version as we still want to migrate
TscKey.ImportFrom(Stream); Error "Key is Broken"
When I use TscKey.ImportFrom(FileName) everything works as expected, but if i copy the content of FileName into a constant it fails with "Key is broken" error. SecureBridge 10.2 Delphi XE7 procedure TForm7.Button1Click(Sender: TObject); const PUBLIC_KEY
[bug] auto-where by RefreshRecord
After update from 7.0.1 to 7.4.0 started misidentifying where-statement and by RefreshRecord joins WHERE once more, instead of an additions! PgQuery.KeyFields := 'r_id';
TUntQuery Is there an asynchronous loading parameter？
TADOQUERY.ExecuteOptions := [eoAsyncFetch]; // Asynchronous Read ，Do not block UI. TUniQuery，Do have similar parameters? Env：Windows+Delphi11.3
Syncing an Oracle 11g with Partitioning
Hello, i'm trying to sync an Oracle 11g with Partitioning. The Provisioning works for a while (a few minutes) then throws an Exception: Devart.Data.Oracle.OracleException (0x80004005): ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user
MySQL ODBC Driver SSH Connection with keys
I'm probably being pretty inept here, but I'm banging my head against the wall trying to get this to work. I'm able to setup an ODBC connection using the SSH tab (under the security tab) if I enter the server IP address, the username and the user password.
Delphi closes upon opening project SDAC problem.
Hi i have a problem when i open a project that uses SDAC on Delphi 11.3 it automatically closes the IDE without any error. It clearly happens the moment it try's to access the SQL server as the SQL wait icon is then on screen. After about 10 seconds the
"Lost connection to mysql server during query" when Fetchall:=False
A year ago I posted a similar question on the old forum. Now I think I can reproduce the error with a simple program. I add a master and a detail table. When I set Fetchall to TRUE everything works fine when I delete the master row. If I switch to Fetchall:=FALSE
TUniMetadata and database structure.
Hi! Now I can get tables, columns, columns types and indexes. tables procedure var FUniMetaData: TUniMetaData; begin FUniMetaData := TUniMetaData.Create(nil); try FUniMetaData.Connection := FConnection; FUniMetaData.MetaDataKind := 'Tables'; FUniMetaData.Open;
Release notes on new Delphi Data Components
Hi, first all let me say the new forum is nearly unusable. It might look modern, but it's horrid. There are new updates for all the Delphi Database Components, however nowhere can the release notes be found. Can you supply them ? (They used to be available
UniDac 9.4.0 cannot connect to SQL Server
I have been using UniDac for years and I routinely connect to Firebird 3 and SQL Server databases (often at the same time). I just updated from UniDac 9.3.0. to 9.4.0. Now I cannot connect to the same SQL Server databases I have been connecting to for
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
Next Page