Entry

How can I Access a Microsoft Access database using JavaScript?

May 3rd, 2001 09:06
TanTrung LeTran, Colin Fraser, johan sin, Knud van Eeden,

As far as I am aware, you need to use ASP, JSP or Cold Fusion to 
connect 
to any database. Apparently you can use JavaScript, VBScript or JScript 
and soon C# (C "sharp" from the Dark Side) in an ASP. As Macromedia 
have 
taken over Allaire, I expect that MM Inter Dev 5 will feature either 
Cold Fusion Server or a version of it and it will be just that much 
easier to write pages that connect to a database.
------------
Yes, you can access MS Access on IIS server side using Javascript 
(instead of using VBScript, for example). There are even some 
advantages to use Javascript on IIS4 or older (e.g., regular 
expression). A code example:
<%  @LANGUAGE="JScript" %>
<% 
var strConnect = "DSN=YourDSNHere";
oConn=Server.CreateObject("ADODB.Connection");
oConn.Open(strConnect);
var strSQL = "SELECT SomeField FROM myTable;";
var rsAd=oConn.Execute(strSQL);
Response.Write("First row is "+ rsAd.Fields("SomeField") )
oConn.Close();
%>
Good luck :)
--TanTrung LeTran.