Error while using the CLONE method


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Error while using the CLONE method

  1. #1
    Hanuman Guest

    Error while using the CLONE method


    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.

  2. #2
    Andrew Grillage Guest

    Re: Error while using the CLONE method

    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.




  3. #3
    Hanuman Guest

    Re: Error while using the CLONE method


    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.

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center