[OpenLayers-Users] Database access

[Umberto Nicoletti]

The code you have posted is vbscript (visual basic) and will only ever work
on IE. You want to remove the vbscript pieces and replace them with
javascript code.

Also you are making the db connection directly from the browser which is
not in way supported by javascript. You will have to provide a second tier
(on a server like IIS or with scripting languages like php, ruby, nodejs,
etc) to execute the sql and return the results to the browser in a
javascript friendly format like json.

See: http://en.wikipedia.org/wiki/Multitier_architecture

HTH,
Umberto


On Tue, Jul 24, 2012 at 1:54 PM, Graham Wade <Graham.Wade at coralsys.co.uk>wrote:

> Hi All
>
>         I am trying to display the positions of three vehicles on a
> markers layer. The positions are stored in an SQL Server database and the
> page is an aspx page. The code below works okay on IE9 but not on anything
> else. Can anyone point me in the right direction to get this working on
> most browsers. I am fairly new to javascript and aspx and so any help will
> be appreciated.
>
> ====
>
>             function updatevehicles()
>             {
>
>              vehiclePositions.clearMarkers;
>                 var currentvehiclePosition;
>
>                 var ConnDB = new ActiveXObject("ADODB.Connection");
>                 ConnDB.ConnectionString = "Provider=SQLOLEDB.1;Integrated
> Security=SSPI; PersistSecurity Info=False;Initial Catalog=xxxx;Data
> Source=yyy";
>                 ConnDB.Open();
>                 var Rs = new ActiveXObject("ADODB.Recordset");
>                 Rs.Open("SELECT DISTINCT [UnitID], [Latitude],
> [Longitude], [Icon], [Colour] FROM [Position] ORDER BY [UnitID]", ConnDB);
>                 Rs.MoveFirst;
>                 var vehiclenum;
>                 vehiclenum = 1;
>                 while (!Rs.EOF) {
>                     currentvehiclePosition = new
> OpenLayers.LonLat(Rs.Fields.Item("Longitude"),
> Rs.Fields.Item("Latitude")).transform(
>                         new OpenLayers.Projection("EPSG:4326"),
>                         map.getProjectionObject());
>
>                     if (vehiclenum === 1) {
>                         vehicleMarker1 = new
> OpenLayers.Marker(currentvehiclePosition, icon1);
>                         vehiclePositions.addMarker(vehicleMarker1);
>                         vehiclePositions.drawMarker(vehicleMarker1);
>                     }
>                     if (vehiclenum === 2) {
>                         vehicleMarker2 = new
> OpenLayers.Marker(currentvehiclePosition, icon2);
>                         vehiclePositions.addMarker(vehicleMarker2);
>                         vehiclePositions.drawMarker(vehicleMarker2);
>                     }
>                     if (vehiclenum === 3) {
>                         vehicleMarker3 = new
> OpenLayers.Marker(currentvehiclePosition, icon3);
>                         vehiclePositions.addMarker(vehicleMarker3);
>                         vehiclePositions.drawMarker(vehicleMarker3);
>                     }
>
>                     vehiclenum++;
>                     Rs.MoveNext;
>                 }
>             }
>
>
>
> ====
>
>
> Graham Wade
>
>
>
>
> Graham Wade
> Managing Director
>
> Phone: 01420 550 290 Ext 200
> Fax  : 01420 550291
>
>
> CORALSys Limited.
> Trading address: Blacknest House, Blacknest Road, Blacknest, Alton, Hants,
> GU34 4PX
> Registered office: Walnut House, Walnut Court, Rose Street, Wokingham,
> RG40 1XU
> CORALSys is a limited company registered in England and Wales.
> Registered number: 3106888.
>
> Please note that CORALSys may monitor email traffic data and also the
> content of email for the purposes of security and staff training.
> Please note that any views or opinions presented in this email are solely
> those of the author and do not necessarily represent those of the company.
>
> The content of this e-mail (including any attachments) is strictly
> confidential and may be commercially sensitive. If you are not, or believe
> you may not be, the intended recipient, please advise the sender
> immediately by return e-mail, delete this e-mail and destroy any copies.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses.
> The company accepts no liability for any damage caused by any virus
> transmitted by this email. E-mail transmission cannot be guaranteed to be
> secure or error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. The sender
> therefore does not accept liability for any errors or omissions in the
> contents of this message, which arise as a result of e-mail transmission.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/openlayers-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/openlayers-users/attachments/20120724/1eda94e4/attachment.html>