Problems retreiving data from database

Results 1 to 2 of 2

Thread: Problems retreiving data from database

  1. #1
    stuvi Guest

    Default Problems retreiving data from database

    I am trying to access data in an access database via an asp page and display that data. I am confident that my sql script to access the data is correct, and I know that there is data there to be accessed. Nonetheless, when i read the data into a recordset, the recordset remains empty, as if there were no results from the query. I get the following error:<BR><BR>ADODB.Field error &#039 80020009&#039 <BR><BR>Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record. <BR><BR>Some help fixing this problem would be appreciated.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Problems retreiving data from database

    it can only be an error in the SQL script if what you say is correct.<BR><BR>try response.write()ing the SQL string to the page to see if there&#039s an obvious problem, then try running the SAME sql string from your RDBMS (access or SQL query analyzer)<BR><BR>j<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts