TZConnection and TIBDatabase they do not want to work together
Posted on 2007-12-04
Hello Experts :-)
I use TZConnection and TIBDatabase on my TDataModule.
TZConnection is responsible for connection for all my Zeos components.
TIBDatabase is used only for one TIBEvents.
This is what I actually do:
DMabc.ZConnectionMH.Database := PathToFile;
DMabc.IBDatabase1.DatabaseName := PathToFile;
DMabc.ZConnectionMH.Connected := True;
DMabc.IBDatabase1.Connected := True;
It used to work fine before I had to re- install Delphi and WinXP.
Now I get such an error:
SQL Error: I/O error for file: "my database file" Error while trying to open file The process cannot access the file because it is being used by another process.
These are my components' properties:
object ZConnectionMH: TZConnection
Protocol = 'firebird-1.5'
Database = 'path to gdb file'
User = 'sysdba'
Password = 'masterkey'
ReadOnly = True
TransactIsolationLevel = tiReadCommitted
Left = 36
Top = 8
object IBDatabase1: TIBDatabase
DatabaseName = 'path to gdb file'
Params.Strings = (
LoginPrompt = False
IdleTimer = 0
SQLDialect = 3
TraceFlags = 
Left = 33
Top = 72
What do I do wrong?
Why it used to work and now doesnt?
Thank you very much :-)