> Every SP starts with set nocount on, which prevents server send record > counts for every select.
>
> On the other hand i have no idea how i can change CursorType for command.
> Any suggestions?
Yes. Instead of doing
pRecordset = pCommand.Execute
you do
pRecordset.Open(pCommand, ...);
(i) setting up the Recordset cursortype, locktype, cursorlocation
(ii) making sure Recordset connection is NULL
(iii) making sure Command connection is filled in.
Re: recordset.save takes too long! ... the Save Method "saves the Recordset in a ... the configuration I developed under fails to perform well at the client site ... The CursorType does affect performance. ... Using adOpenKeyset or adOpenStatic would be better ... (microsoft.public.vb.general.discussion)
Re: CursorType, LockType von ADO-Recordsets ... Use the CursorType property to specify the type of cursor that should be used when opening the Recordset object.... If an unsupported value is set, then no error will result; the closest supported CursorType will be used instead. ... (microsoft.public.de.access.clientserver)
Re: Cursors - Server Side - Only Forward? ... >Hi Gerard,... the .CursorType... >have to create a recordset yourself and execute the SQL ... >> Gulf Management Systems... (microsoft.public.sqlserver.programming)
Re: Recordset.open with existing Records in the DB ... I .close the objects wenn finishing der Program, ... The provider does not support the property. ... >> If i open my empty DB an read the Recordset,... > You will never get this CursorType.... (microsoft.public.data.ado)
Re: Recordset.open with existing Records in the DB ... >I have a strange Problem.... Perhaps you are not closing your Recordset and Connection ... You will never get this CursorType.... LockType into something else if the requested type is not available. ... (microsoft.public.data.ado)
