i am not able to retrive the data from the web server using the below mentioned javascript. I got the web server path by using the asp function Server.MapPath() and i am able to retrive the data using asp. but i have to use javascript so pls help me and tell me where i am wrong..........

function GetDBMake()
    {
        var objCN = new ActiveXObject("ADODB.Connection");
        var objRS = new ActiveXObject("ADODB.Recordset");
        var strRet = "";
        objCN.open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\mebco.com\mebco.mdb;Persist Security Info=False")
        objRS.open("Select distinct make From Battery_Names", objCN, 0, 1)

        while(!objRS.EOF)
        {
            strRet = strRet + ';' + objRS.Fields("make");
            objRS.MoveNext()
        }

        objRS.close
        objCN.close
        return strRet;
    }

!!! kumar !!!

I think in JavaScript you should escape the backslash with another backslash:


objCN.open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Inetpub\\mebco.com\\mebco.mdb;Persist Security Info=False")


HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: All the answers by Ilse De Lange (Track 13 from the album: Here I Am - 1998-2003) What's This?

hi imar,
   i tried ur code its working in our LAN, but its not working in Web Server, even it not displaying any error msgs.

thank u
kumar

Where is the code running, client-side or server-side? This code needs to run on the same machine as the database so server-side is more practical, if client-side it will only work when the script is run on the same machine as the database and if it's a web page then when security settings are very low.



--

Joe (Microsoft MVP - XML)