Ok, I've done numerous tests. For simplicity, I'll refer to this pfsense/squid router as computer #1, and my other test computer as pfsense #2. All I was looking for was that the BIOS would read it. My first step in my tests was to unplug the CD ROM (just to cut those out of the picture) and also replace the sata cable with one that I KNOW works, in case it might be the sata cable that is bad. Here are my tests:
1. Plugging the hard drive into different sata ports on the sata hard drive on computer #1. This changed nothing.
2. Robbing Sata hard drive from computer #1 to test it in computer #1, again testing it in different ports. This changed nothing, and I KNOW that the sata HD from computer #2 works.
3. Plugging the sata controller card into a different PCI slot and doing the same as above. This changed nothing.
4. Taking the sata controller card from computer #1, and putting it in computer #2. I then hooked up the HD from computer #2 (which again, I know works). The computer did not detect the hard drive. I tried using different sata ports on the controller card, and that changed nothing.
5. Plugging the HD from computer #1 into computer #2 using the on board sata port (no controller card)… and the BIOS finally detected it.
So, I can conclude that either this controller card is bad (and it being new, I doubt that), or that I do not have the right driver installed. It came with a small driver CD, if I remember right. I just have to find out where I put it. Right now I have no idea even what make it is, or whether this driver will work with freeBSD (which I highly doubt unless its a bios firmware thing). Either way, I'm sure its got to be a problem with this sata controller card.
Now what?
EDIT:
I've been thinking... is it possible for the hard drive/sata controller card to work in an Operating System even if the BIOS did not detect it?
Edit:
I've concluded that the card must be bad and I think I'm going to just return it and get my money back.
I've been chatting on the pfsence IRC chat room, and a lot of the guys there said that they think my quest for speed is stupidity and that most hard drives and also sata controllers are way over rated. They said that I should just use IDE, as thats what I have. So, I've got a couple IDE hard drives and I think I'll just make it work. It saves an extra PCI slot for another NIC card, and that means I won't need a switch ;).