Since your 223C works via adapter then it could be one of four things:
Faulty SATA controller
Faulty SATA cable
Bad power supply
Some obscure driver conflict.
Have you had any blue screens? If yes please let us know of the error messages you get. It could be a driver conflict, but isolating the problem and identifying its causes can be pretty hard.
Have a look in Device Manager and see if there are any exclamation marks or question marks next to your SATA controller entries, this could indicate a hardware problem or a missing driver. If all is good in Device Manager, then try using brand-new, qood quality SATA cables. Also connect a different SATA DVD or hard disk on your SATA ports to see how they behave with other devices.
450Watt PSU is OK but not ideal. If you have more than one hard disk and DVD drive drawing power from the system, and a new-ish graphics card, then I’d recommend for you to have a minimum of 600W. Also the brand can make a big difference in quality, not all PSUs are created equal. I have a 600W Seasonic on an overloaded rig with 5 hard disks, 3 DVD drives and two power-hungry nVidias, and it performs very well.