Dear Ms Ng,
I don't think both the Indian and Chinese Astrologers were wrong in their reading. But what they probably didn't tell you is that you have a lot of personal issues you have to deal with, internally, before your heart can open up and allow the person to come in.
First of all- there is no Mr Right in your life.
But why do you need a 'Mr Right'. Can you lower your standards? You are not perfect either? So perhaps this would make things easier.
Secondly - you earth element and being dry earth, it's nature is to 'absorb'. Hence this translate as you may be waiting for someone to come in an 'complete' your life and save you from loneliness. Perhaps this is the wrong approach. Being an Earth element, you must behave like a 'valuable' piece of land. Meaning - you need to think what this piece of land can grow, develop and produce. Metaphorically speaking of course.
This means - why don't you think WHAT can you offer should someone choose YOU as a partner? What's so valuable about you? If you begin to see this, honestly. You WILL find your someone.
Cheers,
JY