Monthly Archives: March 2017

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

Office 2013 application cannot run Office App Store application

This blog is specifically for Windows 7 32 bit and Office 2013 32 bit. I have this problem when my Windows 7 32 bit, cannot do Windows Update. That also means MS Office 2013 will not be updated. You need … Continue reading

Posted in .Net, Cloud, Community, Microsoft Office, Office 365, sharepoint | Tagged , , , , , | Leave a 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