Category Archives: windows

Bagaimana membuka Firebird SQL?

Published by:

Saya baru tahu kalau ada jenis sql database yang bernama firebird. Jadi firebird ini seperti jenis database berbasis sql. Mungkin anda pernah dengar tentang maria-db dsb. Nah ini satu lagi jenis yang lain, firebird. Si Burung Api.

Untuk mengekstraknya diperlukan dashboard administrator yang sesuai. Sepertinya firebird mempunyai perbedaan dalam hal encrypsi. Dan saya kebingunan, dashboard admin apa yang bisa membuka firebird?

Re-make Windows 7 installation to choose the version

Published by:

Borrow a friends Genuine Windows 7 32 bit DVD disc if you know someone who has one.

Make an image of the DVD, you can use a program such as ISO Recorder to do that.

If you don’t have a Windows 7 DVD to borrow, try downloading an image:

32 bit

You are going to edit the contents of the .ISO file and remove the ei.cfg file. After editing burn it to a blank DVD disk or put it on a thumb drive. Boot from it, this will reveal all editions of Windows 7, select the Starter edition. More information in the following article about how to edit the ei.cfg file

Ei.cfg Removal Utility Lets You Use Any Product Key

You can create a bootable thumb drive with the following:
Windows 7 USB/DVD Download Tool

Skip entering your Windows 7 product key and complete the installation.

Once you reach the desktop, click Start, right click Computer

Click Properties

Scroll down to Windows Activation

Click the link x days until activation.

Click the link that says ‘Show me other ways to activate’

Enter product key (this is Windows 7 Starter key which would be located on the COA sticker at the bottom of your laptop)

Click Next

Select Phone Activation

Click Next when Enter your key page displayed

Select your country

Click Next, call the number listed

Remember to explain to the call agent your situation.

They will give you a confirmation ID, enter it

Click Next to complete the activation.

Excel lost its printer list

Published by:

Please do the following steps

  1. Open regedit
  2. Go to HKEY_CURRENT_USER -> software -> Microsoft -> WindowsNT ->
  3. Here you find the three folder Devices , Printer Ports and Windows
  4. Right click on every folder and give the full permission for the user in which you show this problem
  5. Restart the system


Corel X4 error 24 – can’t run

Published by:

Source :

Akhirnya semua pc ber corel X4 di tempat saya kerja mengalami hal ini, error 24. Menurut sumber di link di atas, penyebabnya terjadi setelah lewat tanggal 1 Juni 2010. Entahlah kejadiannya saya tahun 2017 kok.

Ok tidak apa-apa yang penting solusinya. Yaitu dengan mengganti sebuah file yang bernama dr14.dta yang ada di lokasi C:\ProgramData\Corel\CorelDRAW Graphics Suite X4 untuk windows Windows Vista & 7. Atau C:\Documents and Settings\All Users\Application Data\Corel\CorelDRAW Graphics Suite X4 untuk Windows XP.

Dari mana file tersebut? Ya download lah dari pemilik web source di atas, atau langsung di sini :

Nah mestinya problem error 24 sekarang sudah selesai.

Picture source here.

Mass copy for backup in windows

Published by:

What I do love as a system administrator is backup things. Documents, picture, archieves, anything. And I always want to do it in a simple but powerful command prompt or console.

In microsoft there are two command available in the command prompt to do this.

First : xcopy
This is the syntax

xcopy /s /d *.doc source destination

source could be D: and destination could be E:
/s means create also the subdirectories but not empty one
/d means if there is a similar file in the destination, copy only if the source is newer

Second : robocopy
Microsoft said, this command will not be found in basic microsoft or home edition. Only in network windows or professional edition. I read the how to command, it is quite powerfull. It can copy over network through samba or something like \\\destination. The syntax is :

robocopy source destination *.doc /s /xo /r:2

/s means create also the subdirectories but not empty one
/xo means if there is a similar file in the destination, copy only if the source is newer
/r:2 means the number or retry when the command try to access to denial directory or error directory

This is the full option for xcopy


