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