I am using Firebird 2.0 RC1 on a Windows XP Prof. system and using it as my
server for a POS Application, everything was working fine for abt 2 months
until last week when the Clients have started to freeze after every 1-2
hours...but its random. When I debug the same its freezing when adding
Records to the Database Tables OR when opening a recordset connection to one
of the tables in the Database.



It could be bcoz the server is sweeping the database at the same time.



Could it be bcoz of the Firebird ODBC Driver ?

And

What shud be the right value for Sweeping the Database.(mine is 50000)





Which other ODBC/OLEDB Driver i can use with VB6.



Thanx in advance.







Amarjit Singh



[Non-text portions of this message have been removed]