VS Code # Warning - npm WARN config global `--global`, `--local` are deprecated. Use `--location=global` instead

Error : VS Code - NPM Warning - npm WARN config global `--global`, `--local` are deprecated. Use `--location=global` instead

Solution: 

Follow below steps :-

1. Open a text editor like Notepad++ in Administrator mode

2. Modify the below 4 files 

1. Go to C:\Program Files\nodejs
2. Edit 4 files - npm, npm.cmd, npx, npx.cmd
3. Replace "prefix -g" with "prefix --location=global" in all 4 files 
4. Save all files

Hope this helps !

VSCode # The term 'node' is not recognized as the name of a cmdlet, function, script file, or operable program

Error : VSCode The term 'node' is not recognized as the name of a cmdlet, function, script file, or operable program

Solution:

If you have installed node while VS Code was opened, Try closing the Editor and then reopen the editor again. 

Why this is required? 

- If node is installed while VS Code was opened then the change to the PATH won't be visible yet. 

- Make sure that "add to PATH option" is selected while installing node.

- If not done, make sure to add it to the PATH environment variable

Hope this helps !

Visual Studio 2019 # Project references are shown as missing; despite them being in the project file

Visual Studio 2019 # Project references are shown as missing; despite them being in the project file

Solution :

Follow the steps as mentioned below - this should resolve the issue

Step 1 : Close the solution in Visual Studio

Step 2 :  Go to the solution folder --> Delete the hidden folder .vs 

Step 3 : Delete "bin" and "obj" folders under the project folders in the solution

Step 4 : Re-Open Solution in Visual Studio

Step 5 : Clean and Rebuild the Solution

Windows10 # VS2017 # Unable to launch the IIS Express Web server

Problem Statement : Windows 10 # VS 2017 # Unable to launch the IIS Express Web server

Solution:

Run the following command from an administrator command prompt: 

netsh http add iplisten ipaddress=::

Example: 

C:\Users\Admin>netsh http add iplisten ipaddress=::

IP address successfully added

This worked for me for Windows 10, VS 2017

Google Maps API Activation error - Getting "ApiNotActivatedMapError" when trying to use embed map API

Problem Statement : I am embedding Google map in a web page but I am getting  ApiNotActivatedMapError error for some reason. 

Solution:

Go to console.cloud.google.com and follow the following steps:

1) APIs & Services

2) Dashboard

3) + Enable APIS and Services

4) Maps JavaScript API

5) hit Enable button

How to get an offline version of Visual Studio 2019 ?

How to get an offline version of Visual Studio 2019? Or simply, is it possible to have an offline version of Visual Studio 2019?

Answer: Yes, It's possible; and the solution is provided by Microsoft itself in this Link.

Why do i need an Offline Installer?

Answer - With an Offline Installer, i can install visual Studio; just by clicking the Setup.EXE executable file.  

How can I get this offline installer?

Answer: Here, we will highlight Visual Studio Enterprise 2019 for Windows 10; however the same process should work for Windows 8.1 and Windows 7.

This is a 2-Step process

Step 1. Download the Visual Studio bootstrapper file   

Download the Visual Studio bootstrapper file for your chosen edition of Visual Studio. 

Edition	Bootstrapper File Link
Visual Studio Community	vs_community.exe
Visual Studio Professional	vs_professional.exe
Visual Studio Enterprise	vs_enterprise.exe

Step 2. Create a local install cache

Ø  Open Command Prompt in Administrator mode

Ø  To create a complete local layout with all features, run:

§  vs_enterprise__2132243952.1587278346.exe --layout c:\vslayout --lang en-US

Ø  For .NET web and .NET desktop development, run:

§  vs_enterprise__2132243952.1587278346.exe --layout c:\vslayout --add Microsoft.VisualStudio.Workload.ManagedDesktop --add Microsoft.VisualStudio.Workload.NetWeb --add Component.GitHub.VisualStudio --includeOptional --lang en-US

Ø  For .NET desktop and Office development, run:

§  vs_enterprise__2132243952.1587278346.exe --layout c:\vslayout --add Microsoft.VisualStudio.Workload.ManagedDesktop --add Microsoft.VisualStudio.Workload.Office --includeOptional --lang en-US

Ø  For C++ desktop development, run:

§  vs_enterprise__2132243952.1587278346.exe --layout c:\vslayout --add Microsoft.VisualStudio.Workload.NativeDesktop --includeRecommended --lang en-US

ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine" - RESOLUTION

Scenario:

ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"

RESOLUTION :

There are lot of scenarios for which we might get "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" error when attempting to connect to either an accdb or an xlsx file. 

I have spent a couple of hours searching Google for a resolution of this issue but somehow I was not getting the correct solution. Ultimately, the below solution worked best for me 100%.

Step 1. download and install this: http://www.microsoft.com/download/en/confirmation.aspx?id=23734/ 

Step 2. in VS, add references (say Microsoft.Office.Interop.Excel)  and write necessary business logic. 

Hope this helps.. Cheers... :)