Subject | CREATE DATABASE on remote server |
---|---|
Author | georgethenorge |
Post date | 2002-04-10T08:13:14Z |
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 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