Find lower case in case-insensitive SQL

To find lowercase values in a case insensitive database run the following query:

SELECT *
FROM Values
CONVERT(varbinary(12), UPPER(Value)) != CONVERT(varbinary(12), Value)

It converts the values to binary first before they are compared.

Posted in At the office | Leave a comment

Error 1402 Visual Studio 2008 installation

My Visual Studio installation was delete from a disk, so I tried to reinstall it.

In the middle of the installation i received an Error 1402 Could not open registery key <GUI>.

I tried to fix it manually but without success.

Try to reset the hole registry permissions with this command:

Windows 7 and Vista:

secedit /configure /cfg %windir%\inf\defltbase.inf /db defltbase.sdb /verbose

Make sure you run this command as Administrator.

Posted in Tools, Windows | Tagged , , , , | Leave a comment

IIS not showing images and CSS

The problem:

I loaded a ASP.NET application on my Windows 7 IIS 7.5 installation. The code compiled fine but..

When I opened the website http://localhost/myapp it didnt show me any images or CSS. Only text on a blank page.

The solution for me was to install the “Static Content” support for IIS.

  1. Go to  “Turn Windows features on or off”
  2. Select Internet Information Services
  3. Select World Wide Web Services
  4. And check Static Content

Hope it will help someone :-)

Posted in Programming, Tools, Windows | Tagged , , , , , | 31 Comments

Visual Studio 2008 Database edition don’t open dbproj

For some reason my VS 2008 Database edition wouldn’t open the database projets.

After i started VS with this parameters:

devenv /resetskippkgs

It worked again!

Posted in Uncategorized | Tagged , , | Leave a comment

Uitzendinggemist on your TV with DLNA

Hey people check out the following software:

http://code.google.com/p/uitzendinggemist-dlna/

It’s still in a beta, but you can use it for watching Uitzendinggemist, RTL Gemist, Net5, SBS6 and Veronica on your TV.

Paul Wagener has started the project as a Pyton script and rewrote it to Java as a plugin for  PS3 Media Server (at least build 381). I’m trying to commit good code too ;-)

Will write some more text about this later, in the meantime please test it and enjoy!


Posted in Programming, Tools | Tagged , , , , , | 2 Comments

Samsung firmware update cannot find update files

Last week I tried to update my brand new Samsung LE40b652 LCD TV.

The proccess is quite simple, download the firmware, extract to a USB-stick and load the firmware from the USB-stick.

But..

For some reason my TV didn’t find any firmware files, until I found the solutions.

If you download the firmware from the “normal” samsung support site, there is a change that the last symbol of your TV-type is not the same.

The download site of the LE40B652 only has downloads for the LE40B652T4W, but my TV is a LE40B652T4P.

There is no way to find the exact type on the normal site.

Go to:

Samsung download

Here you can select the exact type of TV you own!

Now the firmware update worked!

Update: There is new version (2007.01 @ 2010-02-28) released for the LE40B65X range. I can confirm that the normal download site didn’t work for me again but the alternative link I posted works :-)

Posted in Uncategorized | Tagged , , | 5 Comments

Internet Explorer 7 cannot update to 8

If your Internet Explorer 8 installation (upgrade from 7) fails all the time.

Run this code:

<code>

‘——————–8<———————-

Const HKLM = &H80000002

arrNeededSvcs = Array(“BITS”,”wuauserv”)

strKeyPath = “SOFTWARE\Microsoft\Windows NT\CurrentVersion\SvcHost”
strValueName = “netsvcs”

strComputer = “.”   ‘ “use “.” for local computer

Set objReg = GetObject(“winmgmts:{impersonationLevel=impersonate}!\\” & strComputer & “\root\default:StdRegProv”)

objReg.GetMultiStringValue HKLM, strKeyPath, strValueName, arrValues

‘ create string from array, easier to check for existence this way

strValues = “|” & Join(arrValues, “|”) & “|”

bolUpdateNeeded = False ‘ init value

For Each strNeededSvcs In arrNeededSvcs
If InStr(1, strValues, strNeededSvcs, vbTextCompare) = 0 Then
‘ service is not in array, add it
intArrCount = UBound(arrValues) + 1
ReDim Preserve arrValues(intArrCount)
arrValues(intArrCount) = strNeededSvcs
bolUpdateNeeded = True
End If
Next

If bolUpdateNeeded Then
objReg.SetMultiStringValue HKLM, strKeyPath, strValueName, arrValues
End If

MsgBox “Done!”, vbInformation + vbSystemModal, “Netsvcs check”

</code>

Posted in Uncategorized | Leave a comment

Cannot send SMS after restore sms.db on iPhone

If you have problems sending SMS after a manual restore of the SMS.db.

It’s properly a security-rights problem, you iPhone cannot write its outgoing messages to the database file.

Fix it this way:

Open Putty and connect to your iPhone as root (default password ‘apline’) btw you SHOULD change this for security reasons.

Run:

chown mobile -R /var/mobile/

And:

killall SpringBoard

Now all folder and files are reset to the correct settings.

Posted in Uncategorized | 10 Comments

USB Devices not installed automatically anymore

USB install problem:

http://www.runpcrun.com/cant-install-usb

http://support.microsoft.com/kb/892050

Posted in Uncategorized | Tagged , , , , , , , , | 1 Comment

Download complete website freeware

This tool is freeware and works great. It lets you save/download a complete website to your local harddisk.

http://www.httrack.com/

Posted in Tools | Tagged , , , , , , | 2 Comments