Run time Error 7004 : Row set is not bookmarkable

• • Reply

  17 years ago

  by jyotiraditya

  Jyotiraditya Rath

  , India

  Joined 18 years ago

  This was the code I have written....
  

  Code:

  
  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 = beq-local.world;userid=scott;password = tiger;Persist Security Info = True"
  

  
  cmdtext = "SELECT * FROM MY_TABLE"
  

  
  rs1.open cmdtext,connstr
  

  
  set datagrid1.datasource = rs1
  end sub
  

  
  

  
  Upto the rs1.open 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 ?

  Report abuse
• • Reply

  17 years ago

  by ItzMonika

  ItzMonika

  , United States

  Joined 18 years ago

  Jyoti,
  U forgot to set the CursorLocation Property of Recordset Object.
   
      rs.CursorLocation=adUseClient
  

  
  Hey  just copy this code line before openign ur recordset.
  

  
  U'll through.
  Bye.

  Report abuse
• • Reply

  10 years ago

  by jose4u

  jose paul

  Dubai, United Arab Emirates

  Joined 10 years ago

  Tank you for giving me this solution. Its working.

  Report abuse