Page 1 of 1

Zeos 6.6.0 beta on Turbo Delphi 2006 + Firebird Embedded

Posted: 13.12.2007, 01:11
by albert.pratama
Hi all,

I have difficulty in connecting Zeos (on Turbo Delphi 2006) to Firebird 2.0.2 Embedded. I filled the ZConnection properties as follows:
- Database: path-todb\besi.fdb
- Hostname: (blank)
- Password: masterkey
- Protocol: firebird-2.0
- User: sysdba

If at design time I try to connect it, the following error shows:

---------------------------
Error
---------------------------
SQL Error: unavailable database. Error Code: -904. Unsuccessful execution caused by an unavailable resource.
---------------------------
OK Details >>
---------------------------

Another error shows if I try to connect at run-time, I don't know what error was this, it was something like CPU dump, and there's a message at the bottom of IDE:
---------------
Debug Output: Invalid Address specified to RtlFreeHeap( 00AB0000, 01C4085C ) Process TokoBesi.exe (4052)
---------------
This error screenshot is attached.

If Hostname property filled with 'localhost', then everything is ok. I guess it is because the ZConnection connects to Firebird full version (not embedded) which is also installed in the same PC.

In the project root directory, I also have placed the firebird embedded files (icu*.dll, fbclient.dll, ib_util.dll, etc).

Does anybody have suggestion for me?
Thanks in advance.

Albert

Posted: 13.12.2007, 11:03
by albert.pratama
Hi again,

After some tests, I found that the problem didn't lay on how I connect the database. But, the problem was happened when I try to activate a table or view.

The code was something like this:

Code: Select all

    connBesi.Database := ExtractFileDir(ParamStr(0)) + '\besi.fdb';
    connBesi.Connect;

    vwBarang.Active := true;
The problem was happened when line

Code: Select all

    vwBarang.Active := true;
executes.

Does anybody have a suggestion for me? Thanks in advance.

Albert