How to insert a record in MS Access Database using asp?

  • Thread starter Thread starter vishal Alone
  • Start date Start date
V

vishal Alone

Guest
Hello Guys,
I facing problem with the MS Access connectivity, Every time I try to insert a record into the database, The browser gives error...Some browsers give error like "Locktype error " and some give "The field name not found"

My Database contains two fields no. and name ...both are text fields

Here is my Code....

<%@ Language = VbScript%>
<HTML>
<HEAD>
<TITLE>
ASP 21
</TITLE>
</HEAD>

<h2> Masters Of Indian Cricket !!!!</h2>

<%
Dim con
Dim str
Dim rs

Set con = Server.CreateObject("ADODB.Connection")
con.mode=adModeReadWrite
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = D:\Inetpub\wwwroot\database\db3.mdb"

str="insert into emp values ('1','2')"

set rs= Server.CreateObject("ADODB.Recordset")

rs.LockType=3
rs.CursorType=2
rs.CursorLocation=2

rs.Open "select * from emp", con
rs.addnew
rs.fields(1)="vishal"
rs.Update
rs.close
con.close
set rs=nothing
set con=nothing
%>

<hr>

</BODY>
</HTML>
 
Back
Top