Database

question by siun | Moderate

I am using Delphi 2005 and I have a database connection established with a Firebird database 'SIS.fdb' as

m_connection := TSQLConnection.Create(Nil);
m_connection.DriverName := 'INTERBASE';
m_connection.GetDriverFunc := 'getSQLDriverINTERBASE';
m_connection.LibraryName := 'dbexpint.dll';
m_connection.VendorLib := 'fbclient.dll';
m_connection.Params.Clear;
m_connection.Params.Add('Database= SIS.fdb');
m_connection.Params.Add('User_Name= sysdba');
m_connection.Params.Add('Password= masterkey');
m_connection.Params.Add('SQLDialect=3');
m_connection.Params.Add('BlobSize=-1');
m_connection.Params.Add('CommitRetain=False');
m_connection.Params.Add('WaitOnLocks=True');

At times ( not always) when I do several commits or do some other things lke getting data from a table I get the errors

dbExpress Error: [0x0015]: Connection failed Database Server Error: I/O error for file "SIS.fdb" Error while trying to open file as another process is already using the file OR

THe system cannot find the specified file 'SIS.fdb'



Can anyone pls help me out