S-Video is analog and I believe it's specifications is 480i. It is possible to max it out to 1024 x 768 but it depends on the TV's integrated electronic which will determine how well the image will be displayed.
I don't know how it will look on an HDTV 'cause I don't own one yet.
S video is quite low res - it won't even approach true HD resolutions.
Thats what I think but since it is a 9pin s-video and I'm using a s-video -> component adapter, I hoped it would support more than the old school 4pin s-video does.
Don't know what you are willing to spend on cables, but check out "monoprice.com". DVI or HDMI run about $1 a foot there. I doubt you will find them cheaper.
thanks Turk, I'll get a HDMI from there.