Btrieve Error 8020 using Delphi 2010 and PDAC V11 (for Pervasive V11)
Posted on 2011-04-20
I recently purchased Delphi 2010 (actually purchase RAD Studio XE, but downloaded 2010 as well) so that I could use the newest PDAC from Pervasive to update my applications that I've written in Delphi 7 to connect to the Pervasive SQL Engine version 11.
I keep getting this Btrieve Error 8020, when I try to access the tables (after placing the PvSession component and PvTable on a form).
I've tried completely uninstalling the old Pervasive Client and PDAC (version 9.5) and re-installing the Client and PDAC for PSQL v11, and it still does not work. However, I can use the TPvSQLSession and TPvQuery components successfully, as well as the Pervasive Control Center (PCC) without problems.
The PSQL Engine v11 is running on a fully patched Microsoft Server 2008 R2, Dell PowerEdge T710 with 48GB Ram, Intel Xeon CPU Quad Core E5620 Processor, 64bit computer. The workstation is a Dell Precision T7400, with 2GB Ram, Intel Xeon X5450 processor, running fully patched Windows XP Pro Service Pack 3, with the Pervasive Client v11 (32bit) installed.
Any help would be greatly appreciated, as I cannot build all of my existing applications to work with the new server, until I get over this hurdle. And of course Pervasive wants another arm and leg to help me. I guess it doesn't matter that I've already spent over $5800 for the PSQL V11 Engine.....because they want to charge another $1000 for this one incident...go figure.