Hello FraserD,
Consumer grade video camcorders don't typically follow the industrial DCAM spec that the NI-IMAQ for IEEE-1394 driver requires. You may have some more success with the new NI-IMAQ for USB driver. Even though the name may be a little misleading since the driver can work with more than just USB imagting devices, it will work with any device that provides a DirectShow filter, which is common among consumer grade devices. I would recommend making sure your Sony CamCorder driver is installed correctly (i.e. you can acquire video using their software), and then install the NI-IMAQ for USB driver:
http://sine.ni.com/apps/we/niepd_web_display.display_epd4?p_guid=ED6942DF78E34659E034080020E74861&p_node=DZ52490&p_source=External
This will install LabVIEW VIs, and Vision Assistant plugin. I haven't ever tried this with a camcorder, but let me know how this works for you.
Thanks,
Brad