"no" - what....? no sound when you play your videos back on the camera or when the camera is connected to a TV? - then either your in camera settings are messed up (input or output volume set to 0 or something like this) or your camera is damaged.
no audio with playback in vlc? probably still be the camera's fault.
no audio in quicklook, quicktime or imovie? might be a codec-problem, try vlc first.
have you tried recording on dv-tape?
look at the sd-cards. does it say sd, sdhc or sdxc somewhere on the label? if the card has more tan 2gb it's probably a sdhc card, if it has more than 32gb it's an sdxc card. sdhc was introduced in 2006, your camcorder in 2003 - chances are good that it can't read the newer sdhc cards.