Error while using the CLONE method

[Hanuman]

Has anyone received the following error while using ADO's CLONE method?

Runtime error '3251':
Object or provider is not capable of performing requested operation.

I haven't found any documentation on the error.

[Andrew Grillage]

It is likely that your recordset does not support bookmarks. Try using a
client side cursor.

--

Andrew Grillage
http://www.concresco.com


Hanuman <hanuman.haeseler@msdw.com> wrote in message
news:391c09dc$1@news.devx.com...
>
> Has anyone received the following error while using ADO's CLONE method?
>
> Runtime error '3251':
> Object or provider is not capable of performing requested operation.
>
> I haven't found any documentation on the error.

[Hanuman]

I'm using a client-side ADO recordset.
A sample of my code is below:

Dim conConnect As ADODB.Connection
Dim comGetRec As ADODB.Command
Dim recActivity(1 To 2) As ADODB.Recordset
Dim sSQL As String

Set conConnect = New ADODB.Connection
Set comGetRec = New ADODB.Command
Set recActivity(1) = New ADODB.Recordset

conConnect.ConnectionString = "filedsn=Code_Utility.dsn"
conConnect.Open
comGetRec.ActiveConnection = conConnect
recActivity(1).CursorType = adOpenStatic
recActivity(1).CursorLocation = adUseClient
recActivity(1).LockType = adLockReadOnly

sSQL = "select Node_Id from tblParentNode"
comGetRec.CommandText = sSQL
Set recActivity(1) = comGetRec.Execute

'The error occurs here
Set recActivity(2) = recActivity(1).Clone(adLockReadOnly)


"Andrew Grillage" <andrew@concresco.com.nospam> wrote:
>It is likely that your recordset does not support bookmarks. Try using a
>client side cursor.
>
>--
>
>Andrew Grillage
>http://www.concresco.com
>
>
>Hanuman <hanuman.haeseler@msdw.com> wrote in message
>news:391c09dc$1@news.devx.com...
>>
>> Has anyone received the following error while using ADO's CLONE method?
>>
>> Runtime error '3251':
>> Object or provider is not capable of performing requested operation.
>>
>> I haven't found any documentation on the error.
>
>