You haven't given us a huge amount of information about your DVD drive, but I'm going to guess that it's newer than RHEL4 (RHEL4.6 was released on 2007/11/15 according to DistroWatch, so it's not exactly a new distribution).
You could try a more recent version of RHEL (5.1 is the current version), or CentOS (free-as-in-money and based on RHEL, just without the trademarks or support from Red Hat).
If you have the disk space, then you could copy the CDs/DVDs to your hard disk and install from there. Instructions may vary slightly depending on your architecture, but for 64-bit systems see
http://www.redhat.com/docs/manuals/e...nstall-hd.html
Alternatively, if you have another machine that can run a web, NFS or FTP server, then you could perform a networked install (
http://www.redhat.com/docs/manuals/e...-installs.html)
For 32-bit systems, the instructions should be in similar places on the redhat site (I doubt that there'll be any significant differences).
Hope that helps,
—Robert J Lee