Wednesday, December 19, 2007
Wednesday, December 5, 2007
I think this introduction of new data type is to help to re-construct the records back to hierarchical view easily (remember the "Using APPLY" sample that need to call the function recursively ?). With the syntax like GetAncestor(), GetDescendant(), IsDescendant() , etc, you can discover the level of the records easily (why it seems gearing towards CLR coding??).
There're few articles with samples:
The CTP version of MS SQL 2008 can be downloaded from here.
Friday, November 23, 2007
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
But those PCs which have both MS SQL 2000 & MS SQL Express 2005 and the default instance is MS SQL 2000, it still hits the error message when I try to connect to MS SQL Express 2005:
SQL Server does not exist or access denied.
3) Double-click the "TCP/IP", under the "IP Addresses", find the "TCP Dynamic Ports".
Thursday, November 22, 2007
Anyway, I MUST continue to come out new application.
Wednesday, November 14, 2007
Monday, November 5, 2007
And even better, you can take the screenshot at any point, and make it as your wallpaper.
Here's the one I made:
Thursday, October 25, 2007
p/s: My monitor have sent to repair, due to roof leaking. Got to post this blog using company's PC. Also not so free to develop new program or enhance existing article, sigh!
Wednesday, September 26, 2007
2) Save the current state
7) Draw the minute-hand (or any hands left) at new origin, new orientation
9) Rotate the new graphics objects
Tuesday, September 18, 2007
Plan B: Start by developing a killer ap. If you can't think of one, don't worry - simply write a copy of an existing piece of software. It doesn't even have to do anything. When people point out that your product is rubbish, issue a press release blaming Microsoft for refusing to give you its proprietary code for free.
If you persevere for long enough, you may even convince the European Union that your product would be a world beater if only those bastards at Microsoft would give you the code to make it work properly.
Monday, September 17, 2007
With the QEMU processor emulator, anyone one can write & test OS written. Start from doc here and here, now. I wish i could do it now, but not yet master ASP.NET, NET Framework, NET CF, ... , to name a few. OMG.
Sunday, September 16, 2007
Tuesday, September 11, 2007
Actually, SQL CE database upgrade is briefly discussed in BOL (Book On-Line). And this blog is just to fill the missing link.
Normally, You can create a brand new application to use .NET CF 2.0 & SQL CE 3.0. Then what's the big deal about the SQL CE database upgrade, you might ask. Well,What you actually face in real-life situation is you are .NET CF 1.0 & SQL CE 2.0 application developer. Due to performance issue (SqlCeResultSet Class) or new functionality that only available in SQL CE 3.0, you need to meet the new requirement yet need to maintain the records that already keep in existing SQL CE 2.0 database. You do not want to create a new SQL CE 3.0 database and import back all the records, ain't you? Then, this is where SQL CE database upgrade comes in.
How will one know the database file (*.sdf) is not workable in SQL CE 3.0 ? Simple, open it from MSSQL Management Studio (Sorry, you need full version to run it). If you see this message, clearly you need to upgrade your database.
Now I will show you how to upgrade it within the emulator environment, specifically for OS PPC 2003. It can be done in actual device in the similar way. First, copy all the cabinet files of SQL CE run-time components for SQL CE 2.0 and 3.0 into you emulator, using Windows CE Remote File Viewer. The default location of the SQL CE 2.0 run-time components is C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v2.0\[platform]\[processor] & the default location of the SQL CE 3.0 run-time components is
Then you need to download the Pocket Shell in Windows Mobile Developer Power Toys. It is the PPC version of you desktop command prompt. The default location is in C:\Program Files\Windows Mobile Developer Power Toys\PPC_Command_Shell\arm. Copy the console.dll to emulator's \WINDOWS directory and copy the shell to emulator root folder for less programming later.
So now you should have 5 cabinet files(sqlce20.dev.ppc.wce4.armv4.cab, sqlce20.ppc.wce4.armv4.cab, sqlce30.dev.ENU.ppc.wce4.armv4.cab, sqlce30.dev.ppc.wce4.armv4.cab, sqlce30.rep.ppc.wce4.armv4.cab), 3 executable files (upgrade.exe, cmd.exe & shell.exe from Power Toy) and one SQL CE 2.0 database (oldDB.sdf). Install all the 5 cabinet files & click on the cmd.exe to run it. You will be prompt to enter command.
Type something like: upgrade.exe /s oldDB.sdf /d newDB.sdf
viola! (You need to wait a while if your database is huge)
If you have missed any cabinet file during installation (eg. you did not install "sqlce30.rep.ppc.wce4.armv4.cab"), you will get this error message:Try to export the upgrade.log file to analyze:
In this case, you will get:
HRESULT: 0x80040154Database upgrade failed