UniDac and FireDac within the same project

[sandy771]

I have a project that uses UniDac extensively, however I need access to the ServerMode feature of DevExpress and this requires FireDac (I can't use the work around on the DevExpress site as I don't have the delphi personailty installed - I am using Builder XE5 pro).

When I have both FireDac and UniDac componnets on the same form and connected to the same database (sqlite) I get a database is locked error.

I don't want to move to FireDac (I can imagine other issues with other components I use within the project) so need ideally to connect a DevExpress grid to UniDac in ServeMode.

Has anyone done this in C++ builder?

Is/does Devart speak to DevExpress to arrange integration - I can see advanrtages for both companies (and customers) if these components worked seemlessly together

[AlexP]

Hello,

ServeMode for FireDAC (and for standard components) is implemented with the help of the TdxServerModeXXXDataSource devExpress components. You can contact devExpress developers to add ServMode components for UniDAC.

Since FireDAC uses the EXCLUSIVE mode for work with SQLite by default. To work simultaneously with the same SQLite database in UniDAC and FireDAC, you should change the mode in the FireDAC connection settings

[sandy771]

Thanks Alex - very helpful

I did contact DevExpress and unfortunately they said that they will "never support UniDac in server mode out of the box"!!!! Their web site seems to be down at the moment so I cant check their exact wording.

Seems extremely short sighted on their part.

[AlexP]

In one of the next versions we will ad a functionality similar to server mode in devExpress.

[sandy771]

Thanks Alex - I have implemnedted my own server mode whcih is working very well - but I expect you will do a better job

[AlexP]

We have added the SmartFetch mode, that allows to speed up navigation through a large number of records. The version with this feature is already available at our website.