I'm attempting to set up an ODBC connection
to a Firebird database. The ODBC dialog box
asks for:

Windows DSN name
InterBase database path

Character Set:
Role:

Can anyone explain what these four items are
and how to properly enter the required information?

Here's what I did (and it isn't working):

Windows DSN name: FireBirdTest
InterBase database path: c:\program
files\Borland\IntrBase\Examples\employee.gdb

Character Set: [Blank]
Role: [Blank]

I'm also lost in terms of how to set up a new
database. I tried to run:

C:\Program Files\Firebird\bin\isql.exe

It gave me a box where I could type stuff in
and it says:

Use CONNECT or CREATE DATABASE to specify a database

Here is what I typed in order to attempt to
create a database:

SQL> create database "test";

but it gives an error message:

Statement failed, SQLCODE = -902
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.

I guess I'm the database administrator since
I installed Firebird on the PC. I didn't see
any apportunity to enter a user name or a
password or to set up users or to do much of
anything. Firebird does show up in my SysTray
but when I click it, a form pops up but there
isn't much on it. There doesn't appear to be any
way to set up users or define databases or
anything like that. I assume there is something I
need to download in order to do this?

Thanks in advance.

Scott
====