The latest version of the nForce drivers is 1.0-0261. nVidia haven't update their "Linux/FreeBSD drivers" page in ages so the best way to find the latest driver revision is to go to the main
drivers page and in the three boxes, selecting Platform/nForce drivers, Unified Driver, Linux and then clicking 'Go'.
Next, avoid the RPMs and go straight for the source tarballs, they're far more trouble than they're worth. When you have the source tarballs downloaded, uncompress them into /usr/src:
cd /usr/src
tar zxvf /path/to/NVIDIA_nforce-1.0-0261.tar.gz
You don't want the audio driver as you'll either have ALSA already installed or be installing it later and the nvgart patch is probably useless as it'll have a heart attack when presented with RH's horribly raped kernels so just compile and install the network driver like so:
cd /usr/src/nforce/nvnet
make && make install
This is where it gets tricky. I haven't used RH in ages so I don't know whether it's still persisting with manually editing modules.conf or has joined the 21st century and is using modutils but somehow, the following line has to end up in modules.conf:
When that's done, modprobe nvnet and then run whatever tool RH usues to set up a LAN interface. That should get the onboard LAN going.
For sound, I suggest you look at the
ALSA Project page for their intel8x0 driver (which also works on nForce2).
The IGP onboard video is supported through the same unified drivers as any other nVidia card so grab the latest by again going to the driver page but this time selecting Graphics Driver, GeForce and TNT and Linux IA32 before hitting go. Install them by following the instruction on the driver page but remember to open up your /etc/XF86Config file and changing the name of the driver from 'nv' to 'nvidia' or they won't work at all.
That should be enough to get your nForce board working at least partially on Linux.