Try adding the TCP/IP host name:

CREATE DATABASE 'MYSERVER:c:\TEST2.GDB'
USER 'SYSDBA'
PASSWORD 'MASTERKEY';



-----Original Message-----
From: georgethenorge [mailto:ghelmke@...]
Sent: 10 April 2002 10:13
To: ib-support@yahoogroups.com
Subject: [ib-support] CREATE DATABASE on remote server


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?

Thanks, George




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/