Imagine this, we all have female friends we aren't attracted too. For whatever reason, they don't like the same things we like-- or maybe they have a couple extra pounds, or they act a certain way that doesn't allow you to ever see her as being more than just a friend. Like herpes.
If all of a sudden, she loses a couple pounds-- and starts kicking your ass in Starcraft, and buys you a new iPhone for Christmas-- right after they discover a cure for Herpes and all of a sudden, you realize that she would be an awesome catch.
If there isn't the "connection" it doesn't mean it cannot form-- but it isn't something that can be forced. Sometimes you just have to be more appealing, everyone has different tastes.
Anyways-- friendzone, is a total myth if you ask me.