Database Errors - Fixed!

[sparkman]

Hi Bob,

Just working on my upgrade from HS2 to HS3. The import tool helped a lot in getting it set up. Thanks for making it available. When running the plugin on HS3, I get regular database related errors like the ones below. Any idea what's going on? The database file is there and I can open it with MS Access.

Thanks
Al

Apr-27 10:06:28 AM	  	 BLRadar Error	 DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblSensorActivity (txtDateTime,txtSensorDeviceCode,txtSensorDeviceName,txtAction) VALUES('4/27/2014 10:06:26 AM','D5','Office Office Motion Sensor','ECHO')
Apr-27 10:06:28 AM	  	 BLRadar Error	 DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files\HomeSeer HS3\Data\BLRadar\BLRadar.mdb
Apr-27 10:06:28 AM	  	 BLRadar Error	 DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

Edit:

Here are the errors during startup:

4/27/2014 10:21:52 AM ~!~BLRadar Error~!~DatabaseFunctionsSingleton.GetADODBConnection(): Caught exception opening database connection: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
4/27/2014 10:21:52 AM ~!~BLRadar Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement:  ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
4/27/2014 10:21:52 AM ~!~BLRadar Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName:  C:\Program Files\HomeSeer HS3\Data\BLRadar\BLRadar.mdb
4/27/2014 10:21:52 AM ~!~BLRadar Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString:  DELETE from tblSensorActivity WHERE txtDateTime < #3/28/2014 10:21:45#
4/27/2014 10:21:52 AM ~!~BLRadar Error~!~DatabaseFunctionsSingleton.CompactDatabase(): An error has occurred during compacting of the database:  Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
4/27/2014 10:21:52 AM ~!~BLRadar Error~!~DatabaseFunctionsSingleton.CompactDatabase(): DatabasePathAndName:  C:\Program Files\HomeSeer HS3\Data\BLRadar\BLRadar.mdb

PS This is on the same system as my HS2 install and BLRadar on it has no database errors.

[Blade]

Try this:

http://forums.homeseer.com/showthread.php?t=160399

[sparkman]

Thanks Bob, that did the trick.

Cheers
Al