VB6 DataGrid

I am using VB6 with SQL Server.
I have the following error "The rowset is not bookmarkable." when I try to set the datagrid's datasource, and the recordset that I am using has the cursor location set to use server and the cursor type is dynamic and the lock is optimistic, what could the problem be ?
I have not tried the datagrid before so I please give some examples if possible.
Who is Participating?
JohnBPriceConnect With a Mentor Commented:
Open it as static instead of dynamic.  Also make sure you have a primary key on your table and that your query is indeed updatable, else open it read only and disable add/edit/delete in the grid.
Jorge PaulinoConnect With a Mentor IT Pro/DeveloperCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.