xcopySource [Destination] [/w] [/p] [/c] [/v] [/q] [/f] [/l] [/g] [/d[:mm-dd-yyyy]] [/u] [/i] [/s [/e]] [/t] [/k] [/r] [/h] [{/a|/m}] [/n] [/o] [/x] [/exclude:file1[+[file2]][+[file3]] [{/y|/-y}] [/z]


Source : Required. Specifies the location and names of the files you want to copy. This parameter must include either a drive or a path.

Destination : Specifies the destination of the files you want to copy. This parameter can include a drive letter and colon, a directory name, a file name, or a combination of these.

/w : Displays the following message and waits for your response before starting to copy files:

Press any key to begin copying file(s)

/p : Prompts you to confirm whether you want to create each destination file.

/c : Ignores errors.

/v : Verifies each file as it is written to the destination file to make sure that the destination files are identical to the source files.

/q : Suppresses the display of xcopy messages.

/f : Displays source and destination file names while copying.

/l : Displays a list of files that are to be copied.

/g : Creates decrypted destination files.

/d[:mm-dd-yyyy] : Copies source files changed on or after the specified date only. If you do not include a mm-dd-yyyy value, xcopy copies all Source files that are newer than existing Destination files. This command-line option allows you to update files that have changed.

/u : Copies files from Source that exist on Destination only.

/i : If Source is a directory or contains wildcards and Destination does not exist, xcopy assumes destination specifies a directory name and creates a new directory. Then, xcopycopies all specified files into the new directory. By default, xcopy prompts you to specify whether Destination is a file or a directory.

/s : Copies directories and subdirectories, unless they are empty. If you omit /s, xcopy works within a single directory.

/e : Copies all subdirectories, even if they are empty. Use /e with the /s and /t command-line options.

/t : Copies the subdirectory structure (that is, the tree) only, not files. To copy empty directories, you must include the /e command-line option.

/k : Copies files and retains the read-only attribute on destination files if present on the source files. By default, xcopy removes the read-only attribute.

/r : Copies read-only files.

/h : Copies files with hidden and system file attributes. By default, xcopy does not copy hidden or system files.

/a : Copies only source files that have their archive file attributes set. /a does not modify the archive file attribute of the source file. For information about how to set the archive file attribute by using attrib, see Related Topics.

/m : Copies source files that have their archive file attributes set. Unlike /a, /m turns off archive file attributes in the files that are specified in the source. For information about how to set the archive file attribute by using attrib, see Related Topics.

/n : Creates copies by using the NTFS short file or directory names. /n is required when you copy files or directories from an NTFS volume to a FAT volume or when the FAT file system naming convention (that is, 8.3 characters) is required on the destination file system. The destination file system can be FAT or NTFS.

/o : Copies file ownership and discretionary access control list (DACL) information.

/x : Copies file audit settings and system access control list (SACL) information (implies /o).

/exclude:filename1[+[filename2]][+[filename3]] : Specifies a list of files containing strings.

/y : Suppresses prompting to confirm that you want to overwrite an existing destination file.

/-y : Prompts to confirm that you want to overwrite an existing destination file.

/z : Copies over a network in restartable mode.

/? : Displays help at the command prompt.

This is the full option for robocopy

ROBOCOPY <source> <destination> [file…] [options]
<source> Source Directory (local or network path)
<destination> Destination Directory (local or network path) and
[file…] Specifies the file or files to be copied. You can use wildcard characters (* or ?), if you want. If the File parameter is not specified, *.* is used as the default value.


**Skip to the end of this document for more information on Robocopy Options and Switches .

Examples of Microsoft’s Robocopy Syntax

#1 Simple copy

To copy contents of C:\UserFolder to C:\FolderBackup:

Robocopy C:\UserFolder C:\FolderBackup

This is the simplest usage for Robocopy

#2 Copy all content including empty directory

To copy all contents including empty directories of SourceFolder to DestinationFolder:

Robocopy C:\SourceDir C:\DestDir /E

#3 List only

List only files larger than 32 MBytes(33553332 bytes) in size.

Robocopy.exe c:\sourceFolder d:\targetfolder /min:33553332 /l

Note: /l – will list files matching the criteria. if /l is omitted, files matching the criteria will be copied to the taget location

#4 Move files over 14 days old

Move files over 14 days old (note the MOVE option will fail if any files are open and locked).

ROBOCOPY C:\SourceFoldern D:\DestinationFolder /move /minage:14

Similarly you could use the below switches

  • /maxage: <N> Specifies the maximum file age (to exclude files older than N days or date).
  • /minage: <N>  Specifies the minimum file age (exclude files newer than N days or date).
  • /maxlad: <N> Specifies the maximum last access date (excludes files unused since N).
  • /minlad: <N> Specifies the minimum last access date (excludes files used since N) If N is less than 1900, N specifies the number of days. Otherwise, N specifies a date in the format YYYYMMDD

#5 Mirror a directory with subfolders incl. empty directories

/MIR is an option to ROBOCOPY where you mirror a directory tree with all the subfolders including the empty directories and you purge files and folders on the destination server that no longer exists in source.

ROBOCOPY \\sourceserver\share \\destinationserver\share /MIR


ROBOCOPY source-drive:\DIR destination-drive:\DIR /MIR

#6 Mirror directories

The following command will mirror the directories using Robocopy:

Robocopy \\SourceServer\Share \\DestinationServer\Share /MIR /FFT /Z /XA:H /W:5

Explanation of the switches used:

  • /MIR specifies that Robocopy should mirror the source directory and the destination directory. Note that this will delete files at the destination if they were deleted at the source.
  • /FFT uses fat file timing instead of NTFS. This means the granularity is a bit less precise. For across-network share operations this seems to be much more reliable – just don’t rely on the file timings to be completely precise to the second.
  • /Z ensures Robocopy can resume the transfer of a large file in mid-file instead of restarting.
  • /XA:H makes Robocopy ignore hidden files, usually these will be system files that we’re not interested in.
  • /W:5 reduces the wait time between failures to 5 seconds instead of the 30 second default.

#7 Copy all changes

Use Robocopy to copy all changes to files in a directory called c:\data to a directory that contains the date, like data_20091124.  Create a batch file as follows.

@echo off
set day=%date:~0,2%
set month=%date:~3,2%
set year=%date:~6,4%
Robocopy "c:\data" "c:\backup\data\%day%-%month%-%year%\" /MAXAGE:1

#8 Mirror directory excl. deletion

To mirror the directory “C:\directory” to “\\server2\directory” excluding \\server2\directory\dir2″ from being deleted (since it isn’t present in C:\directory) use the following command:

Robocopy "C:\Folder" "\\Machine2\Folder" /MIR /XD  \\server2\ directory\dir2"

Robocopy can be setup as a simply Scheduled Task that runs daily, hourly, weekly etc. Note that Robocopy also contains a switch that will make Robocopy monitor the source for changes and invoke synchronization each time a configurable number of changes has been made. This may work in your scenario, but be aware that Robocopy will not just copy the changes, it will scan the complete directory structure just like a normal mirroring procedure. If there are a lot of files & directories, this may hamper performance.

#9 Copy permissions only

You have copied the contents from source to destination but now you made changes to the Security permissions at source. You wanted to copy only the permission changes and not data.

ROBOCOPY <Source> <Target> /E /Copy:S /IS /IT

Copy option have the following flags to use:

  • D Data
  • A Attributes
  • T Time stamps
  • S NTFS access control list (ACL)
  • O Owner information
  • U Auditing information

The default value for CopyFlags is DAT (data, attributes, and time stamps).

  • /IS – Includes the same files.
  • /IT – Includes “tweaked” files.


removing windows installer identifier

Published by:

Nah, maksud saya sih dalam bahasa indo itu “menghilangkan penanda instalasi windows terhadap versi tertentu”. Ya kira-kira seperti itu. Mudah-mudahan ini langkah yang legal ya, soalnya malas juga membaca legal notice hehehe (sorry Bill). Dan pula saya menemukan artikel ini secara bebas juga. Lagi pula cara ini tidak menghilangkan langkah input key, yang biasanya ada di stiker2 windows asli. Ini cuma cara menggunakan satu jenis cd instalasi, dan kita bebas memilih jenis windowsnya sesuai dengan key yang kita punya (key nya beli lho).

Windows sendiri punya beberapa versi. Yaitu :



Windows 10 29 Juli 2015 NT 10.0[1]
  • Windows 10 Home
  • Windows 10 Pro
  • Windows 10 Enterprise
  • Windows 10 Education
  • Windows 10 Mobile
  • Windows 10 Mobile Enterprise
  • Windows 10 IoT Core

Lihat Edisi Windows 10

Windows 8.1 18 Oktober 2013 NT 6.3
  • Windows 8.1
  • Windows 8.1 Pro
  • Windows 8.1 Enterprise
Windows 8 26 Oktober 2012 NT 6.2
  • Windows 8
  • Windows 8 Pro
  • Windows 8 Enterprise

Lihat Edisi Windows 8

Windows 7 22 Oktober 2009 NT 6.1
  • Windows 7 Home Basic
  • Windows 7 Home Premium
  • Windows 7 Professional
  • Windows 7 Enterprise
  • Windows 7 Ultimate
  • Windows Thin PC

Lihat Edisi Windows 7

Windows Vista 30 Januari 2007 NT 6.0
  • Windows Vista Home Premium
  • Windows Vista Business
  • Windows Vista Enterprise
  • Windows Vista Ultimate

Lihat Edisi Windows Vista

Windows XP 25 Oktober 2001 NT 5.1

Lihat Edisi Windows XP

Sumber :

Ya begitulah, panjang.

Oke intinya adalah kita perlu membongkar isi cd/dvd instalasi tersebut dan menghilang satu buah file penting di dalamnya. Pertama, milikilah satu cd windows asli. Misalnya saya punya windows 7 Home cd. Tapi saya ingin menggunakan cd ini untuk key (asli) windows professional. Biasanya saya harus pakai cd windows 7 professional, tapi karena hilang, maka saya kesulitan meng-install ulang komputer windows 7 professional saya.

CD tersebut kita mount ke directory apa saja. Jika anda menggunakan linux, akan cukup melakukan perintah sbb di console/ terminal:

$root:#//mount -o loop /media/cdwindows /home/user/temp

nama cdwindows dan temp adalah nama yang bisa berbeda di komputer anda.

Jika anda menggunakan windows, anda perlu software tambahan seperti VirtualCDRom, WinCDEMU dan sebagainya.

Karena hasil mount ini sifatnya read-only, maka kita perlu memindahkan isi cd tersebut ke folder lain di komputer kita. Caranya cukup dengan copy paste saja.

Katakanlah, kita menyimpannya di
My Documents\fileinstallasi.

Setelah itu carilah file yang bernama ei.cfg. Biasanya ada di dalam folder sources.
Kalau lihat contoh, maka ia akan berada di My Documents\fileinstallasi\sources\ei.cfg

File tersebut anda boleh rename, pindahkan, atau langsung di delete saja. File ini adalah file identifier yang memperlihatkan versi dari cd windows yang microsoft jual. Di dalamnya isinya seperti ini


Dengan hilangnya file tersebut, maka ketika kita melakukan instalasi windows akan muncul pilihan, kita akan menginstall windows (versi x) starter, home basic, home premium, professional atau ultimate. Yang paling kumplit itu ultimate.

Oke sekarang kita perlu membuat / remake, folder sementara kita ke dalam bentuk iso kembali, sehingga kita bisa burn ke cd atau dimasukan ke usb atau didiamkan saja iso seperti itu.

Di linux bisa menggunakan bracero (ubuntu, debian dsb) atau menggunakan command line/ terminal/ konsole dengan perintah genisoimage

$ genisoimage -udf image.iso -o my documents/fileintallasi/

Awalnya saya tidak menggunakan option udf, tapi hasilnya ternyata iso windows yang gagal. Karena dalam iso ini kita perlu menempatkan beberapa opsi. Selain udf, juga ada opsi untuk membuat si iso bootable. Sehingga jika kita mem-burn nya ke cd, maka cd akan bisa diboot dari komputer.

Cara paling mudah memang menggunakan software di windows seperti ImgBurn. Software ini cukup mudah digunakan dan gratis. Setelah di install, di running, dan pilih “Create Image file from file/folder”.

Masukan my documents/fileinstallasi pada source, lalu pilih Advanced Tab – Bootable Disc

Jangan lupa isikan destination file iso nya. Dalam hal ini anda boleh memilih langsung memburn hasil iso ke cd dengan memilih Write file/folder to disc. Atau menggunakan cara ini dulu, setelah itu masuk ke ImgBurn lagi lalu pilih Write Image File to Disc.

Setelah itu tunggu hingga selesai. Dan that’s it.

re-install windows 7 with recovery partition

Published by:

Awalnya berasal dari pekerjaan di kantor. Sebuah notebook terkenal virus cukup bandel. Ia menginfeksi file system msiexec.exe
Jadinya sulit sekali dibersihkan. Avast berhasil mengidentifikasinya tapi gagal membersihkannya. Jadi jika ingin yakin notebook itu bersih, saya harus menginstal ulang systemnya. Selidik punya selidik ternyata ini notebook dengan windows 7 starter, original tentunya. Saya pun memeriksa menu-menu atau shortcut atau apa pun yang berhubungan dengan recovery. Ternyata tidak ada. Lalu saya pun memeriksa partisinya. Hanya ada dua. Windows partition dan data partition. Oke berarti partisi recovery tidak ada. Entah itu karena dulu pernah saya install ulang atau bagaimana, saya benar-benar lupa.
Oke setelah belajar sedikit sana sedikit sini. Maka saya akan menerapkan teknik membuat recovery partition buatan.
Langkah secara garis besar adalah sebagai berikut :
1. install ulang dengan membuat dua partisi, karena sebelumnya sudah ada partisi data, maka saya hanya memodifikasi partisi C, saya bagi dua. Yang satu untuk install windows baru, yang satu untuk menyimpan instalasi recovery. Masalah muncul disini, karena saya tidak punya cd windows 7 starter. Saya hanya punya versi Basic. Akhirnya saya harus mencari iso instalasi windows starter. Ow dan saya menemukan ilmu baru. Kalau ternyata cd instalasi windows itu sebenarnya bisa digunakan untuk jenis instalasi apa saja, dari starter, basic, home, professional atau apa lah itu istilahnya. Dan caranya akan saya tulis di posting berikutnya.
2. Setelah instalasi ulang selesai, mulailah kita menyimpan file instalasi di directory recovery tadi. Caranya juga lumayan rumit. Saya mengikuti panduan sambil kleyeng-kleyeng. Ikuti caranya di posting ini (posting berikutnya).
3. Mengcopy image system yang sedang berjalan (install.wim tapi saya tidak menemukannya jadi saya kira sama aja dengan boot.wim) ke dalam boot image partisi recovery.

Sederhana ya. Tapi buat saya setiap langkahnya cukup panjang. Butuh waktu 3 hari untuk melakukan ini. Itu juga karena notebook kerja saya, lelet luar biasa. Yang ternyata penyebabnya adalah di prosesor, memory dan rusaknya lan port. Saya sudah coba menggunakan port usb, tapi kecepatan maksimal hanya 6 mb/detik saja. Karena terbatasnya spec pun mempengaruhi ke kecepatan. Karena saya menggunakan virtual machine untuk melakukan modifikasi system windowsnya.

Disable deep freeze 7 without password

Published by:

OK I read many articles about disabling deep freeze ( series 7 on mine) and uninstall it without knowing the unlock password.

Here are the steps :
1. Make the system date (computer date) 10 years before or ahead.
2. boot the pc / notebook, but press F8 immediately for entering safe mode
3. In the safe mode function, we can kill the deep freeze proccess.  Enter to task manager by pressing, ctrl+alt+del then choose task manager. Click on Processes tab. Find these process : DFServ and FrzState2K.exe. End those process.
4. Erase all folder in C:\Program Files\Faronics
5. Open Registry Editor, by typing regedit in start menu. Delete all folder Faronics in HKEY_LOCAL_MACHINE\SOFTWARE\
6.Restart the computer

Don’t forget to change the date to today”s date. You should have the computer without the deepfreeze now.

Remove 20% default bandwidth for windows system

Published by:

1. Klik Start

2. Klik Run

3. Ketik gpedit.msc

4. kemudian klik Ok

5. Menuju bagian Computer Configuration. Setelah masuk klik Administrative Templates

6. kemudian Klik Network

7. setelah terbuka klik QoS Packet scheduler

8. kemudian klik Limit Reservable Bandwidth

9. Dan setelah terbuka ubah setting menjadi Enable

10. Kemudian ubah Bandwidth Limitnya menjadi 0

11. Klik Apply,ok 12. Kemudian keluar dan Restart komputer