Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Differences between Oracle OLEDB Provider & Microsoft version

645765Jun 18 2008 — edited Jun 18 2008

I am trying to connect to an Oracle database from a SQL Server SSIS package. When I use the Microsoft OLEDB Provider for Oracle (MSDAORA) the connection manager in the package sees a full list of the tables in the Oracle database but when I use Oracle's own OLEDB provider (Oracle.OLEDB.1) I see a much smaller list. I cannot see anything different about the tables that Oracle's Oracle provider fails to see. Has anyone come across this phenomenon before ? Are there some table name characters or data types that the Oracle provider objects to ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2008

Added on Jun 18 2008

#general-database-discussions

3 comments

829 views