🚀 go-pugleaf

Note that local database access under Vista should work if you run 
InterBase as an application instead of as a service ...

Bob wrote:
> I have a ddl file that I run through IBSql to create my database file.
> 
> The CREATE DATABASE sql that I have been using has worked fine in w2000
> and WinXP, however, now that I am trying to build this database in
> Vista, I am running into some problems.
> 
> My original syntax was as follows.  It would create the database in the
> current folder in which I was running ibsql.
> 
> CREATE DATABASE 'mydatabase.gdb' PAGE_SIZE 8192 USER 'xxx' PASSWORD xxx'
> ;
> 
> 
> Now, under Windows Vista, it seems that you cannot access databases
> directly and that you must specify a server.  So, I added "localHost:"
> to my CREATE database command.
> 
> CREATE DATABASE 'localHost:mydatabase.gdb' PAGE_SIZE 8192 USER 'xxx'
> PASSWORD 'xxx'
> ;
> 
> This works fine, but the database ends up in the C:\Windows folder???
> I can modify this to something like
> 'localHost:D:\somefolder\mydatabase.gdb',  but the way our machines are
> setup, I really need the database created in the "current" folder.
> Which could be different from machine to machine.
> 
> 
> My question.  Is there a way to specify a relative path when using the
> TCP names?  I tried "localHost:.\mydatabase.gdb" but this gave errors.
> 

-- 
CREATE DOMAIN NEW_COMPANY AS CHAR(8) DEFAULT 'CODEGEAR' CHECK (VALUE <> 
'BORLAND') NOT NULL;