|I haven't had to connect a CD/DVD drive to a soundcard since...1998.|
You probably didn't have to connect the DVD drive to the Audigy in your old machine; the audio was most likely being transferred through the PATA interface (ribbon cable).
So, no, you won't have to worry about connecting anything other than the SATA and power cable.
C2D performance from Socket 939:
Opty 185 @ 3.2GHz
4GB CL2 DDR400
2x 8800GTS in SLI
X-Fi Titanium Pro PCI-E