Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 14-9-2014 03:05, Adam adam...@gmail.com [firebird-support] wrote:
 Hi Alan and thanks for your help. I checked the release notes and
 started again. This is my directory structure:

 D:\my_app\myapp.exe
 D:\my_app\myapp.FDB
 D:\my_app\fbclient.dll
 D:\my_app\firebird.conf
 D:\my_app\firebird.msg
 D:\my_app\IB_SQL.exe
 D:\my_app\ib_util.dll
 D:\my_app\icudt30.dll
 D:\my_app\icuin30.dll
 D:\my_app\icuuc30.dll

 D:\my_app\intl\fbintl.dll
 D:\my_app\intl\fbintl.conf

 D:\my_app\udf\fbudf.dll

 And still both myapp.exe and IB_SQL.exe give Database unavailable
 message (ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :(

Ok, so you don't have the error with your own application (myapp.exe), 
but with IB_SQL.exe? Is your own application running at that time? What 
is IB_SQL.exe?

Mark
-- 
Mark Rotteveel


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 14/09/14 09:25, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
 And still both myapp.exe and IB_SQL.exe give Database unavailable
  message (ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :(

 Ok, so you don't have the error with your own application (myapp.exe), 
 but with IB_SQL.exe? Is your own application running at that time? What 
 is IB_SQL.exe?

IB_SQL is the IBObjects admin tool ...

Adam - try Flamerobin http://www.flamerobin.org/ ... this is a little
more helpful in it's error messages. But I do wonder if you have another
fbclient.dll  that is being found first. I only ever run server
versions, but sometimes it plays up when an older client is found.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
Hi and thanks for jumping in Helen

On Sun, Sep 14, 2014 at 1:44 PM, Helen Borrie hele...@iinet.net.au
[firebird-support] firebird-support@yahoogroups.com wrote:



 At 01:05 p.m. 14/09/2014, Adam adam...@gmail.com [firebird-support] wrote:

 Hi Alan and thanks for your help. I checked the release notes and started
 again. This is my directory structure:
 
 D:\my_app\myapp.exe
 D:\my_app\myapp.FDB

 D:\my_app\fbclient.dll

 What's this file? It should be fbembed.dll renamed to fbclient.dll. If
 it's not, then it's the regular client API and you're getting the error
 because there's no server.

Yes it's fbembed.dll (from the Firebird-2.5.3.26778-0_x64_embed.zip root
folder) renamed to fbclient.dll.


 Also I'd want to check that your application (either via path name or
 using an alias) is connecting to a database path and not an unqualified
 file name for the DB. The server is embedded but it's still a server, not a
 file jockey.

I have tried both fullpath (D:\my_app\myapp.FDB) and just filename
(myapp.FDB) and in both cases cannot connect.

Adam


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
Hi Mark

The error exists for BOTH my application and the IB_SQL.exe client app and
I run these non-concurrently. IB_SQL is the Interbase Objects Firebird
database desktop tool (see: http://www.ibobjects.com/)



 Ok, so you don't have the error with your own application (myapp.exe),
 but with IB_SQL.exe? Is your own application running at that time? What
 is IB_SQL.exe?

 Mark
 --
 Mark Rotteveel

  



Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
Hi  Lester

On Sun, Sep 14, 2014 at 6:38 PM, Lester Caine les...@lsces.co.uk
[firebird-support] firebird-support@yahoogroups.com wrote:



 On 14/09/14 09:25, Mark Rotteveel m...@lawinegevaar.nl
 [firebird-support] wrote:
  And still both myapp.exe and IB_SQL.exe give Database unavailable
   message (ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :(

  Ok, so you don't have the error with your own application (myapp.exe),
  but with IB_SQL.exe? Is your own application running at that time? What
  is IB_SQL.exe?

 IB_SQL is the IBObjects admin tool ...

Yes that's right.


 Adam - try Flamerobin http://www.flamerobin.org/ ... this is a little
 more helpful in it's error messages.

FlameRobin gave the following error message:

IBPP::SQLException
Context Database Connect
Message =: isc_attach_database failed

SQL Message: -902
can't format message 13:98 -- message file c:\WINOWS\firebird.msg not found

Engine Code  :335544721
Engine Message:
Unable to complete network request to host localhost
Failed to establish connection.

So yes FlameRobin provides more information but still I cannot understand
why


 But I do wonder if you have another
 fbclient.dll that is being found first. I only ever run server
 versions, but sometimes it plays up when an older client is found.

Hmmm now this sounds interesting. I went searching for all other
fbclient.dll files and yes found some older ones for a previous project and
also in the C:|WINDOWS folder. I deleted these (the only one now left
is D:\my_app\fbclient.dll,
that is the one in myapp folder) and tried once again again.

1 - Running my app results in the following error message:

[FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll].
Hint: check it is in the PATH or application EXE directories, nd has x86
bitness.

2 - Running IB_SQL connects :-)

3 - FlameRobin

IBPP::SQLException
Context Database Connect
Message =: isc_attach_database failed

SQL Message: -902
Unsuccessful execution caused by  system error that precludes successful
execution of subsequent statements

Engine Code  :335544721
Engine Message:
Unable to complete network request to host localhost:3050
Failed to establish connection.
No connection could be made because the target machine actively refused it.

O interesting that IB_SQL connects but my app itself and FlameRobin don't.
Nevertheless it seem that we are getting further at long last Lester :-)
 The question i what next?

Adam


RE: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread 'Alan McDonald' a...@meta.com.au [firebird-support]
I have tried both fullpath (D:\my_app\myapp.FDB) and just filename (myapp.FDB) 
and in both cases cannot connect. 

 

Adam

 

And you are using cpLocal?

Alan







RE: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread 'Alan McDonald' a...@meta.com.au [firebird-support]
 

Engine Code  :335544721

Engine Message:

Unable to complete network request to host localhost

Failed to establish connection.

 

That means you are trying to use the TCP stack.

Alan



Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Sun, Sep 14, 2014 at 9:53 PM, 'Alan McDonald' a...@meta.com.au
[firebird-support] firebird-support@yahoogroups.com wrote:



 I have tried both fullpath (D:\my_app\myapp.FDB) and just filename
 (myapp.FDB) and in both cases cannot connect.



 Adam



 And you are using cpLocal?

 Alan


If this means Protocol then yes I have set Protocol to Local.


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote:
 Engine Code  :335544721
 Engine Message:
 Unable to complete network request to host localhost
 Failed to establish connection.
 
 So yes FlameRobin provides more information but still I cannot
 understand why

This means that your machine does not have the network configured
properly. Quite a common problem with windows these days. SO the next
question is ... is this machine actually on a network? If so
http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does
may help ...

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Iwan Cahyadi Sugeng iwan.c.sug...@gmail.com [firebird-support]
what is your connection string, don't use localhost:dbname format. Try use
only the filename. Try ems sql manager for firebird, it has embeded protocol
On 14 Sep 2014 19:01, Adam adam...@gmail.com [firebird-support] 
firebird-support@yahoogroups.com wrote:





 On Sun, Sep 14, 2014 at 9:55 PM, 'Alan McDonald' a...@meta.com.au
 [firebird-support] firebird-support@yahoogroups.com wrote:





 Engine Code  :335544721

 Engine Message:

 Unable to complete network request to host localhost

 Failed to establish connection.



 That means you are trying to use the TCP stack.

 Alan


 Sorry Alan but I'm not sure what this means.
  



Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 14-9-2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] 
wrote:
 On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote:
 Engine Code  :335544721
 Engine Message:
 Unable to complete network request to host localhost
 Failed to establish connection.

 So yes FlameRobin provides more information but still I cannot
 understand why

 This means that your machine does not have the network configured
 properly. Quite a common problem with windows these days.

A common problem? I don't actually think so. The question you link to 
below is also not very informative; and that is problem is probably more 
related to the fact that by default localhost resolves to ::1 (IPv6) 
instead of 127.0.0.1 (IPv4).

  SO the next
 question is ... is this machine actually on a network? If so
 http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does
 may help ...

The original question is about use of embedded. The fact that it is 
attempting to connect through localhost means that a hostname 
(localhost) is included in the connection string, which results in 
fbembed.dll acting as a normal fbclient, instead of using its internal 
server to access the database.

The real question is if this happens because the application itself 
specifies the hostname, or because the connection component 
automatically adds localhost if no hostname is specified.

Mark
-- 
Mark Rotteveel


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Sun, Sep 14, 2014 at 10:11 PM, Lester Caine les...@lsces.co.uk
[firebird-support] firebird-support@yahoogroups.com wrote:



 On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote:
  Engine Code :335544721
  Engine Message:
  Unable to complete network request to host localhost
  Failed to establish connection.
 
  So yes FlameRobin provides more information but still I cannot
  understand why

 This means that your machine does not have the network configured
 properly. Quite a common problem with windows these days. SO the next
 question is ... is this machine actually on a network? If so

 http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does
 may help ...

 This is a Standalone development machine.


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Sun, Sep 14, 2014 at 10:15 PM, Iwan Cahyadi Sugeng
iwan.c.sug...@gmail.com [firebird-support] firebird-support@yahoogroups.com
 wrote:



 what is your connection string, don't use localhost:dbname format. Try use
 only the filename. Try ems sql manager for firebird, it has embeded protocol

This is how I'm trying to connect:

  fdbPath := ExtractFilePath(ParamStr(0))+'CrypticMania.FDB';

  with ADConnection1.Params do begin
Clear;
Add('Database='+fdbPath);
Add('User_Name=SYSDBA');
Add('Password=masterkey');
Add('DriverID=IB');
  end;


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 14/09/14 13:20, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
 On 14-9-2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] 
 wrote:
 On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote:
 Engine Code  :335544721
 Engine Message:
 Unable to complete network request to host localhost
 Failed to establish connection.

 So yes FlameRobin provides more information but still I cannot
 understand why

 This means that your machine does not have the network configured
 properly. Quite a common problem with windows these days.
 
 A common problem? I don't actually think so. The question you link to 
 below is also not very informative; and that is problem is probably more 
 related to the fact that by default localhost resolves to ::1 (IPv6) 
 instead of 127.0.0.1 (IPv4).

That 'localhost' has been a recurring problem in the past is a simple
fact. I've got notes on this list from many years back about trying the
machines IP address rather than localhost when there are windows
connection problems.

   SO the next
 question is ... is this machine actually on a network? If so
 http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does
 may help ...
 
 The original question is about use of embedded. The fact that it is 
 attempting to connect through localhost means that a hostname 
 (localhost) is included in the connection string, which results in 
 fbembed.dll acting as a normal fbclient, instead of using its internal 
 server to access the database.
 
 The real question is if this happens because the application itself 
 specifies the hostname, or because the connection component 
 automatically adds localhost if no hostname is specified.

Adam had switched to Flamerobin and it was this which gave the more
useful error report. Flamerobin certainly defaults to using localhost so
the alternative track IS the alternate ways of accessing 'embedded', and
I thought Flamerobin tested them - but obviously I'm mistaken? I did
think localhost would access a local embedded client? But it has been
some considerable time since I actually used it.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
I think a status update may be helpful.

After deleting all other than the one fbclient.dll in myapp folder

1 - Running my app results in the following error message:

[FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll].
Hint: check it is in the PATH or application EXE directories, and has x86
bitness.

I've checked and it is in both the PATH and app EXE directory.
Not at all sure how to check that it has x86 bitness.

2 - IB_SQL gives this new error :(

ISC ERROR CODE:335544379

ISC ERROR MESSAGE:
unsupported on-disk structure for file D:\my_app\myapp.FDB; found 32779,
support 15

3 - FlameRobin

IBPP::SQLException
Context Database Connect
Message =: isc_attach_database failed

SQL Message: -902
Unsuccessful execution caused by  system error that precludes successful
execution of subsequent statements

Engine Code  :335544721
Engine Message:
Unable to complete network request to host localhost:3050
Failed to establish connection.
No connection could be made because the target machine actively refused it.


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 14/09/14 13:38, Adam adam...@gmail.com [firebird-support] wrote:
 1 - Running my app results in the following error message:
 
 [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll].
 Hint: check it is in the PATH or application EXE directories, and has
 x86 bitness.
 
 I've checked and it is in both the PATH and app EXE directory.
 Not at all sure how to check that it has x86 bitness.

OK the other windows problem creeping in ...
You said originally 'Windows 8' which I would anticipate being 64 bit?
If the test application was compiled as '64bit' then you will also need
a 64bit version of Firebird. Otherwise you need the 32bit build ...
which may account for your earlier results as the deleted versions may
have been the right 'bittyness' and being picked up rather then the
renamed embedded one in your folder :(

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Sun, Sep 14, 2014 at 10:33 PM, Lester Caine les...@lsces.co.uk
[firebird-support] firebird-support@yahoogroups.com wrote:



 On 14/09/14 13:20, Mark Rotteveel m...@lawinegevaar.nl
 [firebird-support] wrote:
  On 14-9-2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support]
  wrote:
  On 14/09/14 12:46, Adam adam...@gmail.com [firebird-support] wrote:
  Engine Code :335544721
  Engine Message:
  Unable to complete network request to host localhost
  Failed to establish connection.
 
  So yes FlameRobin provides more information but still I cannot
  understand why
 
  This means that your machine does not have the network configured
  properly. Quite a common problem with windows these days.
 
  A common problem? I don't actually think so. The question you link to
  below is also not very informative; and that is problem is probably more
  related to the fact that by default localhost resolves to ::1 (IPv6)
  instead of 127.0.0.1 (IPv4).

 That 'localhost' has been a recurring problem in the past is a simple
 fact. I've got notes on this list from many years back about trying the
 machines IP address rather than localhost when there are windows
 connection problems.

   SO the next
  question is ... is this machine actually on a network? If so
 
 http://superuser.com/questions/713491/why-does-localhost-not-work-in-windows-8-1-but-127-0-0-1-does
  may help ...
 
  The original question is about use of embedded. The fact that it is
  attempting to connect through localhost means that a hostname
  (localhost) is included in the connection string, which results in
  fbembed.dll acting as a normal fbclient, instead of using its internal
  server to access the database.
 
  The real question is if this happens because the application itself
  specifies the hostname, or because the connection component
  automatically adds localhost if no hostname is specified.

 Adam had switched to Flamerobin and it was this which gave the more
 useful error report. Flamerobin certainly defaults to using localhost so
 the alternative track IS the alternate ways of accessing 'embedded', and
 I thought Flamerobin tested them - but obviously I'm mistaken? I did
 think localhost would access a local embedded client? But it has been
 some considerable time since I actually used it.

So am I right in my understanding here then that FlameRobin will not work
with the FireBird embeded server and if this is correct then can I run the
embeded server hile the full server is running as a background process?


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Sun, Sep 14, 2014 at 10:56 PM, Lester Caine les...@lsces.co.uk
[firebird-support] firebird-support@yahoogroups.com wrote:



 On 14/09/14 13:38, Adam adam...@gmail.com [firebird-support] wrote:
  1 - Running my app results in the following error message:
 
  [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll].
  Hint: check it is in the PATH or application EXE directories, and has
  x86 bitness.
 
  I've checked and it is in both the PATH and app EXE directory.
  Not at all sure how to check that it has x86 bitness.

 OK the other windows problem creeping in ...
 You said originally 'Windows 8' which I would anticipate being 64 bit?
 If the test application was compiled as '64bit' then you will also need
 a 64bit version of Firebird. Otherwise you need the 32bit build ...
 which may account for your earlier results as the deleted versions may
 have been the right 'bittyness' and being picked up rather then the
 renamed embedded one in your folder :(

 Right on the money Lester ell done. As I just tried the win32 embeded
and it works as expected. Although now I need to getFlame Robin working and
I just posted in my previous reply a question on this.


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Sun, Sep 14, 2014 at 11:00 PM, Adam adam...@gmail.com wrote:



 On Sun, Sep 14, 2014 at 10:56 PM, Lester Caine les...@lsces.co.uk
 [firebird-support] firebird-support@yahoogroups.com wrote:



 On 14/09/14 13:38, Adam adam...@gmail.com [firebird-support] wrote:
  1 - Running my app results in the following error message:
 
  [FireDAC][Phy][IB]-314. Cannot load vendor library [fbclient.dll].
  Hint: check it is in the PATH or application EXE directories, and has
  x86 bitness.
 
  I've checked and it is in both the PATH and app EXE directory.
  Not at all sure how to check that it has x86 bitness.

 OK the other windows problem creeping in ...
 You said originally 'Windows 8' which I would anticipate being 64 bit?
 If the test application was compiled as '64bit' then you will also need
 a 64bit version of Firebird. Otherwise you need the 32bit build ...
 which may account for your earlier results as the deleted versions may
 have been the right 'bittyness' and being picked up rather then the
 renamed embedded one in your folder :(

 Right on the money Lester ell done. As I just tried the win32 embeded
 and it works as expected. Although now I need to getFlame Robin working and
 I just posted in my previous reply a question on this.


Yes but of course not concurrently!!


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 14/09/14 14:00, Adam adam...@gmail.com [firebird-support] wrote:
 Otherwise you need the 32bit build ...
 which may account for your earlier results as the deleted versions may
 have been the right 'bittyness' and being picked up rather then the
 renamed embedded one in your folder :(
 
 Right on the money Lester ell done. As I just tried the win32
 embeded and it works as expected. Although now I need to getFlame Robin
 working and I just posted in my previous reply a question on this.

I'm not sure on that one so I'll leave it to someone else to answer. I
only run with a server setup, and Firebird is normally on a Linux box
these days, but there is no reason that an embedded client could not run
with a database as long as the server is not also accessing the same
database file. It's the access that is restricted to a single user in
the embedded case.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread em...@tot-consult.com [firebird-support]
I saw a hint to the bitness of the client library - is you application 64-bit 
or 32-bit? The client library (embedded or not) should match the application.

Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Sun, Sep 14, 2014 at 11:26 PM, Lester Caine les...@lsces.co.uk
[firebird-support] firebird-support@yahoogroups.com wrote:



 On 14/09/14 14:00, Adam adam...@gmail.com [firebird-support] wrote:
  Otherwise you need the 32bit build ...
  which may account for your earlier results as the deleted versions may
  have been the right 'bittyness' and being picked up rather then the
  renamed embedded one in your folder :(
 
  Right on the money Lester ell done. As I just tried the win32
  embeded and it works as expected. Although now I need to getFlame Robin
  working and I just posted in my previous reply a question on this.

 I'm not sure on that one so I'll leave it to someone else to answer. I
 only run with a server setup, and Firebird is normally on a Linux box
 these days, but there is no reason that an embedded client could not run
 with a database as long as the server is not also accessing the same
 database file. It's the access that is restricted to a single user in
 the embedded case.

Just tested it and all works fine. FlameRobin uses the FireBird running in
background process and yes as long as the database is not being
concurrently accessed all works fine.

Thank you o much for giving your time to my problem, much appreciated.

Yours antipodaly

Adam


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Sun, Sep 14, 2014 at 11:32 PM, em...@tot-consult.com [firebird-support] 
firebird-support@yahoogroups.com wrote:



 I saw a hint to the bitness of the client library - is you application
 64-bit or 32-bit? The client library (embedded or not) should match the
 application.

Yes the non matching of the server and my app was part of my problem

Thanks to all that contributed to solving this nagging issue, mainly due to
my clumsynes in the install of the latest version :(

Cheers until we meet again

Adam


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 14/09/14 14:34, Adam adam...@gmail.com [firebird-support] wrote:
 Just tested it and all works fine. FlameRobin uses the FireBird running
 in background process and yes as long as the database is not being
 concurrently accessed all works fine.
 
 Thank you o much for giving your time to my problem, much appreciated.

We do need to do some more up to date beginners guides for the windows
stuff. My last one was done for 32 bit XP :)

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk


Re: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-14 Thread Adam adam...@gmail.com [firebird-support]
On Mon, Sep 15, 2014 at 12:12 AM, Lester Caine les...@lsces.co.uk
[firebird-support] firebird-support@yahoogroups.com wrote:



 On 14/09/14 14:34, Adam adam...@gmail.com [firebird-support] wrote:
  Just tested it and all works fine. FlameRobin uses the FireBird running
  in background process and yes as long as the database is not being
  concurrently accessed all works fine.
 
  Thank you o much for giving your time to my problem, much appreciated.

 We do need to do some more up to date beginners guides for the windows
 stuff. My last one was done for 32 bit XP :)

Yes a guide for beginner and/or novices would be very useful.

Adam


[firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-13 Thread Adam adam...@gmail.com [firebird-support]
I've only just recently installed the latest version of Firebird and
developed a small test application and associated fdb on a Windows 8
desktop. I've copied the following Firebird files to the same folder as the
exe but cannot connect to an embedded Firebird:


icudt30.dll
icuin30.dll
icuuc30.dll
ib_util.dll
fbclient.dll (renamed)


I've also copied InterBase Objects (V5.2.0.8) IBSQL into the exe folder and
tried connecting to the database via this client but get the same ISC ERROR
CODE:335544375, ISC ERROR MESSAGE: unavailable database error.


Any help would be greatly appreciated.


-- 
Adam


RE: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-13 Thread 'Alan McDonald' a...@meta.com.au [firebird-support]
I've only just recently installed the latest version of Firebird and developed 
a small test application and associated fdb on a Windows 8 desktop. I've copied 
the following Firebird files to the same folder as the exe but cannot connect 
to an embedded Firebird:

 

icudt30.dll

icuin30.dll

icuuc30.dll

ib_util.dll

fbclient.dll (renamed)

 

I've also copied InterBase Objects (V5.2.0.8) IBSQL into the exe folder and 
tried connecting to the database via this client but get the same ISC ERROR 
CODE:335544375, ISC ERROR MESSAGE: unavailable database error.

 

Any help would be greatly appreciated.

 

-- 
Adam 





Did you read the release notes and the section on how to deploy the embedded 
server? You should because you are missing some files

Alan

 



RE: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-13 Thread Adam adam...@gmail.com [firebird-support]
Hi Alan and thanks for your help. I checked the release notes and started
again. This is my directory structure:

D:\my_app\myapp.exe
D:\my_app\myapp.FDB
D:\my_app\fbclient.dll
D:\my_app\firebird.conf
D:\my_app\firebird.msg
D:\my_app\IB_SQL.exe
D:\my_app\ib_util.dll
D:\my_app\icudt30.dll
D:\my_app\icuin30.dll
D:\my_app\icuuc30.dll

D:\my_app\intl\fbintl.dll
D:\my_app\intl\fbintl.conf

D:\my_app\udf\fbudf.dll

And still both myapp.exe and IB_SQL.exe give Database unavailable message
(ISC ERROR CODE:335544375 in the cae of IB_SQL.exe) :(

-- 
Adam


RE: [firebird-support] Help!!! - Problem with Firebird Embeded

2014-09-13 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 01:05 p.m. 14/09/2014, Adam adam...@gmail.com [firebird-support] wrote:


Hi Alan and thanks for your help. I checked the release notes and started 
again. This is my directory structure:

D:\my_app\myapp.exe
D:\my_app\myapp.FDB

D:\my_app\fbclient.dll

What's this file?  It should be fbembed.dll renamed to fbclient.dll.  If it's 
not, then it's the regular client API and you're getting the error because 
there's no server.

Also I'd want to check that your application (either via path name or using an 
alias) is connecting to a database path and not an unqualified file name for 
the DB.  The server is embedded but it's still a server, not a file jockey.


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of The Firebird Book and The Firebird Book Second Edition
http://www.firebird-books.net
__