decimals behaving badly

[birdman5]

Hi,

I have a report which on one machine displays all decimal fields correctly, but on another it displays 5.34e+269 on the first row, and then zero on all other rows. These would usually have data.

The only difference between the machines is that one has two ODBC connections to the Oracle database (System DSN and User DSN) and the other only the Oracle73 System driver (this is the one that works). If i remove the User DSN from the first machine the report does not run at all (The error is "Cannot open SQL server".

The version we are running is 8.0.1.0. Has anyone experienced this problem?

Regards,
Paul

 

[synapsevampire]

It sounds as though you're using the wrong ODBC driver.

Use the Crystal supplied Oracle ODBC driver, not the Oracle supplied one.

-k