Instal Windows dari Flashdisk

  1. Download dan instal WinSetupFromUSB
  2. Jalankan WinSetupFromUSB Image
  3. Pada bagian Windows 2000/XP/2003 source klik Browse, pilih drive tempat CD/file Setup Windows berada (dalam contoh CD Windows XP terdapat di drive D)
  4. Pada bagian USB Disk Selection, pilih target USB Flashdisk (dalam contoh di USB Flashdisk terdapat di drive H)
  5. Klik RMPrepUSB (untuk menformat Flashdisk) Image
  6. Pilih USB Flashdisk Drive (dalam contoh USB Flashdisk Drive terdapat di drive H)
  7. Pada bagian Filesystem & Overrides, pilih Filesystem FAT32
  8. Pada bagian Boot Option pilih XP Bootable (NTLDR)
  9. Klik Prepare Drive
  10. Setelah format selesai klik Exit
  11. Klik GO
  12. Tunggu sampai proses copy windows ke flashdisk selesai
  13. Pindahkan Flashdisk ke PC yang akan diinstal Windows
  14. Boot dengan Flashdisk
  15. Ikuti proses sampai boot ke-2
  16. Pada boot ke-2, usahakan masih boot dengan Flashdisk jika tidak biasanya akan timbul error
  17. Jika lancar, akan muncul Windows Setup, lanjutkan instalasi Windows seperti biasa


Note : Baru di coba untuk instalasi Windows XP


Leave a comment »

Acer Altos G540 Disk I/O Error

This is shame story for me.

2 weeks ago our server had an error, when i turn on the server there is message in monitor “Disk I/O Error”.
The first thing that came up to my mind that it’s must be related to harddisk, which i hove not, because the importance of the data.

I look at the harddisk, there is 2, it must be configured with Raid 0, so i pull out one of then and turn on server again, but the error still happen.

I called my friend, he said maybe the problem is in I/O Controller. I don’t have other server to test, so i brought it to Acer Service Center.

They need 2 weeks to check the problem, because my unit serial number not registered to they system, so they have to find it.

And today i have call from Acer technician, and he told me that my unit is done and the problem is really simple, there is floppydisk in my floopydrive that prevent my system to startup, because of damage floppydisk. The startup first check boot floppydrive, cdrom and then harddisk in sequence. When they remove the floppydisk the problem is gone.

It’s so simple, and i don’t know it. very shame of me 🙂


Leave a comment »

Strong name signature not valid for this assembly stdole.dll

I have problem when i want to publish my program regarding with stdole.dll

My program using excel interop and deploy with ClickOnce, and when i install, it come error and when i open install log i found this error message

* Activation of N:\mySystem\Publish\myApp.application resulted in exception. Following failure messages were detected:
+ Strong name signature not valid for this assembly stdole.dll.

So like i usually do, i looking for the answer in google, and i the solution :

1. Open path “C:\Program Files (x86)\Microsoft Visual Studio 9.0\Visual Studio Tools for Office\PIA\Office11” and “C:\Program Files (x86)\Microsoft Visual Studio 9.0\Visual Studio Tools for Office\PIA\Office12”, there is file stdole.dll wich was 16kb large and not signed

2. Open the path “C:\Program Files (x86)\Microsoft.NET\Primary Interop Assemblies”, there is file stdole.dll wich was 25kb large and signed

3. Replaced the unsigned dlls with the signed ones and did another publish

And the problem is gone.

Original source

3. Opened the path “C:\Program Files (x86)\Microsoft.NET\Primary Interop Assemblies” where i found the stdole.dll wich was 25kb large and signed
4. I replaced the unsigned dlls with the signed ones and did another publish and it worked.
1 Comment »

Restore MySQL dari ibdata file

Langkah merestore data dari ibdata file sbb :
1. Buka Command Prompt
2. Stop MySQL service
c:\Program Files\MySQL\MySQL Server X.X\bin>mysqladmin -u root -p shutdown
Jika account root tidak mempunyai password cukup hilangkan option -p
3. Backup file-file di folder C:\ProgramData\MySQL\MySQL Server X.X\data (Windows7 untuk versi windows lain silakan disesuaikan)
4. Copy file-file ibdata1, ib_logfile, .frm yang akan direstore ke folder C:\ProgramData\MySQL\MySQL Server X.X\data
5. Start MySQL service dengan option sebagai berikut
c:\Program Files\MySQL\MySQL Server X.X\bin>mysqld –standalone –console –innodb-force-recovery=4
Untuk MySQL versi 5.0 gunakan perintah mysqld-nt
6. Backup database
7. Stop kembali MySQL service seperti langkah nomor 2
8. Start MySQL service
c:\Program Files\MySQL\MySQL Server X.X\mysqld
Untuk MySQL versi 5.0 gunakan perintah mysqld-nt -u root
9. Restore database

Leave a comment »

MySQL Select Case

Sintaks :

CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result …] [ELSE result] END

Contoh :

CASE bulan when “01” then “Januari”
when “02” then “Februari”
when “03” then “Maret”
when “04” then “April”
when “05” then “Mei”
when “06” then “Juni”
when “07” then “Juli”
when “08” then “Agustus”
when “09” then “September”
when “10” then “Oktober”
when “11” then “November”
when “12” then “Desember”
from kalender where tahun = “2005” order by bulan

Leave a comment »