When I turn on my air conditioner, water runs out of the over flow pipe.

That's good,, that's what its for. Think of the wet mess you would have if it didn`t

Now,, what overflow pipe are you talking about? And where is it connected?