Can you connect Google Earth to a database using Microsoft SQL?

[Taisha]

Hi everybody!

I am creating a GIS database and am wondering if anybody knows if it is possible to connect google earth to my database using Microsoft SQL?

If not, does anybody know how it can be connected or if it is at all possible?

Thanks a lot!

 

[Lightwave]

Hi Taisha the short answer is

"Yes"

Although it kind of depends on what you mean by connect.
Not entirely sure what you mean by GIS Database either but....

My gut feeling is that your going to have to create some code that creates a KML on the fly. Once in Google Earth it looks like it is not possible to edit the information in the database from the client - although that might not be required if you have a shiny application already hooked up. So it will not be a GeoDatabase.

http://groups.google.com/group/earth-free/browse_thread/thread/ecc87e1bc6084dc2?pli=1

Its definitely at the difficult end of database administration..

What I would investigate is to have longitudes and latitudes hooked into the databases and put some VB script behind a button that writes out the KML and flys you to the individual record after the KML has been created.

This is a good starting point
http://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/7df6ef5e-ec74-4323-ad30-52e00601e00f