Error in adding record

[jessy]

Hi, I connect to my SQL server database using :
set DB=server.createobject("ADODB.connection&#34
DB.ConnectionString = "driver={SQL Server};server=ibm5000;;;database=School"
DB.open
Query="SELECT * FROM Student"
set rs=Server.Createobject("ADODB.Recordset&#34
rs.open Query, DB, adOpenKeyset,adLockOptimistic

when I want to add record using "rs.addnew", "rs.update", it gives me the following error:

ADODB.Fields error '800a0cc1'
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the
application.

May I know how to solve the problem?
Thanks

[Mark]

Hi Jessy,
It sounds like you have a problem trying to read your database. What ADO version do you have? 1.5? 2.0? 2.1? May I suggest you order a copy of our software, ASP-db, and let it do all the work for you? It will eliminate all of the code that you are struggling with now. It is fast and very easy to use. Check out our on-line demo at http://www.aspdb.com
You can even download a FREE trial version.
Thanks!

Mark.


------------
jessy at 7/7/00 3:41:25 AM

Hi, I connect to my SQL server database using :
set DB=server.createobject("ADODB.connection&#34
DB.ConnectionString = "driver={SQL Server};server=ibm5000;;;database=School"
DB.open
Query="SELECT * FROM Student"
set rs=Server.Createobject("ADODB.Recordset&#34
rs.open Query, DB, adOpenKeyset,adLockOptimistic

when I want to add record using "rs.addnew", "rs.update", it gives me the following error:

ADODB.Fields error '800a0cc1'
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the
application.

May I know how to solve the problem?
Thanks