![Firedac Cannot Load Vendor Library Libpq.dll Firedac Cannot Load Vendor Library Libpq.dll](http://uploaddeimagens.com.br/images/000/262/058/original/ErroDLLPostgreSQL.png)
FireDAC Tip2 First Application @Gustavo: You can use FireDAC with DataSnap by two different ways (or you can combine them): 1) At server side you can use FireDAC to get access to a DB. And again 2 ways: a) Using classical MIDAS approach you can link a TDataSetProvider to a FireDAC dataset and provide access to the data to the MIDAS clients.
After the first FireDAC tip covering installation, let me start looking into actual development. FireDAC offers ready to use TDataSet descendant classes, like TADQuery, TADMemTable, TADStoredProc, and TADTable. They tend to have properties very similar to the corresponding BDE classes and the TClientDataSet. There are some more differences with the dbExpress datasets.The underlying architecture, however, is more similar to recent versions of dbExpress and with ADO.NET, with data access classes representing commands and record sets. But this is a more advanced topic, good for a future tip.Let's start by building a simple VCL application (FireMonkey one will be similar, of course, and I’ll build it next).
The minimum set of components you need is:. The ADConnection component with minimal database configuration. An ADQuery component hooked with the connection (it connects automatically as you drop it in a designer with a connection). The query has a SQL text string list property, as in the BDE. FireDAC Tip2 First ApplicationWe've amended the FAQ matching the license. You can use it:What if I have an earlier version of Delphi, CBuilder or RAD Studio andwant to get FireDAC?You can upgrade your Delphi, CBuilder or RAD Studio to anEnterprise, Ultimate, or Architect edition of version XE3, and you willhave access to FireDAC XE3 for free. You can also buy FireDAC for XE3,install it with a special command line parameter to install it for yourcurrent, older version of the IDE.
You can also purchase an XE3Professional product and add FireDAC by purchasing the Client/ServerPack.The special command line parameter should be /IDE:DXE2 for XE2-MarcoComment by Marco Cantuon March 8, 08:45. FireDAC Tip2 First Application@Gustavo: You can use FireDAC with DataSnap by two different ways(or you can combine them):1) At server side you can use FireDAC to get access to a DB. And again 2ways:a) Using classical MIDAS approach you can link a TDataSetProvider to aFireDAC dataset and provide access to the data to the MIDAS clients.b) Using 'new' DataSnap server methods you can return a FireDACdataset and provide access to the data to the DataSnap clients, callingthe server method.2) At client side you can use FireDAC DataSnap driver to connect to aDataSnap server and use TADStoredProc to call DataSnap servermethods.In future, FireDAC may extend support for DataSnap.Comment by Dmitry Arefievon March 14, 13:16. FireDAC Tip2 First ApplicationHi! Reggarding the use of TADMemTable instead ofTClientDataSEt for in memory tables.
I've done sometests and when appending and deleting rows theClientDataSet is faster than the TADMemTable. Whenall documentation says otherwise. I've notice thatthe last benchmarks of ClientDataSet vs TADMemTableavailable are from 3 years ago. As the speed ofClientdataset changed from then?Note: When looping and editing the rows TADMemTableis out-of-this-world faster than ClientDAtaSet. All iwant to know is what am i missingThank youComment by Tiago Rodrigues on March 20, 10:59. FireDAC Tip2 First ApplicationHi Marco,I'm trying to connect a VCL Forms Application to theDataSnap Application using FireDAC. At client side I useFireDAC DataSnap driver to connect to a DataSnap serverand use TADStoredProc to call DataSnap server methods.But when I set the property StoreProcName a exception israised with message: tdbxtypes.int64 value type cannotbe accessed as tdbxtype.int32 value type.What can I do to solve this problem?Best Regards,Marcelo VarelaComment by Marcelo Varela on May 29, 19:14.
FireDAC Tip2 First ApplicationI've done the tutorial connecting to a MSSQL database: worksperfectly!I have a question concerning the way FireDAC accesses the data. Isit possible not to connect to a DB Server(even local) but to accessdirectly the DB Files (like I actually do with Advantage Database)I don't think that is possible with Microsoft SQL Server but I'masking anywayComment by Maxime Bonin on March 6, 18:17Post Your CommentClickyour feedback to this blog.There are currently 0 pending (unapproved) messages.