Subject Re: EVEN MORE Re: [firebird-support] isql, ibconsole on FB Embedded?
Author Rob Cecchino

Your instructions helped! I was using the fbclient.dll from the server,
instead of the fbembed.dll (and renaming it to fbclient.dll).

Ibconsole and isql both work. After starting ibconsole, I am prompted to
start the server. You have to click 'Yes' (even if this is the embedded
version). After clicking Yes ibconsole complains that "Interbase Server is
not installed on your system" - this because of the missing
KEY_LOCAL_MACHINE\Borland\Interbase keys. Thats ok though, it attachs to
the db just fine after that.


<BEGIN clean fileset>

Directory of C:\emb

09/10/2003 10:05p 1,515,520 fbclient.dll
09/14/2003 11:15a 18,034 firebird.conf
09/11/2003 09:35a 132,816 firebird.msg
09/10/2003 10:05p 1,515,520 gds32.dll
09/10/2003 10:13p 24,576 ib_util.dll
10/02/2000 11:23a 1,997,312 IBConsole.exe
01/11/2002 06:54p 24,405 IPLicense.txt
09/11/2003 09:38a 237,568 isql.exe
09/14/2003 12:11p 593,920 hello.fdb

Directory of C:\emb\intl

09/10/2003 10:14p 651,264 fbintl.dll

Directory of C:\emb\udf

09/10/2003 10:11p 24,576 fbudf.dll
10/13/2002 04:50p 6,363 fbudf.sql
09/10/2003 10:13p 24,576 ib_udf.dll
02/04/2003 09:27p 18,878 ib_udf.sql


----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <>
Sent: Saturday, September 13, 2003 11:26 PM
Subject: EVEN MORE Re: [firebird-support] isql, ibconsole on FB Embedded?

> Rob,
> I have put you crook, sorry.
> Have just set up Embedded on a "clean machine" and here's what I have:
> At 10:07 AM 13/09/2003 -0700, you wrote:
> >heres how I have our dir structure
> >
> I have RootDirectory pointing to d:\MyApp1
> Here are my paths:
> > firebird.conf d:\MyApp1\firebird.conf
> >firebird.msg d:\MyApp1\firebird.msg
> >fbclient.dll d:\MyApp1\fbclient.dll (one copy of fbembed.dll)
> >ib_util.dll d:\MyApp1\ib_util.dll
> >gds32.dll d:\MyApp1\gds32.dll (second copy of fbembed.dll)
> >testdb.gdb d:\MyApp1\leisurestore.fdb
> >myapp.exe d:\MyApp1\ib_sql.exe
> >isql.exe d:\MyApp1\isql.exe
> >intl/fbintl.dll d:\MyApp1\intl\fbintl.dll
> >udf/*.sql,*.dll d:\MyApp1\udf/*.sql,*.dll
> >
> >Does this all look right?
> So, yes, I confirm that this looks right and that you *don't* need a bin
> directory. What I suggested would put isql.exe and the other dlls I cited
> in the wrong place relative to the embedded server binary :-/
> OK. You'll need ibconsole in your equivalent of d:\MyApp1\, minus its own
> copy of gd32.dll. This will snafu things because it's the ib6
> client. Just rename it to some amorphous like ohdear.dll.
> isql works fine in this setup. I refute what I said before: you don't
> need the absolute path to the db if it's in the same dir as isql.exe.
> also connects fine to any other db on the system, using absolute (local)
> path. isql wants fbclient.dll, and refuses to do anything with gds32.dll.
> I'm using ib_sql.exe as my local app. Although I can compile it to use
> fbclient.dll - or, indeed, fbembed.dll - currently I have it compiled to
> use gds32.dll, to mimic your situation with ibconsole. Hence, I need
> gds32.dll AND fbclient.dll copies of fbembed.dll in order to use both isql
> and the app.
> So - putting aside my suggestion about absolute path, I can't figure out
> why my setup works and yours doesn't. I'm using all exes and dlls as
> distributed in the RC6 embedded kit and it works exactly according to the
> readme.
> I just wonder whether perhaps you tried to run isql while you already had
> your app attached to the database. That *won't* work - two instances
> be able to connect to the same db concurrently, because the first instance
> puts an exclusive lock on the db file.
> I won't harass Dmitry about this after all. :-) I already answered my
> questions. And I hope you got to THIS message before you wasted time on
> two previous ones.
> heLen
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to