The issue being discussed in this article is:
When attempting to open or do something in SI, you get the following error:
Cannot open 'C:\Users\username\AppData\Roaming\D-Tools\SIX\Data\SystemIntegratorCache_64.sdf'. Provider 'System.Data.SqlServerCe.3.5' not installed.
Error: InvalidOperationException (DTools.SI.ClientServices.LocalCacheManager.GetSession) (DTools.SI.Projects.DrawingAddInHelper.SetSessionAndCheckPermissions) (DTools.SI.VisioAddIn.EventSink.VisEventProc) V6.0.477.0
Source: System.Data.Linq
StackTrace:
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Initialize(IDataServices dataServices, Object connection)
at System.Data.Linq.DataContext.Init(Object connection, MappingSource mapping)
at DTools.SI.ClientServices.LocalCacheManager.GetSession()
at DTools.SI.Projects.DrawingAddInHelper.SetSessionAndCheckPermissions(Boolean isVisio)
at DTools.SI.VisioAddIn.EventSink.VisEventProc(Int16 nEventCode, Object pSourceObj, Int32 nEventID, Int32 nEventSeqNum, Object pSubjectObj, Object vMoreInfo)
Message=Cannot open 'C:\Users\username\AppData\Roaming\D-Tools\SIX\Data\SystemIntegratorCache.sdf'. Provider 'System.Data.SqlServerCe.3.5' not installed.
Data=System.Collections.ListDictionaryInternal
The following is the resolution:
1/ In Windows, from the Control Panel, open Programs and Features.
2/ Check if Microsoft SQL Server Compact 3.5 SP2 is installed (on 64-bit machines and verify that Microsoft SQL Server Compact 3.5 SP2 x64 is installed.
Both should be installed on a 64-bit machine.
3/ If they are installed, uninstall them.
4/ If one or both (on a 64-bit machine) are not installed, you can install them via the links below:
On a 64-bit machine, you must have both the 32-bit and 64-bit versions of SQL Server Compact 3.5 SP2 installed.
If you cannot resolve this issue, please open a Support Ticket.