Clever Geek Handbook

Installing VB 6 Data Access Component on Windows 2012 Server

I am trying to install Visual Basic 6.0 on a Windows 2012 server, do not install it, and if I uninstall the Data Access Components they install successfully. But I have not installed the data access component. The excel link is missing.

+3


source to share


1 answer


This is also my problem.

I solved this by unchecking the Install Data Access Components in Visual Studio 6 checkbox and instead installing AccessDatabaseEngine.exe

which is the 32-bit version of Microsoft Access Database Engine 2010 Redistributable

Download link here: Microsoft Access Database Engine 2010 Redistributable

From MS documentation:



Office system drivers are only supported in certain scenarios, including:

  • Desktop applications that read and write to a variety of file formats, including Microsoft Office Access, Microsoft Office Excel, and text files.
  • Transferring data between supported file formats and a database repository such as SQL Server.

Important note: unfortunately, in my existing applications, I had to change the MDAC references and connection strings as described below (this is not a problem for new applications):

If you are an application developer using OLEDB, set the Provider's ConnectionString property argument to "Microsoft.ACE.OLEDB.12.0"

0


source






More articles:


All Articles