[DUG] Creating Firebird 2.0 database
Steve Peacocke
steve.peacocke at gmail.com
Thu Jun 21 15:44:56 NZST 2007
Thanks Edward,
I just got back from Brisbane so my brain wasn't working as it should.
It was nice and warm over there and I came back to this weather (still
wondering why).
Steve
On 21/06/07, Edward Koryagin <ed_iv2001 at yahoo.co.nz> wrote:
> CREATE DATABASE 'Y:\db\blah.fbd' USER='SYSDBA'
> PASSWORD='masterkey'
> --- Steve Peacocke <steve.peacocke at gmail.com> wrote:
>
> > Gidday everyone,
> >
> > I'm trying to create a Firebird 2.0 database. I've
> > installed Firebird
> > on to the server and checked that it is indeed
> > running in the list of
> > Services on that machine.
> >
> > I have run the same install on my computer to
> > install ONLY the client
> > version on y computer. It has also installed and
> > running in the list
> > of Services.
> >
> > The tool that I'm using (fromi SQLLY) to create the
> > database comes up
> > with an error, so in an attempt to get to what the
> > problem is I place
> > commands into ISQL, one after another.
> >
> > SET TERM; <-- works fine
> > SET SQL DIALECT 3; <-- works fine
> > CREATE DATABASE 'Y:\db\blah.fbd'; <-- ERROR HERE!
> >
> > The error returned is..
> > > Statement failed, SQLCODE = -902
> > > your user name and password are not defined. Ask
> > your
> > > database administrator to set up a Firebird login.
> >
> > I am creating this database under the standard
> > SYSDBA user so there
> > should be no problems.
> >
> > Can anyone point me in the right direction here?
> > What have I forgotten to do?
> >
> > Steve
> >
> > --
> > Steve Peacocke
> > http://stevepeacocke.blogspot.com/
> > _______________________________________________
> > NZ Borland Developers Group - Delphi mailing list
> > Post: delphi at delphi.org.nz
> > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > Unsubscribe: send an email to
> > delphi-request at delphi.org.nz with Subject:
> > unsubscribe
> >
>
>
> Edward Koryagin
>
> Send instant messages to your online friends http://au.messenger.yahoo.com
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
>
More information about the Delphi
mailing list