Well the first and foremost thing is to get a working CD drive. You could then run system restore or reinstall the OS, you would lose nothing by reinstalling. Either way you will need a CD drive. In the meantime turn off computer for an hour or so and try again, if it works try and secure your data the HD is going bad (you probably tried this already), next unplug the hard drive power and data (ribbon) cables and re-plug them back in. This acertains fidelity in the connections. If you have an extra IDE cable lying around, try that also. Turn on and go to BIOS setup and see if the drive is recognized there. The most common way is DEL key when you first see the sony logo on the screen but I am not sure if sony uses that key maybe F10 or F12. It is possible the hard disk's active partition has changed. To resolve this, perform the following steps:
Boot your machine using a Windows Me, Windows 9x, or DOS 3.5" system disk that contains the Fdisk utility.
Start the Fdisk utility.
Press the Enter key to enable large disk support.
Select Option 2 for "Set active partition."
Enter the number of the partition that you want to set as the active partition, and press Enter.
Press the Esc key to exit.
Remove the boot disk from the floppy drive and reboot the machine.
The chances are however that your drive may have died. Install a new drive (cheap enough)make the first "bad" drive the slave by setting the jumpers. Install OS on the new drive with luck you may be able to see your data if it is not a mechanical failure of the drive.