Which ASUS motherboard are you using? Which SATA socket are you using for the CD-ROM drive?
On some ASUS motherboards there are 8 SATA sockets, but 2 of them cannot be used for ATAPI devices like optical drives - they are only usable for hard drives. It's possible that you plugged the optical drive into one of those.