Is crystal 8.5 compatible with Pervasive 8? Which driver should be used?
I have a problem in that I have selected a field from a table on the pervasive database but the return of information is incorrect and inconsistent. The true data is for example, 0.053 yet when it shows in crystal it is 0.53.
If I create a file DSN rather than a system DSN, it works. I think it might be the driver but not being an expert in this area, I am not sure! I am now clutching at straws and would be grateful if anyone could shed some ligt on this.
I would suggest using the ODBC driver with Crystal REports. THere is a Btrieve driver but it hasn't been updated since Btrieve v6.15 so any of the new data types will not be supported. What exact version of Pervasive V8 (v8.xx.xxxx) are you using?
A FIle DSN has the same information as a System (or User) DSN so I'm surprised anything would be different.
Does the PCC show the correct data?
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.