ADO & Oracle 8i

I have written some ADO code and have been accessing Access tables without trouble. Now I have a need to use the same ADO code on similar tables created on Oracle 8i. In addition to having to change some SQL commands, now I found that I am not able to retrieve the Number data columns used in the Oracle tables. The recordset returned contains zero values for these columns but string columns seems to work fine. What could be wrong?

I am also facing problems in converting these columns to C++ variables. Could I employ the same Variant variables used for the Access database?

I hope somebody could provide some pointers on the above. Thanks in advance.

Regards,
lch