At 07:18 3/10/2008, you wrote:

>Sasha,
>
>This is on whole new machine with no previous Firebird installations. it is Windows Server 2008, and I am logged on directly.

Are you sure you are "logged on directly"? And not trying to run your script in a remote desktop shell?

>. But I had the same problem on some remote Server 2003 machines with Firebird 2.0.

Under any of these circumstances, have you tried changing the host for the database string to the host machine's node name? Local loopback (localhost server) usually won't work with RDT on platforms later than Win2K but the host machine's node name should work in all cases. If not, make it static by including it in the hosts file - its own and any physically remote nodes that will need access.

BTW, *don't* attempt to use double-quotes to encase strings in SQL statements. They *can* be used around the access path string *at the command line* on a platform that doesn't like spaces. If you have spaces in a database path and you want to pass a CREATE or CONNECT statement through as script, use an alias. But use an alias regardless.

And - yes - you *can* use an alias for CREATE DATABASE - having first installed the alias, of course.

Suppose the alias is:

tmpitdb = d:\db\fb\Data\TmpltDb\TmpltDb.fdb

and the host name is 'dbserver'

Then

CREATE DATABASE dbserver:tmpitdb'
USER 'SYSDBA'
PASSWORD 'masterkey';

./heLen