Sounds like you have a cable on wrong, or a jumper setting that is incorrect.
For some drives, there is a specific jumper setting if it is the only drive.
Also, if your IDE cable is marked with specific connections for Master and slave, make sure the drive is connected to the proper connector.
Is this the only drive in the system?
If this is a second drive, make sure that the jumpers on both drives are set correctly.
Lastly, clicking sounds form a hard drive are usually not good.
Try booting up with the IDE cable disconnected.
Does the clicking noise still come from the hard drive?
Or, does it come from your floppy drive?
As to the video card, yes, older video cards can have problems on newer systems.
8 years old would make the video card a PCI, or early AGP card.
Heck, it could even be ISA or VLB.
Some of the Diamond cards from this era were video accelerators. If this is a video accelerator, you actually need to route the signal from the primary video card through the Diamond card.
Sounds like we may need a few more details.
What type of system / motherboard do you have?
What specific model of video card?
Do you have 1 or 2 hard drives?
Is this a "new" hard drive?
Or a new to you hard drive?
Chas