I have an ado recordset that used to connect to an oracle 8.0.5 database and now have upgraded to oracle 8.1.6.

Now, when trying to read a numeric field I get zero.

If I use the data environment designer, I get the correct data, and if i run the query through SQLPlus (oracle tool) I get all the right values.

It's only when I use the ado objects that I can not read the right numbers.

Also my synonyms seem to be valid anymore through the ado ojects as well.

What do I need to do to see numeric fields?