Dynamic cursor + Optimistic batch locking
Hi Andy,
Best way to find it out is to make small test. Just set LockType and
CursorType preperties of recordset into each combination of possible
settings and see what you have in those properties after you opened
recordset. If recordset does not support selected combination, then ADO will
reset it to some default value. This way you could prepare table of all
combinations and you will see which cursor supported in each particular
situation.
Access and SQL Server cursors may behave differently, because you are
working using different providers and each provider could have specific
limitations or features
--
Val Mazur
Microsoft MVP
Quote:
> Hi William,
> Is it true SQL server support this combination? The book,
> Programming ADO by David Sceppa, says that. But I don't
> have this experience. It seems Access and SQL server
> perform differently.
> Thanks for your help.
> Andy
> >-----Original Message-----
> >Optimistic Batch requires the client-side provider which
> only supports
> >static cursors.
> >--
> >William (Bill) Vaughn, Author, Trainer, Mentor
> >Microsoft Pacwest Regional Director
> >"ADO and ADO.NET Examples and Best Practices for VB
> Programmers--2nd
> >Edition" (ISBN: 1-893115-68-2)
> >www.betav.com
> >Please reply only to the newsgroup so that others can
> benefit.
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >________________________________
> >> Hi,
> >> Can I use Dynamic cursor + Optimistic batch locking to
> >> update Access database?
> >> Thanks in advance,
> >> Andy
> >.