DSNless connection

<i><b>Originally posted by : Steve Schofield</b></i><br />the cursor your using is a readonly forward only type. u need to open it up like if nothing after the conn string it treats as readonly data.<br /><br />rs.open "blah", connname, 3, 3 <br />rs.open "blah", connname, 2, 2<br /><br />------------<br />Brian at 2/4/00 10:08:22 AM<br /><br />I am able to pull records from my database using a DSN-less connection, but when I try to update a field, I get the folowing:<br /><br />ADODB.Field error '800a0cb3' <br /><br />The operation requested by the application is not supported by the provider. <br /><br />/cupdate.asp, line 19 <br /><br />this part of my code is:<br /><br />rs.Open sql,myDSN <br />rs.MoveFirst<br />rs("Data") = Request.Form("data")<br />rs.update<br /><br /><br />Any ideas?<br />zz

<i><b>Originally posted by : Brian</b></i><br />I am able to pull records from my database using a DSN-less connection, but when I try to update a field, I get the folowing:<br /><br />ADODB.Field error '800a0cb3' <br /><br />The operation requested by the application is not supported by the provider. <br /><br />/cupdate.asp, line 19 <br /><br />this part of my code is:<br /><br />rs.Open sql,myDSN <br />rs.MoveFirst<br />rs("Data") = Request.Form("data")<br />rs.update<br /><br /><br />Any ideas?<br />