unable to save to database!

immotal · Sep 2, 2003

hi.. I am unable to save data to database.the codes are below..It will give mi an error shown:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9c Thread 0xa8c DBC 0x2185024 Jet'.
/project/b2/013974H/project/addcust.asp, line 28

<% Option Explicit %>
<%
dim err
dim conn
dim rs
dim strBuffer1,strBuffer2
dim varDatabaseName
dim sql

varDatabaseName="db2.mdb"

On Error Resume Next
rs.close
conn.close
set rs = nothing
set conn = nothing
On Error Goto 0

set err = server.createobject("ADODB.error&quot

set conn = server.createobject("ADODB.connection&quot

conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(varDatabaseName)
set rs = server.createobject("ADODB.recordset&quot

rs.CursorType = 2
rs.LockType = 3

dim s
s = "Select * from customer"
rs.open s,conn '"customer", conn, adLockOptimistic, ,adCmdTable

rs.AddNew
rs("firstname&quot

=Request.Form("firstname&quot

rs("lastname&quot

=Request.Form("lastname&quot

rs("delivery&quot

=Request.Form("delivery&quot

rs("town&quot

=Request.Form("town&quot

rs("country&quot

=Request.Form("country&quot

rs("contact&quot

=Request.Form("contact&quot

rs("fax&quot

=Request.Form("fax&quot

rs("email&quot

=Request.Form("email&quot

rs("credit&quot

=Request.Form("credit&quot

rs("creditcardnum&quot

=Request.Form("creditcardnum&quot

rs("expire&quot

=Request.Form("expire&quot

rs("cardholdername&quot

=Request.Form("cardholdername&quot

rs.Update

response.write "Saved!"
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<html>

<head>
<title>customerInformation</title>
</head>

<body>

<h3>This information has been saved.</h3>
</body>
</html>

thx for ur help..

shaddow · Sep 3, 2003

The database file does not exist. I got that often before and that was it.
It could be some Server.MapPath(varDatabaseName) error, better display that value and see if it's the real path to database. As i see from your code the db2.mdb should be in the same directory as the asp file.

________
George, M

immotal · Sep 3, 2003

thx.. i manage to solve it

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

unable to save to database!

immotal

Technical User

shaddow

Programmer

immotal

Technical User

Similar threads

Part and Inventory Search

Sponsor