Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Weird error with rs.cachesize


Message #1 by "Keijo Kortelainen" <webmaster@2...> on Tue, 4 Sep 2001 10:34:46
I'm getting an error that puzzles me totally. I'm using ADODB(access 

driver) to make connection. Normally I'd use ADO-jet, but it has some 

weirdo bug with .cachesize which prevents me using it. Aniway. Page loads 

fine etc. until I increase the size of rs.cacheSize when bizarre things 

start to happen.  



Example:



...

rs.cachesize = 4

rs.Movefirst

Do Until rs.EOF

 'print out values

Loop

...



What I get is every n:th (n being the number in cachesize) row printed out 

whilst the others return blanc (nothing, zip, the big empty thing). Same 

goes for everyhing exept the number where row count mod is 0. 



What the heck is going on ? I've never come across something like this. Is 

it a ADO-Access driver bug or what ?



A very big thanx for all the help I can get!!!


  Return to Index