Member Avatar for bapu435

i am developing a website in html in which the contactus page i have to connect to ms access database i am not able to get it ,can any one tell me how to get that one.

Edited by Ezzaral because: zomibe thread, closing
  • 19 Contributors
  • 20 Replies
  • 7K Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by Ezzaral
expnik commented: hot to connect to database +0
Member Avatar for stymiee

You need to use a server side programming language like ASP to do this. HTML cannot access a database itself.

Member Avatar for mkhizess

<html>
<head>
<title>Entitled Document</title>
<script language="JavaScript" >

function getSubmit()
{
var LastName;
var Firstn = names.value ;

var cn = new ActiveXObject("ADODB.Connection");
//here you must use forward slash to point strait
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb";
var rs = new ActiveXObject("ADODB.Recordset");
//var SQL = "INSERT INTO Customers(FirstName, Surname)"
//+ " VALUES ( '"+ names.value +"', '" + surname.value +"')";
var SQL = "select Surname, DOB from Customers where FirstName = '" + Firstn + "'";

cn.Open(strConn);
rs.Open(SQL, cn);
surname.value = rs(0);
DOB.value = rs(1);
//alert(rs(0));
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>

Member Avatar for hidash_in

hello i cant get output for the above coding pls help.

Member Avatar for Shobhit

hello i cant get output for the above coding pls help.

You have to save the file with .asp extension for the IIS server to interpret it correctly. Also it would be helpful if you post the output you are currently getting, as most probably you giving incorrect path for your access file.

Member Avatar for techna

[inline] as far as my knowledge goes u can't achieve this by javascript as well, try doin something like this [/inline]

<html>
<%@ page import="java.sql.*"%>
<%
var LastName; 
var Firstn = names.value ; 
var cn = new ActiveXObject("ADODB.Connection"); 
//here you must use forward slash to point strait 
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb"; 
var rs = new ActiveXObject("ADODB.Recordset"); 
//var SQL = "INSERT INTO Customers(FirstName, Surname)" 
//+ " VALUES ( '"+ names.value +"', '" + surname.value +"')"; 
var SQL = "select Surname, DOB from Customers where FirstName = '" + Firstn + "'"; 
cn.Open(strConn); 
rs.Open(SQL, cn); 
surname.value = rs(0); 
DOB.value = rs(1); 
//alert(rs(0)); 
rs.Close(); 
cn.Close();
}
catch(Exception e)
{
out.println("error occured:" + e.getMessage());
}
%>
</body>
</html>

[inline] save this as .jsp and add some code for displayin gthe fields. hope this will help u [/inline]

Member Avatar for kapil.soni

Hi,
any one can help me out i have a excel database and want to show records in a html application; like i have employee code and their quality scores how i can show it in html form by putting emp code.

Member Avatar for MidiMagic

Use the "Save as web page" option in the File menu.

Notice that html can't access a spreadsheet on your computer. You have to upload the changed web page after any changes to the spreadsheet.

Member Avatar for faulkj

You are able to connect to Microsoft Access using JavaScript when the HTML file is run locally and the Access .mdb file is accessible to the file system it does not work remotely due to the obvious security issues.

I had a situation where this functionality was actually useful, so I wrote a JavaScript library to simplify the process. This library allows you to execute SQL queries in a single command with the option of selecting the output format of the result-set from choices including JSON, XML, and HTML.

I had a great deal of difficulty finding information or examples of how to connect to Access, so I decided to share my code with the world...

The library is called ACCESSdb and you can get it here!

:thumbs:

Member Avatar for goaway

Hi,

I am creating something similar as discussed above.

I have a access database which has the list of banking centers and their hours of operation ,Monday -Sunday.

Now, i have created a html page, asking the user to select the state from a drop down menu, and the day as checkbox. So that when I click on "Submit Query' button, it gives me all the banking centers of that state open on Monday and at which time.

I want to link this HTML.html file with my access table.
Also, i want to have a out put screen in html/access form which shows the result.

Appreciate, what all you can make available.

Thanks

Member Avatar for navinsharma

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

Member Avatar for navinsharma

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

Edited by nav33n because: email snipped
Member Avatar for Troy III

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.

Member Avatar for sanjeev.vermas

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

<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>
Edited by nav33n because: For easy readability, wrap your code in [code] tags.
Member Avatar for goaway

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 .

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:

<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

Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
Member Avatar for hitmale11

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

Member Avatar for HenniePj

Hi Guys,

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

<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>
Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
Member Avatar for alphatechnology

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.

Member Avatar for Sonu Rohilla

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

Member Avatar for namadi

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

Edited by Ezzaral because: Snipped email. Please keep it on site.
Member Avatar for Ezzaral

Too many hijacks, spams, and nonsense posts. Closing this threads.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.