Hi!
Check out which user account has write permissions to the database and
the folder where the database resides. The 80004005 error usually means
a permission problem.
Hth,
Hakan
-----Ursprungligt meddelande-----
Fr=E5n: shohokukj@y... [mailto:shohokukj@y...]
Skickat: den 16 november 2002 17:14
Till: ASP Databases
=C4mne: [asp_databases] ASP problem!!!
I am always getting this error message which read:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]Attribute cannot be set now
/doCheckout2.asp, line 6
I will attach the file here. Anyone please help me cos I need this file
urgently. Thanks to whoever it may be.
doCheckout2.asp:
<%
' Add new address & payment info
updateUser
' Begin A Transaction
Con.BeginTrans
' Transfer cart to orders table
sqlString =3D "INSERT INTO orders (" &_
"order_id, " &_
"order_productID, " &_
"order_quantity, " &_
"order_userID, " &_
"order_entrydate, " &_
"order_status " &_
") SELECT " &_
"cart_id, " &_
"cart_carID, " &_
"cart_quantity, " &_
"cart_userID, " &_
"NOW(), " &_
"0 " &_
"FROM cart WHERE " &_
"cart_userID =3D" & userID
Con.Execute sqlString
' Empty shopping cart
sqlString =3D "DELETE FROM cart " &_
"WHERE cart_userID=3D" & userID
Con.Execute sqlString
' End the transaction
Con.CommitTrans
%>
<html>
<head><title>Order Placed</title></head>
<body>
<center>
<table border=3D1 width=3D500 bgcolor=3D"lightyellow"
cellpadding=3D10 cellspacing=3D0>
<tr>
<td>
<font face=3D"Arial" size=3D"3">
<b>Thank you for placing your order!</b>
<br>You can track the status of your order
at any time by clicking
<a href=3D"account.asp">account</a> at the
top of most store pages.
<br>
<form action=3D"default.asp">
<input type=3D"submit" value=3D"Continue Shopping">
</form>
</td>
</tr>
</table>
</center>
</body>
</html>
View Cart
