Crystal Reports 8.0 and p2sodbc.dll

[jjfeigal]

I am using Crystal Reports 8.0 with p2sodbc.dll version 8.6.1.224 dated August 22, 2002. I have converted a report from a native driver to the ODBC driver. The report generates a flat text file where the size of each data field is required to be fixed in order for another application to process the file. In the Business Objects knowledgebase for Crystal Reports, CR36038 indicates that p2sodbc.dll for Crystal Reports 7 and higher trims spaces from fields and indicates that p2sodbc.dll version 6.0.0.72 or lower does not trim spaces. I downloaded and tested with the older version of p2sodbc.dll and verified that spaces are not timmed and my fixed format output file is maintained, but the generation of the report takes a 2 or 3 times longer.
First, is anyone aware of a newer version of p2sodbc.dll (higher than 8.6.1.224)where the problem has been fixed and spaces are no longer trimmed?
Second, while CR36038 provides a second work around to define a formula for each data field to add padding back to the data, this would be a huge undertaking for the four reports which I need to convert to the ODBC driver.
Third, does anyone have any suggestions for addressing this issue?
Thanks.

 

[synapsevampire]

CR 8 is no longer supported, so it's unlikely that you'll find a newer fix.

Consider using a newer version of Crystal, or perhaps you can pad with another character other than a space to work around this.

-k