well I found a 3rd party utility to log the actual SQL going to the Pervasive server. Here is what I get with my simple DALINQ query that should NOT have thrown an error:
SELECT "t0"."AddressLine1", "t0"."AddressLine2", "t0"."AdStarCode", "t0"."APClerk", "t0"."AutomaticNet", "t0"."Blank4a", "t0"."Blank7", "t0"."BoxCharge", "t0"."BSSPubNumber", "t0"."City", "t0"."ClassCodeJustify", "t0"."ClassCodeLength", "t0"."ContactName", "t0"."ContactPhoneNumber", "t0"."ContactsExtension", "t0"."ContractDefault", "t0"."ContractLength", "t0"."ContractRequired", "t0"."DaysAhead", "t0"."DaysPublished", "t0"."Deltas", "t0"."Discount", "t0"."DispPubNetCharge", "t0"."FaxCharge", "t0"."FaxNumber", "t0"."GrossOrNet", "t0"."HandJable", "t0"."InLinePubNetCharge", "t0"."InternetFeePub", "t0"."InternetFreePub", "t0"."IsAdstar", "t0"."IsVAT", "t0"."LastWriteDate", "t0"."LogoCharge", "t0"."ONLineHJ", "t0"."Phone", "t0"."PointSizes", "t0"."PubColWidth", "t0"."PubFontIndex", "t0"."PubName", "t0"."PubNumber", "t0"."PubsPayee", "t0"."PubType", "t0"."ReturnsAllLines", "t0"."Schlott", "t0"."SendToScienta", "t0"."SendViaPXAPI", "t0"."State", "t0"."SundayRate", "t0"."TotalYTDSpending", "t0"."ValidateLogo", "t0"."ValidPub", "t0"."WeekdayRate", "t0"."WhoPays", "t0"."ZipCode", "t0"."ZoneLength", "t0"."ZoneRequired", "t0"."Zones" FROM "pubfile" "t0" WHERE ("t0"."PubNumber" = :p0)(0019)
Its complaining on the where clause. Anything jump out at you?