Category Archives: Computers and Internet

ORA-03134: Connections to this server version are no longer supported

By reading this blog you may save sometimes for download the unnecessary Oracle drivers for Visual Studio. If you still have Oracle 9i and you want to download 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual … Continue reading

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

Oracle sql developer not displaying time

When you send in a sql statement in Oracle SQL Developer you might only see the date but not the time in the datetime field. Go to Tools -> Preferences -> Database – NLS then put in the Date format … Continue reading

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

cannot convert null to ‘system.datetime’ because it is a non-nullable value type

This blog shows you the workaround for the error “cannot convert null to ‘system.datetime’ because it is a non-nullable value type” especially with you are working with SSIS project. Declare the header using System.Data.SqlTypes; In Database Timestamp field you write. … Continue reading

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

Install Visual Studio 2017

This short blog walk you through the installation of Visual Studio 2017. Run mu_visual_studio_enterprise_2017_x86_x64_10049783.exe from the offline installer (here is how you get the offline installer https://chanmingman.wordpress.com/2017/03/11/create-visual-studio-2017-offline-installer/). For this installation, I choose .NET desktop Development, Desktop development with C++, ASP.NET, … Continue reading

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

Create Visual Studio 2017 offline installer

Good or bad news, Visual Studio no longer comes with ISO file for download in MSDN. You need to run the command in command prompt to get your own Offline Installer. The instruction link is below. https://docs.microsoft.com/en-us/visualstudio/install/create-an-offline-installation-of-visual-studio There are some … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, sharepoint | Tagged , , , , , , | 1 Comment

Microsoft Power BI vs Qlik vs Tableau 2017

Gartner 2017 reports shows Tableau, Qlik, and Microsoft are the leader in Business Intelligence and Analytics Platforms. The full Gartner url is at the bottom. The Gartner link will be expired in sometime later, that was my experience with Gartner … Continue reading

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

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 … Continue reading

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