At 08:13 AM 10-04-02 +0000, George wrote:

>I am trying to automate creating of databases on a remote
>server. Basically, the user will hit a button that will fire an
>IB_Objects scripts. It works great locally, but not for the remote server.
>
>To try to isolate the error I have done some experiments with IBConsole.
>
>I can create a database in the standard fashion on the remote server
>(Database - Create Database), and I can create a database locally with the
>following SQL statement in Interactive SQL.
>CREATE DATABASE 'c:\TEST2.GDB'
>USER 'SYSDBA'
>PASSWORD 'MASTERKEY';
>
>But when I try to use the same code for the remote case, I get the
>following error message:
>
>Your user name and password are not defined. Ask your database
>administrator to set up a Firebird login
>Database: c:\TEST2.GDB
>
>Can anyone explain this, or help me to solve the problem?

One or two possibilities...

1. Is the password 'MASTERKEY' or 'masterkey'? (Passwords are
case-sensitive).
2. Users and passwords belong to the server, not to the database. A user
which doesn't exist on the remote server won't be able to own a database -
meaning your script fails if the user is missing or the password is wrong.

cheers,
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________