Subject Re: [IBO] Aliases on local connections IB_SQL
Author Helen Borrie
At 08:03 PM 12/02/2005 +1100, you wrote:

>Hi All,
>Has anyone tried to use aliases for local connections?


>Using IB_SQL I input 'security' to connect to my security
>database. It comes back saying that it cannot find the
>database (the error message having included the path for my
>application in front of the 'security').

I have an alias to security.fdb, defined as 'sec'

>I debugged IBO and it is definitely sending 'security'
>(so IBO is not adding the path).

It doesn't. The alias gets sorted on the server. Are you sure you don't
have a typo in aliases.conf?

>OTOH isql does not have
>this problem (and seems to use the same api call internally).
>So I am trying to work out if the problem is peculiar to
>my system or something else.

No sign of it here at all.

>Any suggestions?

Here's what I have in aliases.conf:
# Security database
sec = C:\Program Files\Firebird\Firebird_1_5\security.fdb

In the IB_SQL 'Database' field, sec
Plus SYSDBA and password.