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

c:\data\xyz.gdb

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
192.168.1.1:c:\mydatabase\xyz.gdb or
192.168.1.1:/home/data/teste.gdb

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
connection...

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
passwords...


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - BRAZIL
www.thorsoftware.com.br


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:
>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
>====
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/