DB Problems....

[Bestgear]

Guys

Other than a reinstall... which I assume is a db delete and plugin reinstall, any ideas on the error below?

If I do the above install - wil lI have to reset ALL my blradar setup again?


Here is the log at starup...


Thanks in advance

David



02/05/2011 03:05:36 ~!~BLRadar start~!~Register Callback completed
02/05/2011 03:05:36 ~!~BLRadar start~!~BLRadar version is: 1.0.83.0
02/05/2011 03:05:36 ~!~Plug-In~!~Initializing Plug-in: BLRadar
02/05/2011 03:05:36 ~!~BLRadar start~!~Initializing BLRadar...
02/05/2011 03:05:36 ~!~BLRadar start~!~Loaded configuration successfully
02/05/2011 03:05:39 ~!~BLRadar start~!~Sensors and Active Zones have been loaded.
02/05/2011 03:05:40 ~!~BLRadar start~!~User Defined Motion Code has been loaded
02/05/2011 03:05:40 ~!~BLRadar Error~!~DatabaseFunctionsSingleton.GetADODBConnection(): Caught exception opening database connection: Unrecognized database format 'D:\Program Files\Homeseer 2\Data\BLRadar\BLRadar.mdb'.
02/05/2011 03:05:40 ~!~BLRadar Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: Operation is not allowed when the object is closed.
02/05/2011 03:05:40 ~!~BLRadar Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: D:\Program Files\Homeseer 2\Data\BLRadar\BLRadar.mdb
02/05/2011 03:05:40 ~!~BLRadar Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: DELETE from tblSensorActivity WHERE txtDateTime < #4/22/2011 3:5:40#
02/05/2011 03:05:41 ~!~BLRadar Error~!~DatabaseFunctionsSingleton.CompactDatabase(): An error has occurred during compacting of the database: Unrecognized database format 'D:\Program Files\Homeseer 2\Data\BLRadar\BLRadar.mdb'.
02/05/2011 03:05:41 ~!~BLRadar Error~!~DatabaseFunctionsSingleton.CompactDatabase(): DatabasePathAndName: D:\Program Files\Homeseer 2\Data\BLRadar\BLRadar.mdb
02/05/2011 03:05:42 ~!~Media Player~!~Finished loading Playlists
02/05/2011 03:05:42 ~!~BLRadar start~!~BLRadar plugin has been initialized

[Blade]

If you delete the BLRadar.mdb which is in the Data\BLRadar folder and then do a re-install you will not lose any of the sensors.
It will re-generate the database with the re-install. Make sure you delete it first and then do the re-install.

[heatvent]

I have copied over the database mdb file from a pre issue backup which also fixes the problem.

[Bestgear]

Thanks for the replies guys.

What is in the DB.... is it history?

I guess what I am asking is what do I loose by reverting to an old DB?

Lastly, do we know what is the likley cause of the above error?


David

[Blade]

Not sure of the cause. It is an Access database so it is not surprising that it became corrupt. It is after all a Microsoft product.

It is just history stored there