Re: [firebird-support] Help!!! - Problem with Firebird Embeded
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 __