The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine

This short blog show you how to resolve the error “The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.” when you are using SQL Server Management Studio 2016 to import an Excel file.

What you need to do is to download this Office 2007 Microsoft Access Engine. Well, why 2007 work for OLEDB 16 and no newer version, that should be a question to Microsoft.

Download link:

http://www.microsoft.com/download/en/confirmation.aspx?id=23734

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

Debugger.Break() Crashes Visual Studio

This short blog shows you one of the possibilities to resolve the crash when using Debugger.Break() in your code in SQL Server Data Tool.

When you use Debugger.Break() in SSIS package you might crash your SSIS package with the error below.

————————————————————————————————–

Problem signature:

 Problem Event Name:    CLR20r3

 Problem Signature 01:    DtsDebugHost.exe

 Problem Signature 02:    2015.130.1601.5

 Problem Signature 03:    57244eb5

 Problem Signature 04:    SC_b49499f4784c46bdb61997ce00d25fbb

 Problem Signature 05:    1.0.0.0

 Problem Signature 06:    58aab772

 Problem Signature 07:    3

 Problem Signature 08:    53

 Problem Signature 09:    Debugger.Break

 OS Version:    6.3.9600.2.0.0.400.80

 Locale ID:    1033

 Additional Information 1:    edae

 Additional Information 2:    edae703551258c63f25f3a06c17bbfcf

 Additional Information 3:    6f1d

 Additional Information 4:    6f1d3188eaf2dae00c303d0a60a3bd0d

 

Read our privacy statement online:

 http://go.microsoft.com/fwlink/?linkid=280262

 

———————————————————————–

Go the Project in Visual Studio and choose Properties. 

Set the TargetServerVersion to the SQL Server version that you are running.

If you are not in SSIS environment then try to change the .NET Framework version.

clip_image002

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

Windows cannot be installed on this disk. The selected disk is of the GPT partition style

This short blogs should you how to resolve this issue when you are installing Windows 7, Windows 8, or Windows 10.

When you are installing Windows you may hit the error “Windows cannot be installed on this disk. The selected disk is of the GPT partition style”.

A lot of articles ask you to type diskpart but where do you going to get the command prompt?

You get the command prompt by pressing Shift + F10 after you booked your PC or laptop using CD/DVD or USB drive.

Once you type diskpart then there is another prompt appear

Type list

DISKPART> list

Type select disk 0

DISKPART> select disk 0

Type clean

DISKPART> clean

You can try to install your Windows again. The error should be gone by now.

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

Getting started with Universal Windows Platform

This article shows you how to get started with Universal Windows Platform.

A term seems complicated but it is a much easier well than developing an Android phone app.

When you setup Visual Studio 2015 you choose Custom instead of Default.

After that you choose Cross Platform Mobile Development.

One your installation is done. Run Visual Studio with Administrator privilege (Run As Administrator).

Choose File -> New Project in Visual Studio.

In the New Project  dialog box choose Blank App (Universal Windows 8.1).

clip_image002

One the project is created then you will see there are 2 projects. You can select either one project to run as default. The default will be the Windows App instead of Mobile App. 

clip_image003

To test it, you open the MainPage.xaml by double clicking it.

To drag a TextBox and Button to the design surface then you will see your xaml code changes as below.

<Grid Background=”{ThemeResource ApplicationPageBackgroundThemeBrush}”>

    <TextBox x:Name=”textBox” HorizontalAlignment=”Left” Margin=”71,48,0,0″ TextWrapping=”Wrap” Text=”TextBox” VerticalAlignment=”Top” Height=”66″ Width=”370″/>

    <Button x:Name=”button” Content=”OK” HorizontalAlignment=”Left” Margin=”68,167,0,0″ VerticalAlignment=”Top” Height=”78″ Width=”148″ Click=”button_Click”/>

</Grid>

Double click the Button to add the following code.

private void button_Click(object sender, RoutedEventArgs e)

{

    textBox.Text = “Can run”;

}

Run the application by clicking the Run (Local Machine) button in Visual Studio.

clip_image005

You can do exactly the same to the MainPage.xaml in the Mobile App.

<Grid>

    <TextBox x:Name=”textBox” HorizontalAlignment=”Left” Margin=”47,29,0,0″ TextWrapping=”Wrap” Text=”TextBox” VerticalAlignment=”Top” Width=”208″/>

    <Button x:Name=”button” Content=”OK” HorizontalAlignment=”Left” Margin=”47,117,0,0″ VerticalAlignment=”Top” Click=”button_Click”/>

</Grid>

Also you can double click the Button to add exactly the same code as in the Windows App.

private void button_Click(object sender, RoutedEventArgs e)

{

    textBox.Text = “Can run”;

}

clip_image007

The only trick is when you want to run it then you might need to download the Emulator in you do not have a Windows Phone.

clip_image009

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

Cannot download files from Onedrive.com in IE 11 running in 32 bit Windows 7

This short blog shows you how to fix the cannot download files from Onedrive.com in IE 11 running in 32 bit Windows 7 problem.

Up to today there are still many organization use 32 bit Windows 7, unfortunately.

If you are using 32 bit Win 7 as well then you will probably face the problem when you click the Download at the Onedrive.com like the one below but no response.

image

Go to the “Gear” and choose Compatibility View Settings.

image

Type live.com in Add this website: TextBox.

Click Add.

image

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

How to learn R programming language

This short blog shows you one of the ways to learn R programming or R Script.

R has been getting popular over the past 5 to 6 years even though it is found back in 90s’.

The best site that I found to learn R is the link below.

http://tryr.codeschool.com/levels/1

To test out the code without using the website, you can download Microsoft R Studio, it is free but not sure for how long,

https://www.rstudio.com/products/rstudio/download/

The original R site is at url below.

https://www.r-project.org/

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

Free ebook: Containerized Docker Application Lifecycle with Microsoft Tools and Platform

This sounds to me like I can develop an application in Windows Platform such as C# and run on Linux.

There is no clear sample code you can use to try the application with the Docker. The book purely deliver you a lot of concept. Enjoy browsing,

https://blogs.msdn.microsoft.com/microsoft_press/2016/12/07/free-ebook-containerized-docker-applications-lifecycle-with-microsoft-tools-and-platform/?MC=CCPLUS&MC=Virtual&MC=WebDev&MC=SharePoint&MC=CloudPlat

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