--- In firebird-support@yahoogroups.com, "Richard Thomas"
<rthomas@...> wrote:

>
> Hi All:
> I'm running Firebird Super Server trying to use ODBC. First, do I

have to define the DataBase DSN in the Windows Control Panel, Admin,
Data Sources, ODBC fields? I don't see the Firebird Driver listed for
drivers under the Windows Admin Tools either. Second, is there a good
tutorial on using the ODBC API calls? For example, what calls do I
need to make in order to perform allocation functions, connection and
related housekeeping and in what order for a FB DataBase?

> I have examples of using the Windows ODBC32 dll's with SQL Server

and an Access DataBase under Liberty Basic. One diference was the
inclusion of a passed literal "server=xxxx" in the SQL Server sample
program but I don't see anything in the Firebird ODBC Documentation
about that particular requirement for the FB connect string.

> Anyway, I'm up for more learning so will appreciate any pointers.
> In the mean time I'll go back and re-read everything to see if I

missed something.

Hello Rick,

I do not use ODBC regularly as there are lots of component sets that
natively talk to Firebird from Delphi, however I did install it once
to get a third party tool to recognise Firebird.

ODBC Administrator can be launched here:
%SystemRoot%\system32\odbcad32.exe

In the Drivers tab, there should be a record

'Firebird/Interbase(r) Driver'

I set up a User DSN that used this driver, and it worked for me, but I
am not able to tell whether this is an ideal way to do it.

Adam