20 September, 2017

Kaspersky Lab Endpoint Security 10.3

Kaspersky Lab
Kaspersky Lab (Photo credit: Wikipedia)

Our AVG Business Edition antivirus is expiring in a week's time. Kaspersky is being eyed as the option. So I was asked to do reviews and evaluation.

Now, AVG is okay, so far. But there is a more stringent and more complex implementation for one of our customers. We deal with building management systems, and nowadays, customers do not want to be talking to 2 vendors. So instead of having the BMS company and the Intelligent System provider as separate packages, BMS now takes under its umbrella the Intelligent System. This brings into the scope of the BMs company the task to choose and coordinate with whoever will be the IS vendor.

According to av-test.com, there are 5 antivirus products that garnered all full marks for protection, performance and usability. In no particular order, these are Kaspersky Lab Endpoint Security 10.3, Kaspersky Lab Small Office Security 5, Symantec Endpoint Protection 14.0, Symantec Endpoint Protection Cloud 22.9 and Trend Micro Office Scan 12.0.

That data is coming from their report The best antivirus software for Windows Client Business User.

Now I found out that av-test.com is a 'paid' review, which means that if you want to be reviewed, you pay. So I looked for another antivirus review company that is independent.

I found AV-Comparatives.

And you can check for your their August 2017 Report. Kaspersky has some sort of compromised moments. But that is not all.

Kaspersky has KICS, the product we are just looking for. Aside from doing the mechanical and electrical parts good, we need to protect the control system from hacks.

So I won't be telling more now. We chose Kaspersky Endpoint Security 10.3 for our company's antivirus and real-time protection, and on top of that, we are engaging Kaspersky for their KICS.

Today is the first day that we are rolling out our 3-year package to each PC and we have about 2 weeks to complete the task. Hopefully, we can manage the task quite well, and that Kaspersky AV lives up to its name.

Till then!

06 September, 2017

Singleton: Create A Single-Instance Application

UML class diagram of the singleton design pattern
UML class diagram of the singleton design pattern (Photo credit: Wikipedia)

Create a single-instance application. That was the objective I thought of lately on one small program I am creating. That is due to some database update needed. So no double-update or better yet, multiple updates, must happen.

Okay. It was actually simple, but here I will just outline the simple steps - again, for my own use when I need it in the future - and also for anybody else who might need to implement this same feature in their programs.

So how do you create a single-instance application? How to enforce a singleton pattern?

It is very easy. Just look at the code snippet below. And this is using Mutex in the Program section where your code execution starts.

