Got it working. It is not pretty to have to copy fbembed.dll to fbclient.dll. If
I was in linux I could hard link it. Oh well, what is perfect these days?

Thank you for engaging me on this and helping me get it working.
Adrian




________________________________
From: Alexandre Benson Smith <iblist@...>
To: firebird-support@yahoogroups.com
Sent: Thu, December 9, 2010 12:01:39 AM
Subject: Re: [firebird-support] isql: how to connect to embedded server


Em 9/12/2010 02:43, Adrian Grajdeanu escreveu:

> In my application I am using scenario 3 you mention: easy
> installation/distribution. I have downloaded and successfully applied the
> instructions. I have used this resulting setup to successfully create the
> database (fdb). Now all I want is to coerce isql to use embedded server itself
> to connect to the fdb. I want to see in isql exactly what my application would
> see, using the same embedded server architecture. So far I have been
> unsuccessful in convincing isql to use embedded server. Hence my plea for help
> :).
>
> Adrian
>
>
>

ok... Now it's clear to me...

Put the fbembedded.dll in isql directory, rename it to fbclient.dll

I think that it's all you need.

Beside that, you could do the reverse way...

In the same directory structure that you could successfully create the
database, put isql.exe in the same directpry that is the application
that created the database. rename fbembedded.dll to fbclient.dll, run
isql from that directory.

If your are unable to connect, put the file listing that are on that
directory here, so someone could try to help you out.

see you !

> ________________________________
> From: Alexandre Benson Smith<iblist@...>
> To: firebird-support@yahoogroups.com
> Sent: Wed, December 8, 2010 8:31:17 PM
> Subject: Re: [firebird-support] isql: how to connect to embedded server
>
>
> Em 8/12/2010 21:38, Adrian Grajdeanu escreveu:
>> All I'm trying is to open up the fdb without going through a server. How do I
>> do
>> that? I don't care whether it is called embedded server or regular fb client.
>> I'm not quite sure what the difference is anyway, except that fb client can
>> (should) go through any flavor of servers: embedded or not.
>>
> It's not a matter of how it's called, but wich archtecture do you use :)
>
> regular firebird client will connect to a firebird server, the embedded
> server is the server itself packed oon a DLL, so it runs in the
> application space.
>
> The embedded server is available to download in a zip kit separated from
> the regular Client Server instalation.
>
> I don't understand your phrase "All I'm trying is to open up the fdb
> without going through a server".
>
> do you mean:
> 1.) I don't want a network connection to another computer
> 2.) I don't want a server (service) running on the local computer
> 3.) I wish an easy instalation/distribution to access a database from a
> single application (tipical mono-user application). Note. FB 2.5 allows
> more than one process to access the same database at once.
>
> Embedded server is used for the scenario #3
>
>> So basically: how do I connect isql to a local fdb, without going through a
>> service bound server?
>> Thanx.
>> A.
>>
> You could access a local fdb using a regular client/server approach
> using the loopback interface or the local connection. Embedded will
> provide "direct" access the the file with an embedded server in your
> application.
>
> If you want to use the embedded server download the zip kit (there are
> more detailed instructions on the zip kit), but in a simple way.. just
> rename fbembedded.dll to fbclient.dll or gds32.dll and put it in the
> same path as you executable (or isql if you wish to use it).
>
>> ________________________________
>> From: Alexandre Benson Smith<iblist@...>
>> To: firebird-support@yahoogroups.com
>> Sent: Wed, December 8, 2010 6:19:58 PM
>> Subject: Re: [firebird-support] isql: how to connect to embedded server
>>
>>
>> Em 8/12/2010 18:59, adriangrajdeanu escreveu:
>>> Hi,
>>> I've created an app from which I create a 'test.fdb' using user 'alpha' pwd
>>> 'beta'. Now I want to look at 'test.fdb' using isql and I am unsuccessful.
>>>
>>> Seems that I can only connect isql _iff_ the windows service is running and
> as
>>> 'SYSDBA'. Alas, I can't connect as as user 'alpha'. Nor do I want to. I want
>> to
>>> connect as user 'alpha', just as my app will, and see just what my app will
>>> see.
>>> If I stop the service, I can't even connect as 'SYSDBA'. What am I missing?
>>>
>>> My db is in W:\Fb-Data\test.fdb, my Firebird installation is in "C:\Program
>>> Files\Firebird\Firebird_2_5"
>>> I've tried from the fdb directory like so:
>>> W:\FB-Data>"c:\Program Files\Firebird\Firebird_2_5\bin\isql.exe" -U alpha -P
>>> beta test.fdb
>>> Statement failed, SQLSTATE = 08001
>>> unavailable database
>>> Use CONNECT or CREATE DATABASE to specify a database
>>> SQL>
>>>
>>> BTW, tested with ' and with " around user and pwd, same failure.
>>>
>>> Then I've tried from the isql dir like so:
>>> c:\Program Files\Firebird\Firebird_2_5\bin>isql -U alpha -P beta
>>> W:\FB-Data\test.fdb
>>> Statement failed, SQLSTATE = 08001
>>> unavailable database
>>> Use CONNECT or CREATE DATABASE to specify a database
>>> SQL>
>>>
>>> Again, tried with ' and " around user/pwd, same failure.
>>>
>>> I've tried as SYSDBA/masterkey in both scenarios, still failure.
>>>
>>> I've copied dlls and isql.exe and firebird.msg in same dir with fdb, same
>>> failures. I've copied dbclient.dll into fbembed.dll and gdb32.dll, still
>>> failure.
>>>
>>> So, is it possible at all to use isql to connect to a fdb via an embedded
>>> server? Programatically I had to specify ServerType=Embedded (not precise
>>> syntax
>>> shown), but if that is what I need, how do I do it to isql?
>>>
>>> Thanx,
>>> Adrian
>> Perhaps I didn't understand you correctly... but are you sure you are
>> using the Enbedded server and not then regular fb client ???
>>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]