accessing Access Database using javascript
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 !!!
|