I have problem with connecting to a Firebird database. It works perfectly, when I use isql
tool, or program I have written using Borland dbExpress drivers. When I try to test ODBC connection it fails. I am using official Firebird ODBC drivers, version 2.0.
Strange facts:
- On other machines in the same network ODBC connection test fails, however:
- When the same test is held in different network it seems to work
- When ODBC driver is installed on the same computer as Firebird server it also work flawlessly.
- Other ODBC drivers do work in this unfortunate network.
I ran out of ideas what might be the cause of this, and how to find root of all problems.
Best Answer
isql or dbexpress is direct access to firebird (only use fbclient.dll)
ODBC is the old access for windows technology
You'd better use OLE DB if you can. Here is a comparison between ODBC and ADO