Clientside VBScript and MapPoint?

I'm working on three MP-related things and have looked through these forums for the answers to what I'm sure must have been asked before but haven't had any luck. I am completely new to MP so if some kind person(s) could point me in the right direction(s) I would be grateful.

Scenario 1:
Using a client-side VBScript application (HTA) to search / display data from a MySQL database. -Are there any VBScript examples for MP2k4? -I can find some straight VB / EXE examples but have had no luck adapting them.

Scenario 2:
Using the process mentioned above, I need to find addresses within X miles of point Y. Do I need (or would it be faster) to have long/lat in the DB already?

Scenario 3:
Part of what I'm working on is web-based. In order to remain EULA compliant, I would like to be able to submit - from a web form - information to the locally installed MP. Having something (script or whatever) installed on the clients machine as a prerequisite is fully acceptable if necessary. -I'm mainly looking for possible approaches to explore on this one.

This is a very comprehensive forum and I'm very new to MapPoint - it's a bit overwhelming so thanks in advance for any direction or links!

Also, in case I haven't been clear, I'm looking to use the HTA (vbscript) to open MP to the correct map as opposed to making an HTML file - although that might be a possibility to consider for later.

Thanks again!

The code for Scenario 1 (above) in VBScript:

Sub ShowApplication()

Set oApp = CreateObject("MapPoint.Application")
Set oMap = oApp.ActiveMap
oApp.Visible = True
oApp.UserControl = True

'Add a Pushpin
oMap.AddPushpin oMap.FindResults("502 Hazlett Ave NW, Canton, OH, 44708")(1)

'Add another Pushpin
oMap.AddPushpin oMap.FindResults("41423 West Tuscarawas Street, Canton OH, 44702")(1)


'Zoom to the newly created Pushpin set
oMap.DataSets.ZoomTo
oApp.ActiveMap.ZoomIn

End Sub

ShowApplication

Is any authetication information such as user id and password is required to access the Map Point service?
And what URL we need to access the Map Point service ?

amitsh,

Authentication & URL don't really apply - this code is for client-side use, not server-side. -It's designed to pass values from a client-side vbscript application directly to MapPoint (installed on the same machine), open MP and map the address(es) sent to it.

It wouldn't be hard to modify to accomplish publishing maps - and the EULA (2k4 anyway) DOES provide for up to 1000 Internet posted pages

Dig through MS's MSDN site for MapPoint (developer section) - pretty much all the code you need is there 8)