Subject Re: [firebird-support] isql error in vista
Author Helen Borrie
At 01:36 PM 31/01/2007, you wrote:
>Hello,
>
>I'm just setting up our development environment within vista. We use
>isql and sql scripts to create our empty databases within xp with no
>problems. However, in vista, when we try do to a 'create database
>etc' we get a '-904 unavailable database' error.
>
>===
>
>SET SQL DIALECT 3;
>
>CREATE DATABASE 'rising3.fdb' USER 'SYSDBA' PASSWORD 'masterkey'
>PAGE_SIZE 4096;
>
>===
>
>I have connected to the vista machine using ibexpert and opened up a
>database - so the server is running.
>
>Running FB 1.5.2.

You can't create a database without a fully-specified file path. Try
it again, using a proper file path specification, e.g.
'c:\databases\rising3.fdb', that is not a share or a mapped drive
location. If you are using DatabaseAccess = NONE or Restrict then
you will also need to have fixed up the alias or path location accordingly.

If you are running the server as an application, make sure that the
logged-in user has system create file rights in the specified path.

./heLen