System.InvalidOperationException when attempting to connect to local SmartAssembly database on a 64-bit system
Published 03 January 2013
When running SmartAssembly using the (default) local database on a 64-bit edition of Windows, the following error will occur:
At preparing to connect to database - SystemInvalidOperationException: The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine.
Cause
Microsoft has discontinued the Jet database driver needed to connect to the local database, so there is no 64-bit Jet provider.
How to fix
If you are affected by this problem, you can either:
- switch to a Microsoft SQL Server database (see Configuring reporting on multiple computers)
- install SmartAssembly into the %ProgramFilesx86% directory (normally c:\program files (x86)\).
This will cause SmartAssembly to run in the Windows-On-Windows emulator as a 32-bit application.
If you continue to experience problems, please contact Redgate support.
