Generating KML on the fly from MS SQL db on to Google Maps

[sandreev]

Hi,
I want to be able to show markers from a KML file with the most
updated information from a MS SQL database on to Google Map on an ASP
page.
I plan to achieve this in various steps.
1. When an user selects an option on the ASP page, I want to read the
database and generate a KML.
2. This dynamically generated KML will then be copied to a location
the server.
3. ASP page that contains Google Map will have a KML with network
link.

Due to various limitations at work, I am limited to ASP/MS SQL
technologies.

The part where I really need help is to create a KML from a database
and copying that on to a particular location.

Thank you,

[Berwyn]

This link explains and easy way to do what you want

http://stackoverflow.com/questions/952667/solved-how-to-output-a-simple-c-asp-net-generated-kml-file

Berwyn

[sandreev]

Thank you for your response.
I do not want the user to save the KML file, I want to save that on
the server.
The user in my case does not have GE installed.

Please let me know if there is a way to save the file on the server
than on the browser.

Thanks,

On Jun 22, 11:31 am, Berwyn wrote:
> This link explains and easy way to do what you want
>

> http://stackoverflow.com/questions/952667/solved-how-to-output-a-simp...
>
> Berwyn

[todduser]

You could create a SSIS / DTS package to generate the kml on the
server and move the kml to the desired location... then have your
asp page run the package.

> > Berwyn- Hide quoted text -
>
> - Show quoted text -