作業系統: Windows 7
讀卡機: EZ100PU幸運草
驅動程式: http://www.ittec.com.tw/download.htm
程序: 郵局WebATM轉帳

問題:
使用Windows 7 後, 每次在轉帳時都要您將晶片卡拔除再插入, 但插入後卻無法成功轉帳. 出現的錯誤訊息: "請檢查晶片卡是否正確插入…". 其實問題是出在Windows 7針對讀卡機的其中一項服務. 將此服務停用後, 重開機問題就解決了.

Step1:
1

Step2: 將Certificate Propagation服務停用
pic2

Step3: 重開機

很多時候我們在下SQL語言時出錯卻一直找不出原因, 很多時候是因為在MYSQL內的COLUMN使用了reserved word 而造成的. 以下為MYSQL 的reserved word, 如果你在命名table.column時就要儘可能避開使用這些保留變數了.

ACCESSIBLE 	ADD 	ALL
ALTER 	ANALYZE 	AND
AS 	ASC 	ASENSITIVE
BEFORE 	BETWEEN 	BIGINT
BINARY 	BLOB 	BOTH
BY 	CALL 	CASCADE
CASE 	CHANGE 	CHAR
CHARACTER 	CHECK 	COLLATE
COLUMN 	CONDITION 	CONSTRAINT
CONTINUE 	CONVERT 	CREATE
CROSS 	CURRENT_DATE 	CURRENT_TIME
CURRENT_TIMESTAMP 	CURRENT_USER 	CURSOR
DATABASE 	DATABASES 	DAY_HOUR
DAY_MICROSECOND 	DAY_MINUTE 	DAY_SECOND
DEC 	DECIMAL 	DECLARE
DEFAULT 	DELAYED 	DELETE
DESC 	DESCRIBE 	DETERMINISTIC
DISTINCT 	DISTINCTROW 	DIV
DOUBLE 	DROP 	DUAL
EACH 	ELSE 	ELSEIF
ENCLOSED 	ESCAPED 	EXISTS
EXIT 	EXPLAIN 	FALSE
FETCH 	FLOAT 	FLOAT4
FLOAT8 	FOR 	FORCE
FOREIGN 	FROM 	FULLTEXT
GRANT 	GROUP 	HAVING
HIGH_PRIORITY 	HOUR_MICROSECOND 	HOUR_MINUTE
HOUR_SECOND 	IF 	IGNORE
IN 	INDEX 	INFILE
INNER 	INOUT 	INSENSITIVE
INSERT 	INT 	INT1
INT2 	INT3 	INT4
INT8 	INTEGER 	INTERVAL
INTO 	IS 	ITERATE
JOIN 	KEY 	KEYS
KILL 	LEADING 	LEAVE
LEFT 	LIKE 	LIMIT
LINEAR 	LINES 	LOAD
LOCALTIME 	LOCALTIMESTAMP 	LOCK
LONG 	LONGBLOB 	LONGTEXT
LOOP 	LOW_PRIORITY 	MASTER_SSL_VERIFY_SERVER_CERT
MATCH 	MEDIUMBLOB 	MEDIUMINT
MEDIUMTEXT 	MIDDLEINT 	MINUTE_MICROSECOND
MINUTE_SECOND 	MOD 	MODIFIES
NATURAL 	NOT 	NO_WRITE_TO_BINLOG
NULL 	NUMERIC 	ON
OPTIMIZE 	OPTION 	OPTIONALLY
OR 	ORDER 	OUT
OUTER 	OUTFILE 	PRECISION
PRIMARY 	PROCEDURE 	PURGE
RANGE 	READ 	READS
READ_WRITE 	REAL 	REFERENCES
REGEXP 	RELEASE 	RENAME
REPEAT 	REPLACE 	REQUIRE
RESTRICT 	RETURN 	REVOKE
RIGHT 	RLIKE 	SCHEMA
SCHEMAS 	SECOND_MICROSECOND 	SELECT
SENSITIVE 	SEPARATOR 	SET
SHOW 	SMALLINT 	SPATIAL
SPECIFIC 	SQL 	SQLEXCEPTION
SQLSTATE 	SQLWARNING 	SQL_BIG_RESULT
SQL_CALC_FOUND_ROWS 	SQL_SMALL_RESULT 	SSL
STARTING 	STRAIGHT_JOIN 	TABLE
TERMINATED 	THEN 	TINYBLOB
TINYINT 	TINYTEXT 	TO
TRAILING 	TRIGGER 	TRUE
UNDO 	UNION 	UNIQUE
UNLOCK 	UNSIGNED 	UPDATE
USAGE 	USE 	USING
UTC_DATE 	UTC_TIME 	UTC_TIMESTAMP
VALUES 	VARBINARY 	VARCHAR
VARCHARACTER 	VARYING 	WHEN
WHERE 	WHILE 	WITH
WRITE 	XOR 	YEAR_MONTH
ZEROFILL

