Toad for oracle over ssh with putty Hint

Download & Install putty https://www.putty.org/   Putty Configuration Connection > SSH > Tunnels  Check [Local ports ....] Check [Remote ports ....] Source Port : 15219 Destination : yourdb.server.com:1521 Click [Add] Do not click Open button, You must save this configure...   Session : Input your Host, ssh Port, Saved Session name, and Click [Save]   […]

Read More

Excel vs Unix Timestemp : excel datevalue to java dateformat Hint!

Unix Timestamp from 1970 Excel Timestamp from 1900 Gap : (1970-1900) Days = 25569 Days     String rtn = ""; try{ DateFormat format = new SimpleDateFormat("yyyyMMdd"); //format.setTimeZone(TimeZone.getTimeZone("UTC")); double excelDays = Double.parseDouble((String)valv.elementAt(0)); double unixDays = (excelDays-25569); java.util.Date unixTime = new java.util.Date((long) ( 86400000l * unixDays)); rtn = format.format(unixTime); out.println(rtn); } catch(Exception e) {}  

Read More

Remove All Tap-Windows Adapter V9 by OpenVPN

Step1. download OpenVPN https://openvpn.net/index.php/download/community-downloads.html   Step2. install "TAP-Windows" only   Step3. Go TAP-Windows Folder > cd C:\Program Files\TAP-Windows\bin   Step4. Edit deltapall.bat by Notepad, if need be.. like below (it needs to set write access) ------------------------------------------------------------ pause "C:\Program Files\TAP-Windows\bin\tapinstall.exe" remove tap0901 pause "C:\Program Files\TAP-Windows\bin\tapinstall.exe" remove tapoas pause ------------------------------------------------------------   Step5. execute deltapall.bat      

Read More