Your motherboard has a first generation VIA SATA 1 RAID controller. Even if you are not planning to configure the drives as a RAID array, you often had to set a RAID configuration in order to use the drive.
For starters, you do not connect the standard 4 pin Molex connector to power a SATA drive. You need to have a SATA power connection or use a Molex to SATA power adapter. You can use any of the Molex power connectors as they are all the same.
If your new drive is a SATA 2 drive (300), you will need to set the jumper that restricts the speed for use with a SATA 1 controller.
As to seeing your drives in BIOS settings, that is a bit tricky. Just after the normal POST, there should be a screen that pops up and lists your SATA drives along with instructions to press the TAB key to enter "User Window". This is where you set up and configure your SATA drives.
If memory serves me well, you need to configure each drive as a single disk RAID array with this VIA controller. Read the SATA RAID section of the manual and follow the instructions in detail.
Your boot drive needs to be connected to the SATA1 connection which is the one closest to the edge of the motherboard.
As to what happened on your first try, here are my thoughts:
The POST lock-up was caused by either a lack of proper power to the new drive, or that it needed the speed restriction jumper set. The RAID BIOS also might have had trouble booting with an unconfigured drive.
The boot problem you now have suggests that the RAID configuration for your existing drive was modified or damaged by the BIOS when you attempted to install the new drive.
CAUTION: Any changes to the RAID configuration of your existing drive MAY cause ALL DATA and PROGRAM files to be ERASED!
See if you can press F8 and boot into safe mode. If you can boot into safe mode, Windows may correct the configuration and driver issues on it's own. If you cannot boot into safe mode, your best option is to install your boot drive in a portable enclosure and make a full backup before attempting to correct the RAID configuration in the RAID BIOS setup.
Keep us posted, and make sure you understand what you are doing before attempting any repairs. The data you save may be your own.
If anyone else has some good advice to offer for recovering the RAID configuration, PLEASE chime in.
Chas