2009年7月24日 星期五

Install and Enable Remote Desktop in Windows XP Home Edition

The Terminal Service is not installed in Windows XP Edition. The trick is the service installing without OS reintsalling.

Convert and Upgrade Windows XP Home to Professional Without Reinstalling

To use Remote Desktop Service (Terminal Service) at Windows XP Home Edition, it's must be changed the edition code. Then install the service.

Tabbed Remote Desktop

A tabbed viewer with RDP(Windows Remote Desktop), VNC, ...etc, like firefox to manager multiple remote desktop simultaneously. Terminals http://www.codeplex.com/Terminals/Release/ProjectReleases.aspx?ReleaseId=21809 http://www.howtogeek.com/howto/windows/tabbed-remote-desktop-vnc-client-for-windows/ XwRDP http://xwega.com/tools/xwrdp/xwrdpimg.aspx

Tabbed Putty

A tabbed viewer like firefox to manager multiple ssh connection simultaneously. Putty Tabs: http://www.raisin.de/putty-tabs/putty-tabs.html Putty Connection Manager: http://www.howtogeek.com/howto/the-geek-blog/get-tabs-for-your-putty/

2009年7月23日 星期四

Top, HTop

How to use “top” effectively on Linux as a DBA http://coskan.wordpress.com/2008/12/22/how-to-use-top-effectivelly-on-linux-as-a-dba/ HTop http://portable.easylife.tw/1513

2009年7月21日 星期二

使用 net use 指令登入及刪除網芳帳號(適用 XP、2003)

net use \\hostname password /USER:domain\username to display list: net use

Retrieving Auto Generated Key from DB

Set oConn.Execute("INSERT INTO yourTable (field1, field2) VALUES ('Hello','World');") Set oRs = oConn.Execute("SELECT @@IDENTITY FROM yourTable") iAutoGeneratedID = oRs(0) ---- Set rs = dbCon.Execute(strSQL) Dim newID newID = rs.Fields("NewID").value

2009年7月20日 星期一

Java: How To Get Auto Increment Values After SQL Insert

// // Insert one row that will generate an AUTO INCREMENT // key in the primary key field // stmt.executeUpdate( "INSERT INTO autoIncTest (comment) " + "values ('How can I get the auto increment field value?')", Statement.RETURN_GENERATED_KEYS); // // Use Statement.getGeneratedKeys() // to retrieve the value(s) //