Ad:

JavaScript / DHTML / AJAX Discussion Thread
Unsolved
Views: 136589

You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page

Permalink

Nov 9th, 2009

Re: how to connect ms access database to html webpage

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

navinsharma

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2009

Permalink

Nov 9th, 2009

Re: how to connect ms access database to html webpage

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

Last edited by nav33n; Nov 21st, 2009 at 1:40 am. Reason: email snipped

navinsharma

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2009

Permalink

Nov 9th, 2009

Re: how to connect ms access database to html webpage

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.

Troy III

Reputation Points: 120

Solved Threads: 61

Posting Pro

Offline

511 posts
since Jun 2008

Permalink

Nov 20th, 2009

Getting data from msaccess using HTML+ java Script

Click to Expand / Collapse Quote 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

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; Nov 21st, 2009 at 1:41 am. Reason: For easy readability, wrap your code in [code] tags.

sanjeev.vermas

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2009

Permalink

Nov 28th, 2009

Re: how to connect ms access database to html webpage

Click to Expand / Collapse Quote 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 .

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:

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; Nov 30th, 2009 at 1:17 pm. Reason: Added code tags. Please use them to format any code that you post.

goaway

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Oct 2009

Permalink

Apr 5th, 2010

Re: how to connect ms access database to html webpage

i read above and do try it but some error
Line no. :20
char:1
Error: No value give for one or more required parameters.
code: 0
URL: file://c:\documents \...\...\...\.html

hitmale11

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2010

Permalink

May 13th, 2010

Doing it in JAVAScript Baby...

Hi Guys,

Here is the same code in javascript and it works 100%. I'm so proud...

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
<html> 
    <head> 
        <title>Entitled Document</title> 
        <script language="JavaScript"> 
        function getSubmit() 
	{ 
	var LastName; 
	var Firstn = names.value ; 
 
 
            	var cn = new ActiveXObject("ADODB.Connection"); 
            	var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ClientDB.mdb;Persist Security Info=False"; 
            	cn.Open(strConn);
		var rs = new ActiveXObject("ADODB.Recordset"); 
		var SQL = "select Surname, DOB from Customers where FirstName = '" + Firstn + "'";
 
		rs.Open(SQL, cn); 
		surname.value = rs(0); 
		DOB.value = rs(1); 
            	rs.Close(); 
            	cn.Close();   
        } 
        </script> 
    </head> 
    <body> 
 
	name<input type="text" name="names" /> 
	Surname<input type="text" name="surname" /> 
	DOB<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 LastName; 
	var Firstn = names.value ; 

 
            	var cn = new ActiveXObject("ADODB.Connection"); 
            	var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ClientDB.mdb;Persist Security Info=False"; 
            	cn.Open(strConn);
		var rs = new ActiveXObject("ADODB.Recordset"); 
		var SQL = "select Surname, DOB from Customers where FirstName = '" + Firstn + "'";

		rs.Open(SQL, cn); 
		surname.value = rs(0); 
		DOB.value = rs(1); 
            	rs.Close(); 
            	cn.Close();   
        } 
        </script> 
    </head> 
    <body> 

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

	</body> 

</html>

Last edited by Ezzaral; May 13th, 2010 at 2:34 pm. Reason: Added code tags. Please use them to format any code that you post.

HenniePj

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2010

Permalink

Jun 4th, 2010

-1

Re: how to connect ms access database to html webpage

I am developing a website in html in which the contact us page i have to connect to MS-Excel database i am not able to get it ,can any one tell me how to get that one.

alphatechnology

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2010

Permalink

Jun 4th, 2010

-1

Re: how to connect ms access database to html webpage

Hi,
I want to connect my html pages with access databese.
Can any of one help me?
Sonu Rohilla

Sonu Rohilla

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2010

Permalink

Jun 6th, 2010

Re: how to connect ms access database to html webpage

Please help me with code I will use to connect my xhtml web page with my access database.
You can replay by posting on this page or send me message through this e-mail [snipped]

Thank You

Last edited by Ezzaral; Jun 11th, 2010 at 1:06 pm. Reason: Snipped email. Please keep it on site.

namadi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2010

Previous
1
Page 2
3
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

This thread is currently closed and is not accepting any new replies.

Previous Thread in JavaScript / DHTML / AJAX Forum Timeline: Avoid Dropdown refresh

Next Thread in JavaScript / DHTML / AJAX Forum Timeline: I want to connect Thunderbird to local database

DaniWeb Message

Cancel Changes

User Name
Password