hello,
just check out with this
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"
He Man <[EMAIL PROTECTED]> wrote:
vicky removethe response.redirect code
& c what is the error u are receiving any error number etc
abhi
On 4/20/05, vicky <[EMAIL PROTECTED]> wrote:
>
> 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
>
>
>
>
>
---------------------------------
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 the Yahoo! Terms of Service.
__________________________________________________
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/
