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... :)

Check-box 'Prefer 32-bit' disabled in Visual Studio 2012. Why?

Question: 

Check-box 'Prefer 32-bit' disabled in Visual Studio 2012. Why?

Answer: 

In Visual Studio, Switch the project to .NET 4.5 (on the Build tab of the project properties). This would re-enable the check-box "Prefer 32 bit" for AnyCPU.

Import Microsoft Access .accdb File to MS SQL Server

Steps to Import Microsoft Access .accdb File to MS SQL Server

1. Open MS SQL Server Import and Export Wizard.
2. For “Data Source” choose “Microsoft Office 12.0 Access Database Engine OLE DB Provider”.
3. Click “Properties” enter the location of the .accdb file in the “Data Source” field.
4. Under login information, choose a blank username and be sure to check “Blank Password”.
5. Test the connection. If it works, click OK.
6. For the “Data Destination” choose “Microsoft OLE DB Provider for SQL Server”.
7. Enter the MS SQL server name or choose from the dropdown menu.
8. Enter your SQL credentials and select the database you wish to import the data to, the database should show up in the dropdown menu if your MS SQL info is correct.
9. Select “Copy data from one or more tables or views”.
10. Select the tables you want copied and edit the mappings if needed.
11. Continue through the wizard and hit finish to begin the import.

Ref : http://serversideguy.com/2014/02/05/import-microsoft-access-accdb-file-to-ms-sql-server/