SmartAssembly 6

System.InvalidOperationException when attempting to connect to local SmartAssembly database on a 64-bit system

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.


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.

Didn't find what you were looking for?