Data Base Connection

ashraf · November 25th, 2004, 06:00 AM

Hai all,

I want to connect JavaScript Form to database(MS-Access).

How to Connect?
Please Help me.

om_prakash · November 25th, 2004, 06:18 AM

Following example shows how to use javascript to connect to database:

http://webservices.web.cern.ch/WebSe...Db/content.asp

Om Prakash

joefawcett · November 25th, 2004, 07:32 AM

Here's a few functions I regularly use, you may want to change the error handling to suit your app:

Code:

   var DATABASE_SERVER = <SQL SERVER NAME>;
   var DATABASE_CATALOG = <Database Name>;
   var CONN_STRING = "Provider=SQLOLEDB; Data Source=" + DATABASE_SERVER + "; Initial Catalog=" + DATABASE_CATALOG + "; Integrated Security=SSPI;"

 function getConnection(sConnString)
 {       
    try
    {  
      var oConn = new ActiveXObject("ADODB.Connection");        
      oConn.ConnectionString = sConnString;
      oConn.open();
      return oConn;
    }
    catch(e)
    {
      throw e;
    }      
 }   
 
 //Get a read-only recordset from a query or stored procedure and a connection object
   function getReadOnlyRS(sQuery, iQueryType, oConn)
   {
     try
     {
      if (oConn.state != adStateOpen)
      {
        oConn.open();
      }     
      var oRS = new ActiveXObject("ADODB.Recordset");
      var nothing = oRS.ActiveConnection;
      oRS.CursorLocation = adUseClient;
      oRS.open(sQuery, oConn, adOpenForwardOnly, adLockReadOnly, iQueryType);
      oRS.ActiveConnection = nothing;  
      //oConn.close();
      return oRS;
     }
     catch(e)
     {       
       throw e;
     }      
   }

   //Get a dynamic recordset from a query or stored procedure and a connection object
   function getDynamicRS(sQuery, iQueryType, oConn)
   {
     try
     {
      if (oConn.state != adStateOpen)
      {
        oConn.open();
      }     
      var oRS = new ActiveXObject("ADODB.Recordset");
      var nothing = oRS.ActiveConnection;
      oRS.CursorLocation = adUseClient;
      oRS.open(sQuery, oConn, adOpenDynamic, adLockOptimistic, iQueryType);
      oRS.ActiveConnection = nothing;  
      //oConn.close();
      return oRS;
     }
     catch(e)
     {       
       throw e;
     }      
   }
      
   function executeNonRSQuery(Conn, SQL)
   {
     var lRecCount;     
     if (Conn.state != adStateOpen)
     {
       Conn.open();
     }
     try
     {
       Conn.execute(SQL, lRecCount, adExecuteNoRecords);
     }
     catch(e)
     {
       throw e;
     }          
   }

--

Joe (Microsoft MVP - XML)

ashraf · November 27th, 2004, 01:31 AM

hai all,
i got this code from Ome Prakash, i tried from this code to connect java script to MS-Access , but i could not sucsseed.
PLZ Help me!

<html>
<%@ Language="JScript"%>
<%
 con.ConnectionString = "DRIVER={Microsoft Access Driver(*.mdb)};"_
 DBQ=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "\test.mdb"

 con.Open();

 sql = "SELECT * FROM tabel1 ;
 CurrentRecordset = con.Execute(sql)
%>
<body>
This is a view on the database

<table border="1" cellpadding="0" cellspacing="0" width="100%">
 <tr>
 <td width="25%">Id</td>
 <td width="25%">E_id</td>
 <td width="25%">Name</td>
 <td width="25%">Salary</td>
 <td width="25%">Grade</td>
 </tr>
<%
 while (! CurrentRecordset.EOF)
%>
 <tr>
 <td width="25%"><% = CurrentRecordset("Id")%></td>
 <td width="25%"><% = CurrentRecordset("E_Id")%></td>
 <td width="25%"><% = CurrentRecordset("Name")%></td>
 <td width="25%"><% = CurrentRecordset("Salary")%></td>
 <td width="25%"><% = CurrentRecordset("Grade")%></td>
 </tr>
<%
 CurrentRecordset.MoveNext();
 }
%>
</table>
</body>
</html>

joefawcett · November 27th, 2004, 06:56 AM

Firstly what is your connection string exactly? As you are trying to connect server side you should build the string and Response.Write it out before trying to connect. Is the path correct and does your IIS account have read/write permissions to the folder and database file?

Personally I would never connect with ODBC to an Access database I would use something like this:

Code:

function getAccessConnectionString(Path)
{
  var sPhysicalPath = Path;
  if (sPhysicalPath.indexOf("\\") == -1)
  {
    sPhysicalPath = Server.MapPath(Path);
  }
  var sConnString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sPhysicalPath + ";User Id=admin;Password=;"
  //For debug
  //Response.Write(sConnString);
  return sConnString; 
}

You can pass a relative url such data/myDB.mdb or the full path, "C:\inetpub\wwwroot\myApp\data\myDB.mdb" (remeber to double up backslashes in JavaScript.

That's for standard security, if your database is password protected or has Access groups etc. see http://www.connectionstrings.com for other versions.

--

Joe (Microsoft MVP - XML)