Thursday, May 21, 2009

备忘录

UTSTARCOM D60模式切换: *20030811#
联通宽带:m156b00100163@gz.unicom/055000

Thursday, April 23, 2009

ORACLE INSTANT CLIENT for LINUX

1. download instantclient from oracle website;
2. extract downloaded files to a directory. ex. /opt/oracle/
3. open .bash_profile add the following codes to the end

# ORACLE ENVIRONMENT SETTINGS.
ORACLE_HOME=/media/software/java/instantclient_11_1
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
TNS_ADMIN=$ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME

export ORACLE_HOME TNS_ADMIN NLS_LANG LD_LIBRARY_PATH

4. re-login.

Tuesday, March 31, 2009

import data from ACCESS/EXCEL to SQLSERVER

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
ACCESS:
select * from openrowset('Microsoft.Jet.OLEDB.4.0',
'd:\orgmst.mdb';'ADMIN';'','SELECT * FROM org_mst')

EXCEL:
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
'Excel 8.0;hdr=yes;database=D:\orgmst.xls',ORG_MST$)

Friday, March 13, 2009

java swing (eg: ORACLE SQL Developer)中汉字显示方块的解决办法

1, 在jre的 lib/fonts 目录创建一个 fallback目录
2, 将windows的字体文件复制到这个新建的目录下

Tuesday, March 10, 2009

解决 在 xfce 中有些软件无法使用 ibus输入问题

在 .bash_profile 中加入
GTK_IM_MODULE=ibus
export GTK_IM_MODULE

Friday, March 6, 2009

wine 下中文字体的关键设置

在E文LINUX, 加 WINE 环境下,运行需要使用中文的软件时,
需要将 LANG设置成zh_CN.UTF-8
例如运行 powerdesigner.
将:
env WINEPREFIX="/home/username/.wine" wine "C:\Program Files\Sybase\PowerDesigner 12\pdshell12.exe"
改成:
env LANG=zh_CN.UTF-8 WINEPREFIX="/home/username/.wine" wine "C:\Program Files\Sybase\PowerDesigner 12\pdshell12.exe"

中文问题就解决了

更改字体大小:

[System\\CurrentControlSet\\Hardware Profiles\\Current\\Software\\Fonts]
"LogPixels"=dword:00000070

Thursday, March 5, 2009

download full size Intenet Explorer 6

ie6setup.exe /c:"ie6wzd.exe /d /s:""#E"