Run time Error 7004 : Row set is not bookmarkable

vb6 India
  • 14 years ago

    This was the code I have written....


    Dim rs1 as new adodb.recordset
    Private Sub Command1_click
    dim connstr ,cmdtext as string
    connstr = "Provider = MSDAORA.1;Driver = {Microsoft ODBC for Oracle};Server=;database =;userid=scott;password = tiger;Persist Security Info = True"

    cmdtext = "SELECT * FROM MY_TABLE" cmdtext,connstr

    set datagrid1.datasource = rs1
    end sub

    Upto the statement it works fine..but at the line
    set datagrid1.datasource = rs1

    It gives error
    Runtime Error : 7004
    The rowset is not bookmarkable

    What is the cause of this error and ahow to prevent it ?

  • 14 years ago

    U forgot to set the CursorLocation Property of Recordset Object.

    Hey  just copy this code line before openign ur recordset.

    U'll through.

  • 7 years ago

    Tank you for giving me this solution. Its working.

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.” - Rick Osborne