Delphi7 Firebird embedded

mcb · Post by **mcb** » 09.02.2006, 16:55

Hi,

when I try to open a database in designtime, I get the message:

SQL-Error : unavailable database. Error Code -904. Unsuccessful exeution caused by an unavailable resource.

When I run the program everything works fine.

I use Delphi 7, fbird embed 1.5.3, zeos 6.5.1 alpha CVS as of 13/10/2005.

Has someone a hint what I am doing wrong?

Thanks McB

Domo Sokrat · Post by **Domo Sokrat** » 09.02.2006, 19:14

Hi mcb,

the only existing problem I know is if you are connected to an FB embedded server at design time (ZConnection.active = true) and then start the program from IDE because the database is already in use from IDE.

Using an embedded FB Server you can only connect once to a database! A second connect will cause an exception.

Hope this brings a little light into the dark

btw: Did you read the "FB-Embedded" article in the Knowledge Base? There is a section called "Features of the Firebird embedded server" ...

Regards!

mcb · Post by **mcb** » 09.02.2006, 19:57

Hi,

sorry, but your post and the article were no help, but thanks for your answer ;)

McB

mcb · Post by **mcb** » 10.02.2006, 12:41

Hi,

after tons of coffe, a little bit of sleep and two or three beers I have the answer:

I tried out lazarus a while ago and some of the components needed access to the gds32.dll even when launching the ide. So I put this file into the system32 directory. When I now tried to open the database in the Delphi IDE, that file was used to open the database, and there was my error message.

Greetings,
McB

lcnorm · Post by **lcnorm** » 08.08.2006, 19:06

Hi,

I have the same problem here, it only works in design time if the fbclient.dll
embedded is in the System32 dirctory.
But when it´s in the project directory (as usual) it works fine in runtime.

Regards,
Luciano

leonrom · Post by **leonrom** » 05.04.2007, 05:25

I found another problem,- it did not recognized codepage win1251 when use Firebird-2 and ZEOSDBO 6.6 for access to embedded database.

I could not to connect to embedded firebird from both ZEOSDBO 6.6/6/5

But thanks for your job,- ZEOS is a great project and I'll be looking for new stable version!

Post by **mdaems** » 05.04.2007, 13:31

Hi leonrom,

What do you mean by 'it did not recognize codepage win1251'?
I suppose you added 'isc_dpb_lc_ctype=WIN1251' to the connection parameters? What 's the error you get? How do you see it doesn't work right?
Did you get the embedded server running with the default character set?

Mark