Adam is dead on with what he is saying.
I think first of all: Hope you didn't spend to much on the S-Video cabling. It should not have been more than a FEW DOLLARS at most. If you paid $20 or more for the cables, return them ASAP and go with some quality inexpensive cables which will work just as well.
Now, what you must do (most likely) is hook up S-video from your DVD player to the receiver. Then hook S-video from your receiver up to your display. This way, you maintain S-video from the start to the end. With the date of the gear (2003) and the brand (RCA) I would bet that this is an extremely limited feature A/V receiver and only handles very basic video switching. So, this would be the proper and only way to make an S-Video connection. (no HD for you!)
Now, once everything is connected as described above, you turn everything on and must put your TV on the S-video input.
If your TV does not have an S-Video input, then it is pointless connecting your gear via S-video.
In my experience, there is no visible difference to the average viewer, with normal video content, between s-video and composite video so it's a silly connection to use anyway.