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:
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.