Since Vista Ultimate couldn't install the driver automatically successfully I got onto Leadtek's support page for the driver download. Downloaded the "Vista 32 Bit" driver since my computer's x86. Then I went into Device Manager and right clicked on the "Unknown Device" and selected "Update Driver", then I chose to locate the driver location myself which is the decompressed folder location.
Funny enough, though the right version and location etc. Vista just wouldn't install it. Therefore in Media Center "no TV Tuner Hardware is found". I'm really gutted about this and hope I can get some help soon.