[OpenLayers-Users] Database access

[Graham Wade]

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.