Monthly Archives: May 2010

Retrieve money data from PostgreSQL via ODBC API

The behaviour of money type in PostgreSQL is weird. SQLDescribeCol reports the type as SQL_FLOAT, ColumnSize is 7, but SQLGetData always get 0.0 if I am trying to use type SQL_C_FLOAT, SQL_C_DOUBLE or SQL_ARD_TYPE. At last I am able to … Continue reading

Posted in Database | Leave a comment

find out which process locked a file

There are several tools for this purpose. Unlocker is a GUI tool and I like the portable version. Handle.exe By Mark Russinovich is a command line tool. c:\tools\handle -p notepad.exe | grep O-Drive c:\tools\handle -a | grep O-Drive c:\tools\handle -a | grep … Continue reading

Posted in debug | Leave a comment

Pidgin and Chinese in MSN conversations

By default Pidgin does not display Chinese in MSN conversations correction, offline log file is using " font-family: Segoe UI" for incoming messages.Pidgin "View Log" does not display chinese correctly. Solution:change file C:\Program Files\Common Files\GTK\2.0\etc\gtk-2.0\gtkrcgtk-font-name = “SimSun 9″Run C:\Program Files\Common … Continue reading

Posted in Computers and Internet | Leave a comment

PostgreSQL

ODBC driver performance on large result-setsAccessing PostgreSQL in C/C++VC++ access PostgreSQL via ODBC Performance Tuning PostgreSQL install unixodbc-dev or libiodbc2-dev and iodbc via synapticUpdate /etc/odbcinst.ini [PostgreSQLW]Description        = PostgreSQL ODBC driverDriver        = /opt/PostgreSQL/psqlODBC/lib/psqlodbcw.soSetup        = /usr/lib/odbc/libodbcpsqlS.soUsageCount    = 1 [PostgreSQLA]Description   … Continue reading

Posted in Database | Leave a comment

Comparison of different SQL implementations

Comparison of different SQL implementations What are the limitations of MSDE?Compare SQL Server 2008 Edition Features Oracle Database 10g Express EditionLimitations of Oracle Database 10g Express Edition MS SQL is using filegroups. Tablespace is used by MySQL, PostgreSQL and Oracle. … Continue reading

Posted in Database | Leave a comment

Novels

江山美色 小说作者: 墨武 极品家丁 小说作者: 禹岩恶魔法则 小说作者: 跳舞飞升之后 小说作者: 皇甫奇我为纣王之傲啸封神 小说作者: 点精灵随波逐流之一代军师 小说作者: 随波逐流阳神 小说作者: 梦入神机好像有的温瑞安的风格刺客魔传 小说作者: 撞破南墙 凡人修仙传 小说作者: 忘语紫府仙缘 小说作者: 百里玺 武神 小说作者: 苍天白鹤混乱战神 小说作者: 撞破南墙仙葫 小说作者: 流浪的蛤蟆仙逆 小说作者: 耳根命运天盘 小说作者: 水平面官居一品 小说作者: 三戒大师证魂道 小说作者: 三月梦溪无上真魔 小说作者: 皇甫奇金庸世界里的道士 … Continue reading

Posted in Books | Leave a comment