Rotating camera looking at a sphere?

I am making a Google Earth kind of simulator in Unity. I got a 4096x4096 texture that is a map of Earth on a sphere, and I got it working so I can set a longitude and latitude, and have the camera look at that point. An example can be found here:

http://www.dionysus.dk/devstuff/unity3d/NetworkingTest/NetworkingTest.html

The problem is, how do I make the camera look at the globe with the North Pole being up, and the South Pole being down at all times?

I can share some of my code if needed. But I think it might just be confusing to add to the question.

Try locking a rotation value and suing transform.lookat to align the camera.