adding to db

mike · Jul 2, 2003

I bought 3 books and spent weeks trying to add a record to
my database, but haven't figured it out??? I've tried both
sql and addnew method, but to no avail. Below is my sql
method. Any ideas would be highly appreciative.

<% @Language=VBScript %>
<% Option Explicit %>
<% Response.Expires = 0 %>
<%
Dim objConn, objRS, strQ
set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={Microsoft Access Driver
(*.mdb)};" & _

"DBQ=c:\home\mike\www\data\data.mdb"
objConn.Open
strQ = "INSERT INTO appointments (name) VALUES ('mike')"
objConn.Execute strQ
set objRS = objConn.Execute("SELECT * FROM appointments")
%>
<html>
<body>
<%
objRS.Close : objConn.close
Set objRS = Nothing : set objConn = Nothing
%>
</body>
</html>

Tom B · Jul 2, 2003

I'd use a different connection string.
objConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\home\mike\www\data\data.mdb;"

see www.connectionstrings.com

I assume your database has a table called appointments with a field called
name in it.
try
strQ="INSERT INTO appointments([name]) VALUES('mike')"
as I'm sure name is a reserved word

move your "set objRS=" to ....
<html>
<body>
<%
Set objRS=objConn.Execute("SELECT [name] FROM appointments")
Do While not objRS.EOF
Response.Write "<LI>" & objRS.Fields("name").value & "</LI>" &
vbCrLF 'note no [ ] here
objRS.MoveNext
Loop
Set objRS=nothing 'note you don't close the Recordset......because
you didn't open it.
objConn.Close
Set objCOnn=nothing
%>
</body>
</html>

Robb Meade · Jul 2, 2003

...

I bought 3 books and spent weeks trying to add a record to
my database, but haven't figured it out??? I've tried both
sql and addnew method, but to no avail. Below is my sql
method. Any ideas would be highly appreciative.

[snip]

Getting any specific errors or is it returning a white page with no text but
yet not adding the data?

more info needed.

Regards

Robb

Bob Barrows · Jul 3, 2003

mike said:
Thanks Tom, it was your suggestion to move code to the
body that led me to find my error of a read only db. I
don't have it read only, but never-the-less, my code only
works with a new db. Thanks tremendously.

http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

Read Only error when trying to write to Access DB	2	Dec 14, 2007
No data return from ASP but Access returns correctly.	1	Nov 3, 2006
Read-Only error when writing to Access database	2	Dec 13, 2007
ASP Displaying Images from within SQL DB	3	Oct 27, 2003
How to Check if Dynamic Form field exists in access table	1	May 19, 2009
ASP Amphasand, XML	6	Jul 19, 2006
Server-side DB & client-side chart	3	Jan 29, 2004
Dynamic Drop down list trouble	1	Nov 15, 2006

adding to db

mike

Tom B

Robb Meade

Bob Barrows

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads