Speaking of MSDAORA, isn't that provider no longer supported? I thought it was meant only for Oracle 8i systems and below. It may be better to use the Oracle OLE DB provider.

If you connect to the Oracle database with SQLPlus and run the following, what do you get:

describe