You need to find out what the DVD can output on scart, with yours it sounds like it could do:
-RGB
-S-video (although you said you had a separate s-video out, it sort of looks like a PC keyboard/mouse connector)
-Composite

Then you need to find out what your TV can accept as input on the AV Scart 1 and 2.

S-video on your TV will probably be accepted on one or both of your scarts, your tv manual should tell you.
Likewise, your TV may accept RGB on one or both of the scarts.

So,
-if the DVD and TV support RGB, use a scart cable and connect the cable to the appropriate AV input on the TV (best option)
-If the DVD has an s-video out, use a connector like the one you found on google, and run a good quality s-video cable from the dvd to the adaptor and plug the adaptor in either AV1 or AV2 scart, depending on what your TV supports.
You will also need to run separate audio (red and white) cables from the DVD to the TV unless you are using a home cinema amp, cos svideo cables don't carry audio (not so good option).
-If the DVD has s-video out on the SCART connector, run a scart from DVD to TV AV input which supports s-video on SCART. This will carry both audio and video and is slightly worse than above because SCART cables are not usually very good (unless you pay a fortune for them).

Whatever you do, if you end up buying cables, make sure you can return them if it don't work I'd hate for you to spend money and find it makes no difference or doesn't work. Trust your eyes, not anyone's advice. As long as you're happy, that's the main thing.

Jeez - This is really difficult to explain in text, and that's not a reflection on you thrush, it should be easy but for some reason I find it difficult