When you say that I need to use "*" host header binding, does that mean that I have to set up *.mysite.com as a host name in IIS 7? I tried it but I got an error saying that "*" is an invalid character.
Thank you for all your help.
BTW, I changed my rule from "Redirect" to "Rewirte" and it did not work. It only works with "Redirect".