Subject | Re: [firebird-support] Embedded & ISQL |
---|---|
Author | Nando Dessena |
Post date | 2004-04-08T15:42:30Z |
Tanz,
T> I need to extract metadata in client machines "isql -x mbsbirdy.fdb
T> -u sysdba -p masterkey -o meta.sql" How can I run the ISQL.exe
T> (which comes with FB1.5) in client machines which has run with
T> embedded version? ISQL say -904 UnavailableDatabase
isql links to fbclient.dll, so if you rename fbembed.dll to
fbclient.dll isql will be perfectly happy to connect. Of course before
you try you should close any other embedded connection to the same
database: you can connect to an embedded database from one process at
a time.
T> Embedded version has no security object so declaring user/pass
T> is not necessary I think.
It is. It does not check passwords, but it checks user names and role
names and in any case both username and pw are mandatory. Just use
SYSDBA/whatever.
Ciao
--
Nando Dessena
mailto:nandod@...
T> I need to extract metadata in client machines "isql -x mbsbirdy.fdb
T> -u sysdba -p masterkey -o meta.sql" How can I run the ISQL.exe
T> (which comes with FB1.5) in client machines which has run with
T> embedded version? ISQL say -904 UnavailableDatabase
isql links to fbclient.dll, so if you rename fbembed.dll to
fbclient.dll isql will be perfectly happy to connect. Of course before
you try you should close any other embedded connection to the same
database: you can connect to an embedded database from one process at
a time.
T> Embedded version has no security object so declaring user/pass
T> is not necessary I think.
It is. It does not check passwords, but it checks user names and role
names and in any case both username and pw are mandatory. Just use
SYSDBA/whatever.
Ciao
--
Nando Dessena
mailto:nandod@...