New article
Recently updated
Installing the Firebird ODBC Driver (32Bit)
After downloading the Firebird ODBC Driver, double-click to begin the installation. On the Welcome screen click Next.
Accept the agreement and then click [Next].
On the Information screen click [Next].
On the Select Destination Location screen click [Next].
On the Select Components screen click [Next].
On the Select Start Menu Folder screen click [Next].
On the Ready to Install screen click [Install].
On the Information screen click [Next].
On the Completion screen uncheck the View Readme.txt checkbox and then click [Finish].
In My Computer go to C:\windows\SysWOW64 (C:\Windows on a 32Bit machine) and double-click on odbcad32.exe.
In the ODBC Data Source Administrator | [User DSN] tab, click the [Add] button.
On the Create New Data Source screen choose Firebird/Interbase(r) driver and click [Finish].
The Data Source Name will be Firebird. Call the Description something relevant. The path to the Database needs to be an absolute path and include the server name and a colon (see screen shot below for an example). The Client field should point to the GDS32.DLL file in the C:\Program Files\IdeaGen\WBPro\Atlas Client\Client Executable folder. The Database Account should be VIEWER and the password should be viewer (assuming this user has been set up already). NOTE: You can use the SYSDBA user and password, but be very careful as this user has full access to the database including Read/Write permission, whereas the VIEWER user only has Read. The rest of the fields can be left as default.
Click the [Test Connection] button and you should receive a Connection successful! message.
The connection to the database can now be added as a Workbook Connection in Excel. In Excel go to the [Data] tab and click [Connections]. On the Workbook Connections screen click [Add].
On the Existing Connections screen click [Browse for More] and on the Select Data Source screen click [New Source].
Double-click [ODBC DSN].
Double-click [Firebird].
Here you can choose to connect to the database or a specific table, then click [Finish].