ailon's DevBlog: Development related stuff in my life

TortoiseSVN installation

10/23/2007 9:52:44 AM

For quite some time TortoiseSVN was shouting that I have to upgrade my installation cause I used a version which apparently had a security hole. After refusing to comply for some time I finally gave up. I've downloaded and installed version TortoiseSVN 1.4.5, Build 10425 which to my surprise, among other apps, required that I "exit" Windows Explorer!

I've killed all the "reasonable" applications it required but refused to do the same with Explorer and hit "Ignore". After the reboot TortoiseSVN couldn't launch stating (or was it Windows?) that "The application has failed to start because its side-by-side configuration is incorrect."

I needed to work with SVN badly, so I ran tortoise's installer again and ordered it to repair my installation. No surprise it asked again that I kill Windows Explorer. This time I complied (no matter how crazy this might seem) and it went "smoothly". I wonder when my whole system is going to crash...

I wonder if this is Vista-only issue or everyone has to kill Windows Explorer to install TortoiseSVN? Sounds completely nuts to me.

Tags: , , ,

ON DELETE SET NULL

10/13/2007 4:44:12 PM

I've just discovered the existence of SET NULL option for ON DELETE/ON UPDATE clauses in Oracle. Yes, I'm stupid. No idea in which version this first appeared but there's still no way to set this through GUI in Enterprise Manager Console (as far as I know). However you can set this through code or via GUI in Oracle SQL Developer.

This could be very handy when you have some columns referencing other tables but the data in this columns is of not critical importance. For instance you may have user id of the person who last edited some article stored in the table but if you delete the user (and you are sure about this) you don't want that value preventing your operation. Earlier I just didn't create foreign key on such fields, resulting in ghost values. Now I can just add ON DELETE SET NULL to foreign key declaration and the problem is solved.

Btw, this is also available in MS SQL Server 2005 (not in 2000) along with SET DEFAULT. I can hardly think what is the possible use for SET DEFAULT. Hard-coding the value for referenced field!? Doesn't sound very useful to me. But who am I? If it's there then probably someone needs it.

Tags: , , ,

You Snooze, You Loose

10/13/2007 7:28:00 AM

It looks like someone has released almost exact "clone" of what was supposed to be my first Windows Mobile application. I'll have to come up with some other idea for practicing WM development.

Tags:

Windows Vista SideShow + Windows Mobile 6 = No Love

10/12/2007 10:42:04 AM

Sometimes I kind of don't understand Microsoft. Windows Vista was released like a year ago and Windows Mobile 6 was released this year and still there's no support for SideShow in WM6. And what is the first device that comes to mind as Vista PC companion device? If asked this question in the middle of the night I would immediately answer - PocketPC.

I would really like to have WMP "Now playing" information and controls on my HTC Touch docked next to my main monitor. And you can probably think of more useful applications.

Do divisions at Microsoft actually talk to each other?

kick it on DotNetKicks.com

Tags: , , ,

Consolas

10/8/2007 8:10:08 PM

consolas I'm very slow on customizing my environment. I can do things the hard way for months before I force myself to make a small tweak that makes life much easier. No wonder I used Visual Studio (and PSPad for that matter) with default "Courier New" font and didn't even know that Vista comes with a special monospace, ClearType fine-tuned font family called Consolas. You can download it for XP, too.

Hopefully this will make the long development hours ahead a little bit easier on my eyes.

You can find samples and download links for other popular "developer fonts" through this article.

Tags: , , ,

If It Ain't Broke, Don't Fix It

10/8/2007 11:01:54 AM

The telling is as true as ever. Update to Windows Mobile Device Center was hanging for some time in optional Windows Vista Updates on my computer and I finally decided to install it this weekend. Installation went smoothly but this morning I found out that my HTC Touch couldn't connect to computer or vice versa. And there was an error in Application Event Log saying: "Windows Mobile-based USB device is plugged in but is unable to make a network connection to the desktop."

I tried many things including rebooting both phone and computer, dropping the partnership, plugging device to a different port, enabling and disabling firewalls, etc. Finally I decided that it was about time to google. After several unhelpful links I found this thread in Microsoft's forums and this post in particular saying:

Settings - Connections - Usb to PC - uncheck the "Enable advanced network functionality".  Disconnect device and connect back up.  Recognized it immediately

I didn't even have to unplug the device. It was recognized immediately and everything (as far as I noticed) started working. No idea, though, what functionality I lost disabling that "advanced network functionality". Go figure...

Tags: , , ,

Oracle's Enterprise Manager Disables Vista's Aero

10/7/2007 2:17:52 PM

I'm currently working on a project which uses Oracle 10g DBMS. So, naturally I've downloaded Oracle 10g Client for Vista (why this is a separate 600mb download from "standard" Win32 version is another story). Installation went smoothly but then, when I started Oracle's Enterprise Manager my screen flickered and shiny Aero Glass interface disappeared. I've closed EM and Aero reappeared. Opened - disappeared, closed - reappeared.

Long story short: I've narrowed the problem down to old JRE (java runtime) version which was included in Oracle's client for Vista (which is a separate 600mb+ download from standard Win32 client for XP, Win2000, etc.). And the ugliest thing is that even though I have the latest version of JRE on my machine Oracle insists on using it's "own" (excerpt from their oemapp.bat file: "REM Make sure that our JRE is used for this invocation").

So, I just took the latest JRE installation and forcefully installed it into Oracle's JRE directory (oracle\product\10.2.0\client_1\jdk\jre\). Voila. Aero is saved, EM seems to work (don't blame me if doesn't). "Only" 2 hours wasted.

Some useful links:

Tags: , , , ,

Hi...

10/7/2007 1:44:55 PM

There are some things that I want to write down so I can revisit/reapply them later and which don't fit into my personal blog. These things aren't always appropriate for my company's developer blog too. So, after some thinking and considerations, I decided to launch this one.

I'll be writing here about .NET, PHP, JavaScript, HTML, Windows Mobile, databases, developer tools and similar stuff most of the time. I know some things about these areas but often have to concentrate on one technology and then, sometimes after several years, revisit the other one. And sometimes I have to learn what I already knew a year ago the hard way. So, this is what this blog is about - my personal quick reference/notebook.

Tags:

Copyright © 2003 - 2017 Alan Mendelevich
Powered by BlogEngine.NET 2.5.0.6