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 until this 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 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 ?
or
What shud be the right value for Sweeping the Database.(mine is 50000)


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