The following are new reserved words in MySQL 5.1:

ACCESSIBLE 	LINEAR 	MASTER_SSL_VERIFY_SERVER_CERT
RANGE 	READ_ONLY 	READ_WRITE

參考資料: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

購買新的Lenovo G450, 卻發現其提供的DRIVER只是FOR VISTA only,
若您要安裝XP的驅動程式, 可以使用以下的懶人包連結:

其中要注意的是AUDIO DRIVER的部分要先下載Microsoft UAA再安裝音效卡才會成功.

Microsoft UAA Bus Driver for high Definition Audio 下載網址:
http://america.giga-byte.com/FileList/Driver/motherboard_driver_audio_realtek_azalia.exe

順便附上Microsoft Install 3.1的下載連結:
http://www.microsoft.com/downloads/details.aspx?displaylang=zh-tw&FamilyID=889482FC-5F56-4A38-B838-DE776FD4138C

Lenovo G450 Chipset Driver
Intel Chipset driver 9.0.0.1011

Lenovo G450 Sound Audio Driver
Conexant Audio Driver 3.66.9.50

Lenovo G450 Graphics Video VGA Driver (Intel)
Intel Onboard Graphics Driver 6.14.10.5002

Lenovo G450 Graphics Video VGA Driver (NVIDIA)
NVIDIA Display Driver 6.14.11.8611

Lenovo G450 Ethernet LAN Network Driver
Broadcom Ethernet Driver 11.7.2.0

Lenovo G450 Wireless LAN WLAN Driver (Broadcom)
Broadcom Wireless LAN Driver 5.10.38.14

Lenovo G450 Wireless LAN Driver (Intel)
Intel Wireless WiFi Link Driver 12.2.0.11

Lenovo G450 Bluetooth Driver
Broadcom Bluetooth Driver 5.1.0.5400

Lenovo G450 Webcam Camera Driver
Lenovo Easy Camera Driver 6.32.1018.17/ 5.8.50.6/5.8.0.8

Lenovo G450 Card Reader Driver
Realtek USB 2.0 Card Reader Driver 6.0.6000.75

Lenovo G450 Energy Management Driver
Lenovo Energy Management Driver 3.0.3.0

Intel Matrix Storage Manager Driver 8.8.0.1009

Lenovo G450 Touchpad Driver
Alps Pointing-device Driver 7.2.1602.309

要處理Bruker儀器所產生DATA, 須要通過第三方軟體來轉換成ASCII CODE
Bruker 軟體產生的 Analysis.baf 沒辦法用 ncdump.exe 來處理,
只能用Bruker自行開發的免費軟體CompassXport, 轉換成 mzXML格式,
一般上mzXML就可以拿到R 或其他程式處理(因為是明碼)
步驟如下:
1. http://www.brukerdaltonics.com, 註冊Bruker帳號, 登入
2. Service & Support, Download
3. 下載CompassXport
使用方法請參考以下連接, 以及官方的FAQ說明書

參考資料:

http://www.ms-utils.org/wiki/pmwiki.php/Main/SoftwareList

http://www.ionsource.com/functional_reviews/CompassXport/CompassXport.htm

環境: PHP4 + Apache4 + Windows
函數: iconv (http://tw.php.net/iconv)

最近有幫舊電腦寫程式,
發現PHP4預設不支援iconv, 先別擔心升級PHP5所帶來的其他風險,
其實是有辦法可以在PHP4下解決的:

1. 在C:\php\dll 底下有個 php_iconv.dll
2. 將此DLL放到 c:\Windows\system32\ 底下
3. 在C:\php\php.ini 將 extension 下的 php_iconv.dll Uncomment掉(把分號拿掉)
4. 重新啟動Apache.
5. It works!