hello everyone,
I m gettin this error every now and then
I m gettin frustrated with it
i m using IIS 5.0 Access 2000 ans ASp
my script is as followss..
% @Language = VBScript %>
<% Option Explicit %>
<%
Dim conn1,rs1,filePath
Dim yname,yemail,nname,ndept,comment,toya,atoya,y_rel
'filePath = Server.MapPath("C:\Inetpub\wwwroot\Myweb\Nominatio n.mdb")
set conn1 = Server.CreateObject("ADODB.Connection")
conn1.open"Nom1"
'conn1.Open "Provider=Microsoft.Jet.OLEDB.4.0;"&_
'"DataSource = C:\Inetpub\wwwroot\Myweb\Nomination.mdb;"
yname = Request.Form("Y_name")
yemail = Request.Form("Y_email")
nname = Request.Form("N_name")
ndept = Request.Form("N_dept")
comment = Request.Form("Comment")
toya = Request.Form("C_toya")
atoya = Request.Form("C_atoya")
y_rel = Request.Form("Y_Rel")
%>
<html>
</head>
You Submitted the Following Data: <br>
<%
Response.write " Your name :" &yname & "<br>"
Response.write " Your email :" &yemail &"<br>"
Response.write " Nominee's name :" &nname &"<br>"
Response.write " Nominee's Dept :" &ndept &"<br>"
Response.write " Award Type :" &toya &"<br>"
Response.write " Award Type :" &atoya&"<br>"
Response.write " Relationship to Nominee :" &y_rel&"<br>"
Response.write " Your Comments :" &comment
%>
<%
'conn1.Execute "INSERT INTO ATOYA ([Your_Name],[Your_Email],[Nominee_Name],[Nominee_Dept],[Comment]) VALUES ("& yname &", "& yemail &", "& nname &", "& ndept &", "& comment &")"
%>
</head>
</html>
i i nstalled mdac version 2.5 , 2.7 doesnt work even then
can anyone PLEASE HELP ME