Red Hat 9 has been unsupported since May, 2004. I strongly suggest you upgrade to a supported Linux distribution to keep current with security updates and bug fixes.
As for a dial up connection, have a look at
this article I found with a simple
Google search.
The CD provided by an ISP usually contains very little value. Nothing you couldn't download yourself.