Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 31-10-2009
Member
 
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:
Quote:
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
Reply With Quote
  #2  
Old 31-10-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: Access database error 800a0cb3 after migrating server

My friend you have, in front, your answer!

Quote:
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.
Reply With Quote
  #3  
Old 31-10-2009
Member
 
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.
Reply With Quote
  #4  
Old 31-10-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Access database error 800a0cb3 after migrating server"
Thread Thread Starter Forum Replies Last Post
Exclusive Access to a SQL Server Database Deward Software Development 3 20-11-2010 05:00 AM
Migrating from Server 2003 R2 to Server 2008 R2, issues with logon script and network when old DC is powered down OctAvio2011 Operating Systems 5 20-08-2010 11:07 PM
Migrating from VBA database to ADO.net benico Software Development 1 16-08-2010 01:52 PM
Access database upgrade to SQL Server 2005 Umberto-Micro Software Development 4 13-02-2010 12:16 AM
Migrating oracle to MySQL database Laquan Software Development 4 09-02-2010 04:46 PM


All times are GMT +5.5. The time now is 11:30 AM.