How To Connect To Informix Database Using Squirrel SQL Client

Hi readers,

In this post I will show you how to connect to Informix database using Squirrel SQL client. First thing we gonna need is:

1. Squirrel SQL Client

Squirrel SQL client is written in Java language so obviously you need to have Java installed in your machine. Once installed, you can proceed to download Squirrel SQL client from HERE. Run the installer and follow the on screen instructions.

2. Check Necessary Requirements

Run the Squirrel SQL client. Go to 'Drivers' tab. Check whether there is blue check mark next to 'Informix'. 

If there is no blue check mark, most probably you don't have the extra class for Informix.

Go HERE to download the extra class. Extract the zip file to get the jar archive.

If there is no Informix driver at all, do install the driver first. Get it from HERE. Run the setup.exe and follow the instructions.

If you see blue check mark, do proceed with step number 4.

3. Configure Extra Class Path

Right click on Informix, select Modify option. Click on Extra Class Path tab, click Add and point to the jar file. Dont forget to fill your database information in Example URL. Click Open, then OK.

4. Configure Aliases

 

Go to aliases tab, click plus sign to add new alias. Give a name for your new alias and choose Informix driver. Automatically the URL will be filled out. Make sure it is correct. Fill in your database username and password. Click Test to test the connection. If everything goes well, you can connect to your database straight away.

Crystal Report: Convert Total Seconds to HH:MM:SS Format

Lets say the total seconds is 6214:

NumberVar TotalSec :=  6214;
NumberVar Hours   := Truncate  (Remainder ( TotalSec , 86400) / 3600) ;
NumberVar Minutes := Truncate  (Remainder ( TotalSec , 3600) / 60) ;
NumberVar Seconds := Remainder (TotalSec , 60) ;
Totext ( Hours ,   '00' ) +  ':' +
Totext ( Minutes , '00' ) +  ':' +
Totext ( Seconds , '00' ) 

Solution: Double Scrollbar Problem in Google Chrome Browser

Have you guys updated your Google Chrome browser only to found out there is a bug with scrollbar?

Recently, I've downloaded the Google Chrome and found out that on certain websites, the scrollbar becomes doubled (see picture below).

For me, it is quite annoying because I had to put my cursor on the right scrollbar AND leveled with the left scrollbar. Or to be exact, everything (checkbox, submit button etc2) I have to click a little bit to the right.

Fortunately, with a bit of Googling, I've found a way to solve this.

1. Open up your Google Chrome browser. Point the address bar to "chrome://plugins"
2. Find a Flash plugin that named as "pepflashplayer.dll". If you installed a lot of olugins and having some trouble finding it, press "Ctrl + F" and find the plugin name mentioned before.
3. And then click "Disable". Restart the Chrome and try whether it works. It works for me by the way :)

ICS For Desire S is Out

Finally after long waiting, ICS update for Desire S is out. Download the ROM update utility RUU from here. Enter into USB Debugging mode, run RUU and follow on screen instruction.

How To Gather/Extract Files From Many Folders Into a Single Folder

Imagine you have multiple or even hundreds of folder and within each folder there are files. You want to gather all these files into a single folder. Obviously you can copy/paste, drag/drop one file at a time. But it is only make sense if it involve below 10 folders. But for hundreds of folders, it is time consuming. However, there is a way to do it. The quick, simple way.

Shutter Speed vs. FPS

Before this, I have a problem understanding the differences between shutter speed and frame per seconds while recording video in DSLR. So, I assumed it's not important. IT IS differs and important especially when you want to record fast moving action.

In short:
Shutter speed: How much each frame is exposed to the light source.
FPS: How many frames are recorded each seconds

See the details explanation below.







Thanks.

How To Remove Smart Fortress 2012

Recently, my computer has been infected by rogue antivirus program namely Smart Fortress 2012. It is loaded whenever I boot up my Windows and displays various warning alert to lure users to buy the full version.

Among the effects are:

• slows down my computer
• I'm unable to open task manager
• cannot run any application
• rendering my computer useless

With a bit of Googling and luck, I was able to remove the fake antivirus.

Here's how do I do it: