When you say it's not working, is it giving you an error? Dan ________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of vicky Sent: 20 April 2005 12:06 To: [email protected] Subject: [AspClassicAnyQuestionIsOk] DB Connection not working 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........ the connection string i used is <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> 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") %> __________________________________________________ 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] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [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/
