VB6 (ADO) + Oracle 8 --- wierd problem

Select from any user table returns 0 records, but select from system tables works fine.
For example:
"select * from scott.emp" returns 0 rows. (no error message)
"select * from user_tables" works.

If I connect through SQL worksheet in the same way, I get my records. Is it a known ADO problem? Should I switch to DAO or RDO?

Please help!

Thanks in advance. Received on Fri Nov 19 1999 - 10:39:27 CST