|
Hello,
i' m using the follwing code to retrieve data from an sqlserver and handle them with a recordset. The problem is that, when i try to modify data from recordset i get the error message:
"Error: ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype."
I try all the combinations of locking, but nothing seems to work out.
Is it the version of the sqloledb.dll (mine is 2000.85.1132.0)?
Do i need other driver that supports updateable recordset?
How can i know?
Please Help!
Here is the code:
<%
conSTRING="Provider=SQLNCLI;Server=" & srv_name & ";Database=" & database_name &";UID=uid;PWD=password;"
Set con = Server.CreateObject("ADODB.Connection")
con.Open conSTRING
set rs = server.CreateObject ("ADODB.Recordset")
do while not rs.EOF
rs("tradecode") = "123"
rs.update()
rs.MoveNext
loop
Set con = Nothing
set rs=nothing
%>
|
