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"

Monday, March 2, 2009

vmware 6.5 for linux keyboard error

echo 'xkeymap.nokeycodeMap = true' > ~/.vmware/config