Hi...
i m using the OLE-DB to connect database with my page and it works ok
with Access2000 but now when i tried to build this connection with Access 2003
or later then its not working. please help........
<HTML>
<HEAD>
<TITLE>TEST</TITLE>
</HEAD>
<BODY>
<FORM NAME=ENTRY METHOD=POST ACTION="Insert.asp">
NAME: <INPUT TYPE=TEXT NAME="stname" VALUE="">
<INPUT TYPE="SUBMIT" VALUE="INSERT">
<INPUT TYPE="RESET" VALUE="CLEAR">
</FORM>
</BODY>
</HTML>
I saved this page as"insert.html"
NOW ASP PAGE IS
<%
Dim stname, qry
stname=request.form("stname")
dbfile=server.Mappath(info.mdb")
set Conn=Server.Createobject("Adodb.Connection")
Conn.Connectionstring="Provider=Microsoft.Jet.oledb.4.0;Data Source="& dbfile
&";Persist Security Info=False"
Conn.open
qry="Insert into student(stname) values(' "& stname &" ')"
Conn.execute(qry)
Conn.Close
Set Conn=Nothing
Response.redirect("insert.html")
%>
I saved this page as"insert.asp"
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
