Subject Re: [ib-support] Win32 ODBC Setup
Author IB/FB List
To configure an ODBC driver or other kinds of firebird/interbase
connections you have to teel the database name

if your database is local just type the file naname and path


if it is on a remote computer will be something like this:
server:c:\data\xyz.gdb (on windows) or
server:/home/user/xyz.gdb (on unix or linux)

you could use ip address instead of host name like\mydatabase\xyz.gdb or

the database extension could be other than gdb you define it when you
create the database, in winXP you SHOULD use a different extension or
disable the System restore, because windows does not like firebird and the
first time you "touch" the database windows make a copy (is this correct
people ?) of the file, if your file is big you have a big delay in first

I forgot to tell in the other message, take a look in the Operation Guide
for the gsec utility, this utility let you create and change users and

Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - BRAZIL

At 10:05 16/11/2002 -0800, you wrote:
>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:
>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
>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.
>To unsubscribe from this group, send an email to:
>Your use of Yahoo! Groups is subject to