I want to clear my doubt as to whether I can connect my PC to my TV. My graphics card supports DVI-I and VGA. I want to connect it to my 29" Sony FD Trinitron Wega KVEF29M80 using a DVI-to-RCA cable. To which port do I connect for the TV?
From what I found for "DVI to RCA cable", it looks like you would be getting component video not composite. Component video connections look like this:
There are 3 plugs. Composite video is a single yellow cable typically. Your TV would need to have the component plugs on it in order to do what you are wanting.
If you need composite I would look into a VGA to composite or VGA to S-Video cable, they are readily available and either one should work for your setup.