Subject RE: [firebird-support] Can't access FB 2.0 database using alias
Author Rick Debay
It turns out the "" around the fully qualified path was the problem.
Removing the quotes fixed it. Please ignore.

-----Original Message-----
[] On Behalf Of Rick Debay
Sent: Wednesday, February 28, 2007 12:29 PM
Subject: [firebird-support] Can't access FB 2.0 database using alias

Alias.conf contains: inventory = "c:\databases\tstdb_1-0-0.fdb"
On startup, this file does not exist and server log contains: 'Value
"c:\databases\tstdb_1-0-0.fdb" configured for alias
"c:\databases\tstdb_1-0-0.fdb" is not a fully qualified path name,
Database is created and committed with: CREATE DATABASE
After this all connections attempted to 'localhost/3051:inventory' do
not attach to the new file, instead they go to a file called 'inventory'
in the current working directory.

If the aliased database doesn't exist when the server starts, the alias
is never used. Nor, as the attached email shows, can the database be
created by referencing an alias.
Therefore to create new databases on our production server, we have to
change the configuration from None to Restrict, restart, run scripts
using the fully qualified path, and then restart again setting access
back to None.
What should be done is a new alias is created, the database is created
and DDL executed with the alias, and then the alias published. The
server shouldn't need to be restarted.

If I have any steps wrong, let me know as this makes it a pain to

Rick DeBay

-----Original Message-----
[] On Behalf Of Rick Debay
Sent: Monday, February 26, 2007 1:29 PM
Subject: [firebird-support] Can't create database using alias

I'm using FB 2.0 on Windows XP, and I'm trying to pass an alias in to
CREATE DATABASE in isql. I don't want the script to determine the
database location, I want that set by the server admin.

isql -user inventory -password test -input "c:\DBCreate.sql"
Strangely enough returns
'Use CONNECT or CREATE DATABASE to specify a database'
But the database is created.

isql -user inventory -password test -input "c:\DBCreate.sql"
Fails with
Use CONNECT or CREATE DATABASE to specify a database Statement failed,
SQLCODE = -902 I/O error for file "localhost/3051:tstdb"
-database or file exists
can't format message 17:120 -- message text not found

DBCreate.sql contents:

CREATE DATABASE 'localhost/3051:c:\databases\tstdb_1-0-0.fdb'
--CREATE DATABASE 'localhost/3051:tstdb'
USER 'inventory'

Alias.conf contents:

# List of known database aliases
# ------------------------------
inventory = "c:\databases\tstdb_1-0-0.fdb"

Disclaimer: This message (including attachments) is confidential and may
be privileged. If you have received it by mistake please notify the
sender by return e-mail and delete this message from your system. Any
unauthorized use or dissemination of this message in whole or in part is
strictly prohibited. Please note that e-mails are susceptible to change.
RxStrategies, Inc. shall not be liable for the improper or incomplete
transmission of the information contained in this communication or for
any delay in its receipt or damage to your system. RxStrategies, Inc.
does not guarantee that the integrity of this communication has been
maintained nor that this communication is free from viruses,
interceptions or interference.

------------------------ Yahoo! Groups Sponsor --------------------~-->
Something is new at Yahoo! Groups. Check out the enhanced email design.


Visit and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links