Run time Error 7004 : Row set is not bookmarkable

vb6 India
  • 17 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 ?

  • 17 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.

  • 10 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.

“Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.” - Brian Kernighan