Firebird is a cross-platform open source database for Interbase Authorization Protocol (IPL), from Borland's Interbase to take off. When I used Interbase / Firebird, when I was published, even one user had to install at least one localserver, some single-machine version of the program had to use Access to save data. However, Microsoft's MDAC is often a few inexplicable problems. The Access2000's database files often appear in Win98. "Insert can't be positioned when inserted ...", "encounter BOF / EOF ...", unclear error prompt , Install the new version of MDAC and hit the OLEDB patch to solve the problem, but a few hundred-k small procedures will bring the seven-eightg patch feeling. I have always hope that I can use Interbase / Firebird to store storage for desktop data, that is, because the problem with the server has not been good.
Now I finally released embedded firtbird, we can use firebird embbed as a desktop database, just like the C / S version of Firebird data Kui, provide adequate support for many modern database features, you can use triggers, stored procedures, you can Define types to customize external functions. And he uses the same file format with Firebird C / S, but also supports a database file to multiple files, putting its data files on Firebird C / S immediately, you can use the single-machine application to transform C / S is placed on the web. Application development is different from Firebird C / S, you can use its C API, you can also use the Delphi / BCB of Interbase and DBX components. Of course, after the ODBC driver is installed, it is also possible to use ADO. You only need to provide a DLL when publishing procedures, our fire bird application can work (use ADO, using DBX also requires midas.dll and dbexpint.dll), you can easily make installer, all configuration work Can be controlled by the programmer himself, nor is it worried that the database will be changed directly by the user. And as far as I know, the embedded database seems to have not supported the stored procedures and triggers, Access, SQLITE can't do, don't say DBF and Paradox.
