Stack Overflow
Stack Overflow

Questions tagged [anydac]

www.anydac.com - Firebird, SQLite, Advantage, SQL Server, Oracle, PostgreSQL, MySQL, DB2, ODBC, dbExpress high-speed data access components for Delphi.

AnyDAC was developed by DA-SOFT Technologies and is an unique set of Universal Data Access Components for developing database applications on Delphi, C++Builder and FreePascal.

AnyDAC enables native high-speed direct access from Delphi to Firebird, SQLite, MySQL, SQL Server, Oracle, PostgreSQL, DB2, SQL Anywhere, Advantage DB, Interbase, Access, Informix and more.

In 2013 AnyDAC was sold to Embarcadero, renamed FireDAC and limited to only support Delphi platform.

References

40 questions
2
votes
1 answer

FireDAC SQL Server Connection: Untrusted certificate

I enabled secure connection by choosing a self-signed certificate on my SQL Server. I can connect to it using SQL Server Management Studio and adding TrustServerCertificate=True into Additional Connection Parameters. I need same configuration for…
Mehmet Fide
  • 1,643
  • 1
  • 20
  • 35
2
votes
2 answers

What is the most efficient way to read tile data (MBTiles) from SQLite table by using AnyDAC (FireDAC)?

Background: I'm working on a SQLite tile cache database (similar to MBTiles specification), consisting for now just from a single table Tiles with the following columns: X [INTEGER] - horizontal tile index (not map coordinate) Y [INTEGER] - vertical…
TLama
  • 75,147
  • 17
  • 214
  • 392
2
votes
1 answer

How to keep a program responsive while executing Anydac Query?

With sdac I can let the program responsive for user input as : while Query.Executing do begin Application.ProcessMessages; Sleep(1); end; How do I implement the same code with anydac query (there is no similar function)? I'm using delphi xe2…
ae1080
  • 374
  • 2
  • 7
  • 14
1
vote
1 answer

How can I update a blob field on the server

I have a client/server application built using DataAbstract and RemObjects where the client is transferring a Binary variable for the server to put in the DB. The server function looks like this function SetItemContent(const anItemId: UnicodeString;…
jonjbar
  • 3,896
  • 1
  • 25
  • 46
1
vote
1 answer

Informix Database is extremely slow when combining with Anydac

We are facing real performance issue with our application since we moved to AnyDac as an alternative to BDE. The application supports more than one database, so other ones like SQLSrvr and Oracle runs very well, but Informix got real real slow…
CloudyMarble
  • 36,908
  • 70
  • 97
  • 130
1
vote
2 answers

How to write txt-file in blob

There is Firebird table with 2 blob fields- blob_binary field(subtype=0) and blob_Text field(subtype=1,utf-8). DB has utf-encoding. Connection has utf encoding. Version of Delphi is 10.2.3. I use FireDac components for data access. Server is…
basti
  • 399
  • 2
  • 10
1
vote
0 answers

AnyDAC - TADConnection attribute FCommands contains released objects

At the moment we are migrating the database component of our Delphi7 application from the BDE components to AnyDAC Version 8.0.5 components (in the meantime known as FireDAC). We are using the following controls in our MDI child…
Mr.Darcy
  • 11
  • 2
1
vote
1 answer

Delphi XE4 E2010 Incompatible types: 'Cardinal' and 'Pointer'

Hello i was trying to compile the firedac dll development sample under delphi xe4 and it came up with the following error [dcc32 Error] Unit1.pas(61): E2010 Incompatible types: 'Cardinal' and 'Pointer' I have marked where the error is in the…
CrpticMAn
  • 13
  • 5
1
vote
2 answers

Improve multiple synchronized access to data

At the beginning I would like to apologize for the excessive use of bold text. I wanted to simplify the understanding of the way my long questions. I have a problem with multiple access to the data. I have to implement following problem: I have a…
Artik
  • 803
  • 14
  • 36
1
vote
2 answers

How to get last inserted id on ms sql server with FireDac component?

with FireDac, How to get last inserted id on ms sql server? thanks
ae1080
  • 374
  • 2
  • 7
  • 14
1
vote
1 answer

Are Indy 10 TCP command handlers asynchronous?

I have been having exceptions crop in my application, either stack overflow or our of memory. They show up in different places, depending on when the system has had enough. To put it another way, running the app twice won’t lead to the same…
Mawg says reinstate Monica
  • 38,334
  • 103
  • 306
  • 551
0
votes
1 answer

Delphi FireDac subsequent parameterized MySQL StoredProcedure execution fails with "Lost connection to MySQL server during query" exception

For a reproduction of the issue, let's have the following two super simple SPs, the first without any parameters, the second with only an output parameter: 1. testsp_0_nopar: CREATE DEFINER=`root`@`%` PROCEDURE `testsp_0_nopar`() BEGIN #do…
gergelykrasznai
  • 1
  • 1
0
votes
0 answers

cursor firebird move some rows tableA to tableB

I want to move specific lines (some fields) from a tableA to a tableB by deleting these rows from tableA. I use Delphi version Rio with FireDAC with Firebird RDMBS. I use a procedure to move and delete a single line I can not use this cursor to…
nabil doghmane
  • 1
0
votes
0 answers

AnyDAC components execute SQL query slower than FIBPlus components

The following SQL command returns approximately 4.500 records and contains integer-, string- and blob (text) values. All indexes are set properly. Furthermore we know that the in clause is not the best but that shouldn't bother us right now. The SQL…
Mr.Darcy
  • 11
  • 2
0
votes
2 answers

FireDAC (FDQuery) - database with dot in it's name

I have got this problem with FireDAC -> FDQuery component when it tries to select data from a database with '.' (dot) in its name. The database name is TEST_2.0 and the error on Opening the dataset says: Could not find server 'TEST_2' in…
Michal B
  • 21
  • 4
1
2
3