internal static class Program {
private static Mutex mutex = new Mutex(true, "{a381c74c-c9a1-4716-beff-e8a08e964462}");

private static void Main() {
if (mutex.WaitOne(TimeSpan.Zero, true)) {
Application.Run(new MainForm());
else {
MessageBox.Show("Only one instance allowed.");

So that is the baseline requirement to satisfy a singleton pattern. And if you are wondering the seemingly cryptic string in the Mutex declaration, fret not. It is just a string that Mutex implementation requires, so it can be anything, like the name of your application, but it must be unique.

Alright, if you insist on using the same seemingly cryptic alphanumeric combination so it is unique, then add these 2 lines somewhere in the form load event, and just capture that value, and put it in the Mutex declaration. And comment those 2 lines right away as they are no longer needed.

var guiId = System.Guid.NewGuid();

Yes, that's how I got mine.

Now there is an additional feature that can be included, and not just simply throwing a message box. The thing is, why not bring up the instance of the running application instead?

Well, that is possible.

Modify the Program section as per below code, which means disabling the message box and replacing it with some nifty Win32 function (API). It is sending a message to all other running applications, but since it is unique only to this application, then it is understood only by this same application, so only this particular program will respond. Mind-boggling, isn't it?

Let's get done with it then!

internal static class Program {
private static Mutex mutex = new Mutex(true, "{a381c74c-c9a1-4716-beff-e8a08e964462}");

private static void Main() {
if (mutex.WaitOne(TimeSpan.Zero, true)) {
Application.Run(new MainForm());
else {
// MessageBox.Show("Only one instance allowed.");
// send our Win32 message to make the currently running instance
// jump on top of all the other windows
NativeMethods.WM_SHOWME, IntPtr.Zero, IntPtr.Zero);

As for NativeMethods.cs, you need to create a new class for that.

internal class NativeMethods {
public const int HWND_BROADCAST = 0xffff;
public static readonly int WM_SHOWME = RegisterWindowMessage("WM_SHOWME");

public static extern bool PostMessage(IntPtr hwnd, int msg, IntPtr wparam, IntPtr lparam);

public static extern int RegisterWindowMessage(string message);

Then, to complete the code, add two procedures after the Main Form's call to InitializeComponent.

public MainForm() {

protected override void WndProc(ref Message m) {
if (m.Msg == NativeMethods.WM_SHOWME) {
base.WndProc(ref m);

private void ShowMe() {
if (WindowState == FormWindowState.Minimized) { WindowState = FormWindowState.Normal; }
// get our current "TopMost" value (ours will always be false though)
var top = TopMost;
// make our form jump to the top of everything
TopMost = true;
// set it back to whatever it was
TopMost = top;

Now this is all that it takes to create a singleton implementation of a program. This is written in C#, so feel free to adapt this to other languages as you deem fit.


I am simply blogging on this singleton implementation, on how to create a single-instance application, but the source articles are here and here, thanks to the authors! Read on these 2 articles to get more explanations, and other suggestions, too.

Until then, happy coding!

24 August, 2017

Minimize An App to System Tray


I am writing a small WinForms program, and I thought of including minimize an app to system tray feature. Since this is the first time I will do this, I just did a search in Google. I am very sure many have done it as it already is a common feature.

Well, common for everybody else, but at this point, not me. Not yet.

Thus, I searched for ‘minimize an app to system tray’, and I did find valuable articles, many in Q&A forums, like StackOverflow.com.

I’ll go directly to the point now. What is required to make it happen?

1. Handle the form’s resize event.
2. Make a NotifyIcon click event restore the form back.

Here’s how it’s done.

Handle the Form’s Resize Event

Select the form and on its Events, declare this:

private void MyForm_Resize(object sender, EventArgs e) {
    if (FormWindowState.Minimized == this.WindowState) {
       myNotifyIcon.Visible = true;
    else if (FormWindowState.Normal == this.WindowState) {
       myNotifyIcon.Visible = false;

Make a NotifyIcon Click Event Restore the Form Back

Add a NotifyIcon tool, and on its click event, declare this:

private void myNotifyIcon_Click(object sender, EventArgs e) {
    this.WindowState = FormWindowState.Normal;

This is all that is required, really. But sometimes it doesn’t work. One small trick is needed.

Add an Icon to the NotifyIcon tool.

myNotifyIcon.Icon = SystemIcons.Application;

Also, you can add in the Text and Tip properties:

myNotifyIcon.BalloonTipText = "App is minimized to System Tray.";

myNotifyIcon.BalloonTipTitle = "My App Name";

Sometimes, you will see articles that suggest using the Form’s Visible property. But this is also known to still make the app appear or selectable (although not visible) when you do Alt + Tab. So stick to Hide() and Show() events. Still your choice, though.

Okay. I’ll stop here, cause that’s all that is really needed to minimize an app to system tray. Easy, right?

Happy coding!

09 August, 2017

Is ScanGuard Safe? Suggested After Windows 10 Creators Update?

Microsoft Security Essentials
Microsoft Security Essentials (Photo credit: Wikipedia)

Today I run Windows 10 Creators Update. One of the first articles that are listed in Microsoft Edge is the supposedly 'a must' ScanGuard installation - to protect your PC.

I am not sure if this is the first time I hear or read about ScanGuard antivirus, so I did a quick search.

Surprise, surprise!

About a year ago, many people threw all kinds of negative comments on this product, many veered away without even touching it, and many to tried it anyway, ended up uninstalling it. Reason? Creates thousands of false positive alarms!

It was not a good antivirus product and the company who made it, well, is new. Not yet established in the playing field.

What's the suggestion then? Use Microsoft Security Essentials, or Windows Defender. Or Malwarebytes. Even the free version of MBAM will do. Personally, I use Malwarebytes, and I'm sticking with it. And long years before, I did use Windows Defender and was contented with it.

So why would Windows endorse such a kind of product? I wouldn't know.

But for now, I will be waiting and on the lookout for fresh developments. One year and there should be much progress, who knows?

I guess those who have anything to say, well, all are welcome to leave their comments here, thank you!

Till then!

28 July, 2017

Yahoo Bizmail SMTP Settings Configuration Problem

English: SMTP transfer model Blue arrows can b...
English: SMTP transfer model Blue arrows can be implemented by SMTP variations (Photo credit: Wikipedia)

Lately, yahoo bizmail SMTP settings or configuration throws error. The password is not being accepted. Despite confirming it to be correct!

And if you try to search for solutions and resolutions, all that will be offered is the usual procedure for setting up a new account, POP e-mail, IMAP e-mail, keying in the user name, full e-mail and password, and the servers:

pop.bizmail.yahoo.com, port 995, SSL security
smtp.bizmail.yahoo.com, port 465, SSL security, if not, TLS and SSL security

and the usual More Settings.

But despite entering, checking and verifying at least 3 times that all the entries are correct, only incoming mail goes okay and Test passes and is marked ‘Completed’, but not for incoming mail, which uses SMTP: it will keep on asking for your password, then eventually, is marked ‘Failed’.

So what really is the problem?

It could be Yahoo SMTP Server problem, as it happened to so many users.

But one solution that I found is this: register inetcomm.dll.

I also needed to use my personal laptop, which has my personal e-mail, so that I cannot touch. But being more comfortable using my own, I just wanted to ‘add in’ my work e-mail using the same application: Microsoft Outlook.

So, I just proceed to add a new account, entered everything correctly, key in my password, and naturally, ran into the SMTP ‘enter password’ issue.

I tried everything that I can find on the web, but nothing. Nada. Zilch. Still the same problem on the SMTP outgoing mail, asking for a password, even though it is the correct password already.

Then I found one article that threw a few possible suggestions, but on top is to register inetcomm.dll:

Open up an elevated-privilege command prompt session
1. Press Windows key + R
2. In the box, type cmd
3. Press Ctrl + Shift + Enter

Go to C:\Windows\System32
1. Type C: if you are not in C: drive
2. Type cd\ and press Enter
3. Type cd windows\system32 and press Enter (Windows\System32 also can)
4. Then finally, type regsvr32 inetcomm.dll and press Enter
5. An error will be reported, but just ignore that and close the opened box.

That’s it!

This is all that fixed the problem on the outgoing mails for Yahoo's smtp.bizmail.yahoo.com, using port 465. And I have confirmed it on my own account, as on other users. I am setting up a few laptops running Windows 10 64 bit and using Microsoft Outlook 2010. Mine is Windows 10 64 bit and Microsoft Outlook 2007.

Try it!

16 July, 2017

Remote data not accessible: Excel 2016

English: Illustration of subroutine in Microso...
English: Illustration of subroutine in Microsoft Excel that reads the x-column, squares it, and writes the squares into the y-column. All proprietary Microsoft art work has been cropped to leave a generic spreadsheet (Photo credit: Wikipedia)
English: Use of user-defined function in Micro...
English: Use of user-defined function in Microsoft Excel. All proprietary Microsoft art work has been cropped to leave a generic spreadsheet (Photo credit: Wikipedia)
16 July 2017, 10:20 PM

Remote data not accessible:
To access this data Excel needs to start another application. Some legitimate applications on your computer could be used maliciously to spread viruses or damage your computer. Only click Yes if you trust the source of theis workbook and you want to let the workbook start the application. Start application 'SV.EXE'?  YES NO

I am working on PcVue data extraction using Excel 2016. That was the response thrown by Excel after I typed "=SV|DB!DATE" and pressed [Enter].

Of course, I clicked on YES, but then again, this is the result:

“Cannot run ‘SV.EXE’.  The program or one of its components is damaged or missing.”

Beats me!

This is another one of those DDE nightmares, where the support for a legacy system is required even when already using Windows 10 64 bit and Excel 2016.

I searched for more articles using the string "remote data not accessible" and well, I got some from Technet, and some from Microsft forums, and some scattered Q&A here and there, even in StackOverflow. And I think the solution was derived from one of the Microsoft forums Q&A.

The advice is to make Excel run as Admin. So I did that. I modified the shortcut of Excel 2016 to make it execute, 'Run as administrator'.

And yes, it worked! I was able to extract data from PcVue iNexus 10/11.2 into Excel using DDE!

Then the C# program wouldn't still work, though.

But getting the idea from what I did to Excel, I looked for the compiled program, set it also to execute and 'Run as administrator', well, what do you know?

It also worked!

So while I cannot make use of DDE through Visual Studio's Ctrl+F5. I just do a build, set the compiled exe file's property to 'Run ad administrator', and voila! It would be working like a charm!

I hope this helps somebody working on the same legacy system, DDE, and still make it work.

Till then!