SSDT Visual Studio 2017 Installation registry error

This short blog suggests a solution if your SSDT installation keep failing. I was reinstalling the SSDT because the Script Component is not able to open the code.

If you look inside the SSDT setup log then you see something like this:

[2B70:0A94][2018-06-23T02:56:24]e000: MainViewModel.OnBundleAction: Bundle action failed: The configuration registry key could not be opened (0x800703F3)

Someone suggested to me to try https://stackoverflow.com/questions/50241405/ssdt-2017-setup-failed-the-configuration-registry-key-could-not-be-opened.

It might work.

Somehow, I reinstall the SSDT using Microsoft SQL Server Data Tools for Visual Studio 2017.


After the installation you will see Visual Studio 2017 (SSDT).

One instance “C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\ devenv.exe””. For SSDT

The original is “C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\devenv.exe”

Advertisements
Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , , | Leave a comment

Angular js No ‘Access-Control-Allow-Origin’ header is present on the requested resource

The short post is solving the error “No ‘Access-Control-Allow-Origin’ header is present on the requested resource”.

I have an html, and angular js code in one web application. On the other hand I have a Web Api C# project. Once I call the Web Api form Angular js as below.

$scope.GetAllData = function () {

      $http({

                method: “get”,

               url: “http://localhost:54412/api/Values”

       }).then(function (response) {

       $scope.employees = response.data;

}, function () {

alert(“Error Occur”);

})

When I run the application I got the error “Failed to load http://localhost:54412/api/Values: No ‘Access-Control-Allow-Origin’ header is present on the requested resource. Origin ‘http://localhost:53914’ is therefore not allowed access.”

What you need to do is fine the Chrome browser icon then change the startup command to “C:\Program Files (x86)\Google\Chrome\Application\chrome.exe” –disable-web-security –user-data-dir=”c:/someFolderName” like the link below.

https://www.thegeekstuff.com/2016/09/disable-same-origin-policy/

I am using IIS Express, perhaps there might be another way to correct this in an IIS Server.

Posted in .Net, Cloud, Community, Computers and Internet | Tagged , , | Leave a comment

Migrate from Personal OneDrive to Google Drive

This post shows you how to move from Personal One/Drive to Google Drive.

After more than 15 hours I cannot access to OneDrive using my browser, I don’t feel right. I better think of a way to duplicate the OneDrive files to Google Drive. Anyway both of them I don’t feel there is a SLA for free drive.


Click on Windows Start button, type OneDrive and select OneDrive.

 

Login to your personal OneDrive.


OneDrive will create a local repository on your local drive, this is what I never like to do because it is taking out my local hard disk space.

Login to your Google Drive using Chrome. Drag the folder from Windows File Explorer directly to Google Chrome browser.

Posted in Cloud, Community, Computers and Internet | Tagged , | Leave a comment

SharePoint development with Visual Studio overview and sample

This post tells you how to get SharePoint development working with Visual Studio with running sample.

In order to do SharePoint development, you must get the SharePoint Setup correct and Visual Studio installation correct.

The 2 key hosted environment you need to understand when setting up the development environment. It used to have 3 but when come to SharePoint 2016 it has only left with SharePoint-hosted and Provider-Hosted.

You do not need to do setup if you are using SharePoint Online, or some people call Office 365 SharePoint, or some even call it SharePoint 365. Microsoft cannot even give a firm name for this SharePoint that is in the cloud.

If you are using SharePoint 2016 then you can follow the link below to setup the Provider-Hosted for SharePoint 2013 or 2016.

https://chanmingman.wordpress.com/2015/07/11/create-high-trust-apps-for-sharepoint-2013/

You can follow the link below to setup the Provider-Hosted.

https://chanmingman.wordpress.com/2018/06/09/sharepoint-add-ins-prompt-for-login/

Once the SharePoint is installed then you need to have a copy of Visual Studio 2017 with SharePoint workload selected. You need Visual Studio 2017 and not Visual Studio Code. Visual Studio Code might do the job for you but I am not sure how this can be done.

https://www.visualstudio.com/vs/support/selecting-workloads-visual-studio-2017/


After you have done setup with SharePoint and Visual Studio. I found the samples below pretty handy.

JSOM SharePoint Hosted

http://www.dotnetcurry.com/sharepoint/1028/sharepoint-apps-javascript-object-model-jsom

CSOM SharePoint Hosted

https://github.com/OfficeDev/SharePoint-Add-in-CSOM-BasicDataOperations/blob/master/README.md

SharePoint Client CRUD using Console App

https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/ee539976(v%3Doffice.14)

The above link has no source code. I have built the source code in the belong link.

https://github.com/chanmmn/SharePointCSOMListCRUD

Posted in .Net, Cloud, Community, Computers and Internet, sharepoint | Tagged , , , , | Leave a comment

sql update case when select

This post shows you how to update the column in Sql Table based on the length of the data.

Let’s say you have data below.


You want to standardize them to 6 character by appending zero to them such as 000029 for 20 and 002999 for 2999. One of the ways is to using the SQL statement below.

The table name is Employee and the column is EmpId.

UPDATE Employee

SET EmpId = CASE

WHEN (LEN(EmpId) > 1 AND LEN(EmpId) <= 2) THEN ‘0000’ + EmpId

WHEN (LEN(EmpId) > 2 AND LEN(EmpId) <= 3) THEN ‘000’ + EmpId

WHEN (LEN(EmpId) > 3 AND LEN(EmpId) <= 4) THEN ’00’ + EmpId

END

Posted in .Net, Cloud, Community | Tagged | 1 Comment

Bing vs Google

The short post to show you Bing vs Good that you can try.

I saw an article yesterday “Vincent Tan offers to build Tioman Airport” the link is https://www.msn.com/en-my/news/national/vincent-tan-offers-to-build-tioman-airport-says-won%E2%80%99t-burden-putrajaya/ar-AAykBdb.

So today I lost the link then I open Bing and type “vincent tan langkawi airport”. You can see the result below. Giving me all the commercial crabs.


When I typed the same in Google. I got it at the 4th link. This is something you can try.

Posted in Cloud, Community, Computers and Internet | Tagged | Leave a comment