Sony HDD? Is this a Sony high definition camcorder?
If the video is in high definition format, stand alone dvd players usually cannot play them. Maximum resolution for the vast majority of dvd players is 720 x 576 (PAL) standard, or 720 x 480 (NTSC).
A blu ray player might be able to play them, depending on the format of the video and the resolution. AVCHD is one type of high definition video from camcorders, but not all blu ray players support it.
If this is from a hard drive on a dvd recorder, that is an entirely different problem. You may not have finalized the disk and will need to do so in the original machine. Or get ISOBuster and extract the video from the disk to the hard driver of your computer.