Troubleshooting
Problem
The IBM i Access .NET provider may be missing from the list of providers in Visual Sudio 2017.
Symptom
Starting with Visual Studio 2017, Microsoft has a new requirements for registering a .NET provider in Visual Studio. The current Access Client Solutions [ACS] Windows Application Package do not complete all the requirements during the install.
As a result the IBM i .NET provider will not be listed as an available provider in Visual Studio.
Resolving The Problem
Download the attached VSData_DataSources_iAccess_Reg_VS.pkgdef and VSData_Providers_iAccess_Reg_VS.pkgdef files.
Copy them into the Visual Studio Extensions directory. For my system, the directory was
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\Extensions
Start a command prompt.
CD to the Visual Studio directory. On my system it was C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE
CD C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE
Run Visual Studio with the /updateconfiguation option.
devenv /updateconfiguration
When you next start Visual Studio, the ACS provider should be visible when adding data sources.
VSData_DataSources_iAccess_Reg_VS.pkgdef
VSData_Providers_iAccess_Reg_VS.pkgdef
Copy them into the Visual Studio Extensions directory. For my system, the directory was
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\Extensions
Start a command prompt.
CD to the Visual Studio directory. On my system it was C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE
CD C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE
Run Visual Studio with the /updateconfiguation option.
devenv /updateconfiguration
When you next start Visual Studio, the ACS provider should be visible when adding data sources.
VSData_DataSources_iAccess_Reg_VS.pkgdefVSData_Providers_iAccess_Reg_VS.pkgdef
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Component":"Access for Windows","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Was this topic helpful?
Document Information
Modified date:
02 May 2025
UID
nas8N1022304