How to specify Interbase or Firebird?
How to specify Interbase or Firebird?
I downloaded the IB-FB trial package. I expected 2 drivers, one for Interbase and one for Firebird, although I see only one. I understand the two database systems are similar, but I expect there are some differences. When my application makes a request, how do I tell the driver whether I am sending it an Interbase database or a Firebird database? I read through the documentation, such as it is, and didn't see anything about this. Does the driver determine this?
Re: How to specify Interbase or Firebird?
Hello,
dbExpress driver for InterBase and Firebird uses the client library that is specified in the TSQLConnection.VendorLib property. Usually, gds32.dll is the InterBase client library, and fbclient.dll is the Firebird client library. But dbExpress driver for InterBase and Firebird does not rely on the file name of the client library. After the connection to the server is established (if it is possible), dbExpress driver for InterBase and Firebird determines the version of the server and uses this information internally. This way dbExpress driver for InterBase and Firebird can use the unique functionality of each server.
dbExpress driver for InterBase and Firebird uses the client library that is specified in the TSQLConnection.VendorLib property. Usually, gds32.dll is the InterBase client library, and fbclient.dll is the Firebird client library. But dbExpress driver for InterBase and Firebird does not rely on the file name of the client library. After the connection to the server is established (if it is possible), dbExpress driver for InterBase and Firebird determines the version of the server and uses this information internally. This way dbExpress driver for InterBase and Firebird can use the unique functionality of each server.
Re: How to specify Interbase or Firebird?
Andrey, thank you. I originally got the Unsupported ODS message - found 32779 support 15.
After than I see that dbxdrivers.ini was installed with VendorLib-gds32.dll. Right now I am working on a Firebird database, so I can change that to FBClient.dll. I also see that dbxdrivers.ini contains GetDriverFunc=getSQLDriverInterBase. Is that the only driver and should remain unchanged?
After than I see that dbxdrivers.ini was installed with VendorLib-gds32.dll. Right now I am working on a Firebird database, so I can change that to FBClient.dll. I also see that dbxdrivers.ini contains GetDriverFunc=getSQLDriverInterBase. Is that the only driver and should remain unchanged?
Re: How to specify Interbase or Firebird?
To choose the database server (InterBase or Firebird), you should change only the VendorLib property. All other driver options (like GetDriverFunc or DriverName) you should not change.