Subject | Connecting to a Firebird database using ODBC on Windows Web Server 2008 R2 |
---|---|
Author | rzward |
Post date | 2010-10-01T15:43:28Z |
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
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