AJAX

how to connect ms access database to html webpage

Please support our JavaScript / DHTML / AJAX advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2009

Posts: 2

Reputation: navinsharma is an unknown quantity at this point

Solved Threads: 0

navinsharma navinsharma is offline

Offline

Newbie Poster

#11

Nov 9th, 2009

plz if u get solution plz forward me too becoz i m also have same prob

•

Join Date: Nov 2009

Posts: 2

Reputation: navinsharma is an unknown quantity at this point

Solved Threads: 0

navinsharma navinsharma is offline

Offline

Newbie Poster

#12

Nov 9th, 2009

plz if u get solution plz forward me too becoz i m also have same prob
at <snip>

Last edited by nav33n; 34 Days Ago at 1:40 am. Reason: email snipped

•

Join Date: Jun 2008

Posts: 348

Reputation: Troy III will become famous soon enough

Solved Threads: 42

Troy III

Offline

Posting Whiz

#13

Nov 9th, 2009

If you are targeting Explorer only
you can always use a super lightwieght DSO to access data
go to MSDN and search for "Data Source Object" you'll find all that you need.

•

Join Date: Nov 2009

Posts: 1

Reputation: sanjeev.vermas is an unknown quantity at this point

Solved Threads: 0

sanjeev.vermas sanjeev.vermas is offline

Offline

Newbie Poster

Getting data from msaccess using HTML+ java Script

#14

34 Days Ago

•

Originally Posted by navinsharma

plz if u get solution plz forward me too becoz i m also have same prob

hi...
now it will work
The given example program for retrieving the data from database

 Help with Code Tags 
 JavaScript / DHTML / AJAX Syntax (Toggle Plain Text) 
<html> 
<head> 
<title>Entitled Document</title> 
<script language="JavaScript" > 
 
function getSubmit() 
{ 
 
var Firstn = names.value ; 
 
var cn = new ActiveXObject("ADODB.Connection"); 
 
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb"; 
var rs = new ActiveXObject("ADODB.Recordset"); 
 
 
var SQL = "select Surname, DOB from Customers where FirstName = '" + Firstn + "'"; 
 
cn.Open(strConn); 
rs.Open(SQL, cn); 
surname.value = rs(1); 
DOB.value = rs(2); 
 
rs.Close(); 
cn.Close(); 
 
 
} 
 
</script> 
</head> 
<body> 
 
<input type="text" name="names" /> 
<input type="text" name="surname" /> 
<input type="text" name="DOB" /> 
<input type="button" value="submit" onclick="getSubmit()"> 
 
</body> 
</html>
<html> 
<head> 
<title>Entitled Document</title> 
<script language="JavaScript" > 

function getSubmit() 
{ 

var Firstn = names.value ; 

var cn = new ActiveXObject("ADODB.Connection"); 

var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb"; 
var rs = new ActiveXObject("ADODB.Recordset"); 


var SQL = "select Surname, DOB from Customers where FirstName = '" + Firstn + "'"; 

cn.Open(strConn); 
rs.Open(SQL, cn); 
surname.value = rs(1); 
DOB.value = rs(2); 

rs.Close(); 
cn.Close(); 


} 

</script> 
</head> 
<body> 

<input type="text" name="names" /> 
<input type="text" name="surname" /> 
<input type="text" name="DOB" /> 
<input type="button" value="submit" onclick="getSubmit()"> 

</body> 
</html>

Last edited by nav33n; 34 Days Ago at 1:41 am. Reason: For easy readability, wrap your code in [code] tags.

•

Join Date: Oct 2009

Posts: 2

Reputation: goaway is an unknown quantity at this point

Solved Threads: 0

goaway

Offline

Newbie Poster

#15

27 Days Ago

•

Originally Posted by lelah

Just use the "Save as web page" option in the File menu.

Thanks for the help.

But I had a query, where the database connection specified here, is FOR A sql SERVER .

 Help with Code Tags 
 JavaScript / DHTML / AJAX Syntax (Toggle Plain Text) 
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb"; 
var rs = new ActiveXObject("ADODB.Recordset");
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb"; 
var rs = new ActiveXObject("ADODB.Recordset");

Now , do I have to configure my Access Database in someway?

Here is my HTML Code:

 Help with Code Tags 
 JavaScript / DHTML / AJAX Syntax (Toggle Plain Text) 
<head>
Select STATE: <SELECT NAME="entry4">
<OPTION VALUE="no1">STATE
</SELECT>
<form>
MONDAY
<input type="checkbox" />
<br />
TUESDAY
<input type="checkbox"/>
<br />
WEDNESDAY
<input type="checkbox"/>
<br />
THURSDAY
<input type="checkbox"/>
<br />
FRIDAY
<input type="checkbox"/>
<br />
SATURDAY
<input type="checkbox"/>
<br />
SUNDAY
<input type="checkbox"/>
</form> 
To submit the query, press: 
<INPUT TYPE="submit" VALUE="Submit Query">. <P>
</head>
<html>
  <head>
    <h1>Accessing Data through HTML and Access</h1>
  </head>
  <body>
    Looking at Excel Web Components to create a DAP
  </body>
</hmtl>
<head>
Select STATE: <SELECT NAME="entry4">
<OPTION VALUE="no1">STATE
</SELECT>
<form>
MONDAY
<input type="checkbox" />
<br />
TUESDAY
<input type="checkbox"/>
<br />
WEDNESDAY
<input type="checkbox"/>
<br />
THURSDAY
<input type="checkbox"/>
<br />
FRIDAY
<input type="checkbox"/>
<br />
SATURDAY
<input type="checkbox"/>
<br />
SUNDAY
<input type="checkbox"/>
</form> 
To submit the query, press: 
<INPUT TYPE="submit" VALUE="Submit Query">. <P>
</head>
<html>
  <head>
    <h1>Accessing Data through HTML and Access</h1>
  </head>
  <body>
    Looking at Excel Web Components to create a DAP
  </body>
</hmtl>

The idea is to select teh state and day

I have a ACCESS DB, which has all the details of a partuclar state and its working hours.

Need help in connecting both of them.

Thank You

Last edited by Ezzaral; 25 Days Ago at 1:17 pm. Reason: Added code tags. Please use them to format any code that you post.