I practiced my website on my local harddisk with a mdb database. Now, I upgraded to the internet using a SQL server. This works great for showing data but I can't get it to append data. On all my pages I use a script for counting the visits to that page and write it in a table.
This is the code where it goes wrong: Code:
I formatted my PC last night, re-installed IIS and set up all my backed-up web pages.
When I tested everything to see if it worked everything seemed fine until this morning.
I tried to add a record to an Access DB and was given the following error:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
I have not changed any of the code and this website has worked for arounf 6 months with no errors.
i tried lots of thing, including changing the Recordset's LockType, and when it set to "4" i did not get any error, but the record wasn't inserted to the DB.
View Replies View RelatedI am using ms-access, a database which is updated frequently (actually all the time) by users. Each use of an asp page by any user updates one record in this database.
In order to keep multiple updates to the same record, when occur, up-to-date (and of course to other records as well), and in order to avoid crash, but not slower the access, what cursortype and locktype shall I use?
adOpenDynamic, AdLockOptimistic
Or
adOpenDynamic, adLockPessimistic
Or
adOpenDynamic, adLockBatchOptimistic
Is there any way to modify the locktype when updating a database via a connection object's execute method? I have a game which worked completely fine when only ten or so people were playing, but as it grew into the hundreds, many people started getting errors and I'm 99% sure that they occur when the database tries to update when it's locked, which means that my connection execute statements are defaulting to pessimistic locking, which I don't want them to. Does anyone know how I can fix this?
View Replies View RelatedI keep getting an error about my locktype with this code when attempting to update. Code: