Publish date: 2016-10-30

Sneak peek of «Native OLE DB Provider for Firebird v3»

We invite everyone to test the next version of IBProvider, which allows to work directly with Firebird v3 through INET (TCP/IP) connection.

The current assembly v3.34.0.22607 has passed functional and load testing. Improvements and changes are not planned. The release will be available within a month.

Everyone who purchases or renews the IBProvider license before the release of version v3.34 will get the 500 days of free updates and +100 to karma.

Connection setting

To connect to Firebird v3 without using fbclient.dll you should:

  1. Install trial of IBProvider v3.34.
  2. Set the initialization property «dbclient_type» to the «fb.direct» value.
  3. Specify the exact case of the characters in the user name. For example — «user id=SYSDBA».
  4. In the «location» property, specify connection via TCP/IP. For example:
    • «location=localhost:d:\database\employee.fdb»
    • «location=localhost/3050:d:\database\employee.fdb»
    • «location=192.168.1.2:d:\database\employee.fdb»
    • «location=192.168.1.2/3050:d:\database\employee.fdb»
    • «location=inet://localhost/d:\database\employee.fdb»
    • «location=inet://localhost:3050/d:\database\employee.fdb»
    • «location=inet://192.168.1.2/d:\database\employee.fdb»
    • «location=inet://192.168.1.2:3050/d:\database\employee.fdb»
    • «location=inet4://localhost/d:\database\employee.fdb»
    • «location=inet6://localhost/d:\database\employee.fdb»

You can also explicitly specify the authentication method (Srp, Legacy_Auth, Win_Sspi), defining the connection string the property «remote:auth».

For advanced connection settings are also available properties «remote:protocol», «remote:protocol_type», «remote:protocol_arch», «remote:wire_crypt».

If you encounter any problems or have any questions — please contact with us.


Publish date: 2016-10-30. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link https://www.ibprovider.com/eng required.