16 versions of Firebird and InterBase are now available for recording on 64-bit platforms via MS SQL Linked Server
Firebird and InterBase users implementing IBProvider drivers in their work last year were the first to take advantage of 64-bit applications.
We have produced two more drivers in addition to 64-bit IBProvider v3: IBProvider v2 and IBProvider v1.
Firebird, InterBase and 64-bit MS SQL Linked Server
Due to 64-bit IBProvider v2 driver, 16 versions of Firebird and InterBase are now available for recording on 64-bit Windows OS via MS SQL Linked Server.
64-bit updatable rowsets in ADO
In addition to MS SQL Linked Server, there are many libraries and utilities that support updatable rowsets technology implemented only in IBProvider v2. One of such libraries is ADO library.
64-bit support in ADO and WHS allows to develop 64-bit automation scripts in VBScript language. For example:
- Firebird/InterBase database automated administration scripts;
- scripts for building reports, eporting to Office, XML, sending reports via email;
- database backup, recovery, and replication scripts;
- customizable business logic scripts in 64-bit applications;
- etc.
Using IBProvider v2 on 64-bit platforms
For IBProvider v2 to work on 64-bit platforms, you need to have 64-bit Firebird 2.1 or Firebird 2.5 client installed on the computer. You will need to rename client’s DLL from fbclient.dll into gds32.dll and copy it to system32 directory. You can also choose this option while installing Firebird client via the installer. You can download Firebird 2.1 and Firebird 2.5 here: Firebird download.
Raising stability of drivers
Insignificant errors have been fixed in the new version, including the error in KEYCOLUMN description of IColumnsRowset interface.
With IBProvider drivers, writing of applications for Firebird and InterBase will become an easy and fascinating task. We have made provision for the most difficult and will gladly share our technologies with you.