The 'Ultra DMA' interface is capable of connecting to EIDE drives with an 80-line cable. The Promise card is capable of supporting three cables, and of co-existing with the mainboard adaptor. You can also use the ATAPI adaptor on your MB, for another two (or more, on some MBs) cables. Each cable supports 2 drives.
Connect the newer 'high speed' drives to the UDMA, 'Ultra', or EIDE ports with 80 line cables. Connect CDROMs, older HDs (UDMA 0, 1, or 2 and PIO-only), and cartridge drives (IDE ZIP, JAZ, Orb, SyQuest, and 3M LS) to the non-ultra channels (or to backward-compatible extra ultra channels) with 40-line cables. Connect DVD drives to either Ultra channels with 80 line cables or to non-Ultra with 40 line cables.