asp_databases thread: Database or Object is ReadOnly,
Message #1 by "atif tanver" <atiftanveer@h...> on Sat, 21 Apr 2001 14:24:29
|
|
i am trying to insert a record, but server is returing the
error "Database or Object is Readonly, the same code is working fine
locally,
here is the code:
<!--#include file="Classfd.asp"-->
<%
Dim rsProduct
Set rsProduct=Server.CreateObject("ADODB.Recordset")
rsProduct.Open "product",
objConn,adOpenForwardOnly,adLockOptimistic,admdTable
rsProduct.AddNew "that line produce error"
can any body help me,
atif
Message #2 by "Tomm Matthis" <matthis@b...> on Sat, 21 Apr 2001 10:45:18 -0400
|
|
You are not specifing the cursor type... and by not specifying one, you are
gettting the default cursor which is FowardReadOnly (aka a "firehose"
cursor).
Tomm
> -----Original Message-----
> From: atif tanver [mailto:atiftanveer@h...]
> Sent: Saturday, April 21, 2001 2:24 PM
> To: ASP Databases
> Subject: [asp_databases] Database or Object is ReadOnly,
>
>
> i am trying to insert a record, but server is returing the
> error "Database or Object is Readonly, the same code is working fine
> locally,
>
> here is the code:
>
> <!--#include file="Classfd.asp"-->
> <%
> Dim rsProduct
> Set rsProduct=Server.CreateObject("ADODB.Recordset")
> rsProduct.Open "product",
> objConn,adOpenForwardOnly,adLockOptimistic,admdTable
> rsProduct.AddNew "that line produce error"
>
> can any body help me,
>
>
> atif
>
>
Message #3 by "Charles Feduke" <webmaster@r...> on Sat, 21 Apr 2001 12:55:44 -0400
|
|
See if passing adOpenStatic instead of adOpenForwardOnly alleviates your
problem.
- Chuck
----- Original Message -----
From: "atif tanver" <atiftanveer@h...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, April 21, 2001 2:24 PM
Subject: [asp_databases] Database or Object is ReadOnly,
> i am trying to insert a record, but server is returing the
> error "Database or Object is Readonly, the same code is working fine
> locally,
>
> here is the code:
>
> <!--#include file="Classfd.asp"-->
> <%
> Dim rsProduct
> Set rsProduct=Server.CreateObject("ADODB.Recordset")
> rsProduct.Open "product",
> objConn,adOpenForwardOnly,adLockOptimistic,admdTable
> rsProduct.AddNew "that line produce error"
>
> can any body help me,
>
>
> atif
>
>
|
View Cart
