I am trying to connect my login page to an access database. Right now I am simply storing the values inside the database .I am having trouble connecting to the databse itself. Below is the code that I have written using VBScript. What am I doing wrong? ...Thanks in advance
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<%@ language="vbscript" %>
<%
sub B3_onclick()
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="C:\Documents and Settings\sridhanj\Desktop\project\logon.mdb"
SQL = "INSERT INTO tblusers ('UID') VALUES (document.loginform.T2.value);"
Conn.Execute(SQL)
Conn.Close
end sub
%>
<title>New Page 1</title>
</head>
<body>
<form name = "loginform">
<h1 align="center">LOGIN</h1>
<p align="center"> </p>
<p align="center"> </p>
<p align="center"> </p>
<p align="center"> </p>
<p align="center">Username:
<input type="text" name="T1" size="20">
</p>
<p align="center">Password:
<input type="password" name="T2" size="20" maxlength="12">
</p>
<p align="center"> </p>
<p align="center"><input type="submit" value="Submit" name="B3">
<input type="reset" value="Reset" name="B4"></p>
</form>
</body>
</html>