I'm using ADO to access a Pervasive 2000i database. I have this database installed at work on a Win98 machine and the same database at home on a WinXP Home machine. Using the exact same code, I get an Invalid Bookmark error, and can find no help on Pervasive's website.
Code:
cnTemp.ConnectionString = "Provider=PervasiveOLEDB;Data Source=" + PathToData
cnTemp.Open
rsTemp.Open "PracticeTable", cnTemp, adOpenDynamic, adLockOptimistic, adCmdTable
rsTemp.MoveFirst
PracName = rsTemp.Fields("PRAC_NAME")