You could use a 44-pin IDE cable with a extra connector and use the DVD drive as slave drive and put the jumper on the CF adapter to master and then use a 40 to 44-pin cable to connect the DVD drive

This 44-pin cable will work, ebay is full of 40 to 44 pins adapters.
http://www.vesalia.de/e_252525%5B7661%5D.htm