Let's discuss a very important thing – creating an OLEDB connection under a 64-bit OS with use of the adapter Microsoft Jet 4.0. This adapter is not supported in 64-bit applications. But the issue can be solved in several ways and takes this a couple of minutes. Despite the fact that the database adapter Microsoft Jet is present in Windows 7, it is a bit outdated. Therefore, you should use the new adapter Microsoft.ACE.OLEDB.12.0. This adapter can be downloaded from the official source, completely free of charge.
Once you have downloaded it. Install it. Run the file, accept the license agreement, define the installation location and wait for a while. It takes a couple of minutes. After the installation is finished, it is better to restart the report designer (if opened), and in case the installation wizard offers to restart the system, just follow its request. Next, create an OLEDB connection to the data source.
It should be noted that this adapter is designed exclusively for 64-bit applications; it will not work with 32-bit versions of Microsoft Office. Therefore, Microsoft.ACE.OLEDB.12.0 should be used only with 64-bit versions of the Office.
Here is a video that shows how to install the adapter Microsoft.ACE.OLEDB.12.0 and create the OLEDB connection to the data source.
Also, this problem can be solved without the adapter Microsoft.ACE.OLEDB.12.0. You can change the properties of your project. Go to the properties of the project by selecting the appropriate item from the context menu, or by Project -> Properties..., in the tab Build change the Platform target, selecting the value x86. After this, run the project, call the designer and create the OLEDB connection to the data source. This method can be watched the video below.
Once you have downloaded it. Install it. Run the file, accept the license agreement, define the installation location and wait for a while. It takes a couple of minutes. After the installation is finished, it is better to restart the report designer (if opened), and in case the installation wizard offers to restart the system, just follow its request. Next, create an OLEDB connection to the data source.
It should be noted that this adapter is designed exclusively for 64-bit applications; it will not work with 32-bit versions of Microsoft Office. Therefore, Microsoft.ACE.OLEDB.12.0 should be used only with 64-bit versions of the Office.
Here is a video that shows how to install the adapter Microsoft.ACE.OLEDB.12.0 and create the OLEDB connection to the data source.
Also, this problem can be solved without the adapter Microsoft.ACE.OLEDB.12.0. You can change the properties of your project. Go to the properties of the project by selecting the appropriate item from the context menu, or by Project -> Properties..., in the tab Build change the Platform target, selecting the value x86. After this, run the project, call the designer and create the OLEDB connection to the data source. This method can be watched the video below.