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

I have installed Firebird 2.1, FlameRobin 0.9.2.1851, 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,

LocalHost:C:\Firebird\Data\INTERIM2WEB.FDB
192.168.0.13:C:\Firebird\Data\INTERIM2WEB.FDB
C:\Firebird\Data\INTERIM2WEB.FDB

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.

Richard