Subject Connecting to a Firebird database using ODBC on Windows Web Server 2008 R2
Author rzward

I have installed Firebird 2.1, FlameRobin, Easysoft Firebird ODBC driver and Firebird/Interbase(r) ODBC 32-Bit and 64-Bit drivers on a computer running Windows Web Server 2008.

Using FlameRobin, I can connect to a Firebird 2.1 database but I'm not able to connect to any Firebird database using any of the ODBC drivers.

For example, when I use either the 32-bit or 64-bit ODBC Data Source Administrator to create a System DSN, when I click on the Test Connection button on the Setup dialog box, I see an error message that says "Open database 'LocalHost:C:\Firebird\Data\INTERIM2WEB.FDB' failed".

I have tried using the IP address of the computer, LocalHost and nothing preceding the path for the database. So, for example,


Otherwise, the path, database account and password settings are the same as the database registration information used in FlameRobin and FlameRobin connects to the database without any problem.

I have checked the permission settings on the FDB file and don't see anything obvious. Maybe ODBC requires a different system account access to the file?

Any help would be greatly appreciated.