Sunday, March 28, 2010

mysqldump: Couldn't execute SHOW TRIGGERS LIKE

I cann't create mysqldump, and error in result
"mysqldump: Couldn't execute SHOW TRIGGERS LIKE"

Q: How to resolve mysqldump: Couldn't execute SHOW TRIGGERS LIKE error can't create/write to file 'C:\WINNT\TEMP'

A: Please access Mcafee VirusScan Console then Disable Access Protection and On-Scanner Access. Right click on properties On-Scanner Access >> All Processess >> Detection >> Exclusions >> write the folder, and check list 'Also exclude subfolders', so you can solving error mysqldump: Couldn't execute SHOW TRIGGERS LIKE error can't create/write to file 'C:\WINNT\TEMP'

Thursday, March 11, 2010

Excel to MySQL

Panduan:
http://www.automateexcel.com/2005/11/01/connect_excel_to_mysql_database/
http://apacheguide.org/myodbc.php

Tools:
download myODBC
http://dev.mysql.com/downloads/mirror.php?id=376347#mirrors

Monday, February 22, 2010

Outlook over 2GB

Outlook 2GB
http://support.microsoft.com/kb/296088

Monday, February 8, 2010

Run J2ME to iphone

http://iphoneroot.com/tutorial-install-java-on-the-iphone/
http://iphoneroot.com/java-for-iphone-iphone-3g-firmware-20-exist/
http://iphoneroot.com/tutorial-compile-and-run-java-application-on-the-iphone/
http://iphoneroot.com/tutorial-install-java-on-the-iphone/
http://blog.elektro.um.ac.id/didik/2010/01/22/iphone-emulator-for-windows/

Monday, February 1, 2010

SSL Checker

https://knowledge.verisign.com/support/ssl-certificates-support/index?page=content&id=AR1130

Setting SSL Apache

1. Copy Certificate, berikut ini menjadi file *.crt

-----BEGIN CERTIFICATE-----
MIIFxjCCBK6gAwIBAgIQL9k9yqnzZKCwLvjfOH0XezANBgkqhkiG9w0BAQUFADCB
+9jXmJstZGB1m5cE7uQg4sDdU8Z4+vjzBq7PWIXlNqDn5NFuGKlZ6pSL
-----END CERTIFICATE-----

2. Buka file httpd-ssl.conf
3. Cari file *.crt
4. Simpan File
5. Restart Apache

Thursday, January 28, 2010

Menampilkan Nama File dan Tab di VB

'Menampilkan Nama File Excel di VB
SheetName = Worksheets.Parent.Name

'Menampilkan Nama Tab Excel di VB
TabName = ActiveSheet.Name