Access Database from Javascript with rds

nosreg · #1 (**permalink**) March 23rd, 2004, 09:21 AM

Hi I want to access an MS Access from javascript but it doesn't work. The resulting recordset includes no records.

Code:

<object id="rdsdc" classid="clsid:bd96c556-65a3-11d0-983a-00c04fc29e33">
<PARAM NAME="SERVER" VALUE="http://localhost">
<param name="Connect" value="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=D:\Webserver\wwwroot\adb1.mdb;">
<param name="sql" value="select * from Artikel">
</object>

Thanks for ur help

---Gerson Kramer
www.aldirezepte.de

joefawcett · #2 (**permalink**) March 24th, 2004, 08:43 AM

It can be very difficult to get this technology to work because of security and the error messages are hopeless.
I normally create the objects rather than use an embedded control, here's my test page.

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>RDS Test</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<script>


function getRsByRds(ServerName, ConnString, Sql)
{
  var sServer = "http://" + ServerName; 
  var oDS = new ActiveXObject("RDS.DataSpace");
  var oDF = oDS.CreateObject("RDSServer.DataFactory", sServer);
  oRs = oDF.Query(ConnString, Sql);
  return oRs;
}

function showDetails(Server, DbPath, Sql)
{
  var sConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + DbPath;
  var sSql = Sql;
  var oRs = getRsByRds(Server, sConnString, sSql);
  if (oRs.BOF && oRs.EOF)
  {
    showResult("No records found");    
  }
  else
  {
    showResult(oRs.getString());
  }
  oRs.close();
}
function showResult(Text)
{
  document.getElementById("txtResults").value = Text;
}

</script>
</head>
<body>
Server:<input type="text" id="txtServer" size="75"><br>
DB path:<input type="text" id="txtDbPath" size="75"><br>
SQL:<input type="text" size="80" id="txtSql"><br>
<input type="button" value="Show Details" onclick="showDetails(txtServer.value, txtDbPath.value, txtSql.value);"><br>
<textarea id="txtResults" cols="80" rows="40"></textarea>
</body>
</html>

--

Joe

uideas · #3 (**permalink**) February 3rd, 2005, 07:19 PM

Hi, I´m trying to access a microsoft access database with a javascript routine, the same way as you mantioned in the example above, but nothing is working here. I have someexperience with ASP, but very few with Javascript, i´ve tried to use your code but it freezes my browser. Please help me to find the "yellow brick road" :-)

Thanks,
Luiz Eduardo

Need to download code?

Navigation