Results 1 to 4 of 4

Thread: Access database error 800a0cb3 after migrating server

  1. #1
    Join Date
    May 2009
    Posts
    3,613

    Access database error 800a0cb3 after migrating server

    After having a migration from one server to another, I started receiving an error message that says:
    ADODB.Recordset error '800a0cb3'
    The recordset being does not support bookmarks. This may be a limitation of the provider or cursor type selected.
    /GenerationRMA.asp, line 62
    Everything worked fine on another server! Have you ever had this type of message? Do you know where it may come? For information my data is in an Access database, everything seems to work well otherwise.

    The line 62 GenerationRMA line is highlighted:

    Code:
    Contrat.Open cSQL, Connection, 1, 3
    If Not Contrat.EOF Then
      Contrat.PageSize = 20
      Contrat.AbsolutePage = cInt(currentPage)
    End If

  2. #2
    Join Date
    Jan 2008
    Posts
    1,521

    Re: Access database error 800a0cb3 after migrating server

    My friend you have, in front, your answer!

    The recordset being does not support bookmarks. This may be a limitation of the provider or cursor type selected.
    Since it worked before, it is not a concern of the cursor, so this is a limitation on this server.

  3. #3
    Join Date
    May 2009
    Posts
    3,613

    Re: Access database error 800a0cb3 after migrating server

    Yes I have read the error message properly but my question is how is this limitation possible? Where did the config is kind of limitation? Both servers have the same version of Windows 2003, the same versions of MDAC and the same version of IIS.

  4. #4
    Join Date
    Jan 2008
    Posts
    1,521

    Re: Access database error 800a0cb3 after migrating server

    Let IUSR_NameOfMachine user has privileges to read, write and change the directory where the database access and the file itself. The administrator may have the rights he wants: if IUSR_ ... lacks the proper permissions, it will not work.

Similar Threads

  1. Exclusive Access to a SQL Server Database
    By Deward in forum Software Development
    Replies: 3
    Last Post: 20-11-2010, 05:00 AM
  2. Replies: 5
    Last Post: 20-08-2010, 11:07 PM
  3. Migrating from VBA database to ADO.net
    By benico in forum Software Development
    Replies: 1
    Last Post: 16-08-2010, 01:52 PM
  4. Access database upgrade to SQL Server 2005
    By Umberto-Micro in forum Software Development
    Replies: 4
    Last Post: 13-02-2010, 12:16 AM
  5. Migrating oracle to MySQL database
    By Laquan in forum Software Development
    Replies: 4
    Last Post: 09-02-2010, 04:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,404,454.62995 seconds with 17 queries