ODP.NET

Hello,

I am using Microsoft Visual Studio 2005. I've created a new SSIS package and now I am trying to create a new data source that will connect to an Oracle 10g database. When I choose the drop-down menu to choose a data provider, I have three sections to choose from:

- .Net Providers (lists OracleClient Data Provider as an option)
- .Net Providers for Oledb (lists Microsoft OLE DB Provider for Oracle as an option)
- Native OLE DB (also lists Microsoft OLE DB Provider for Oracle as an option

Which one of these should I choose as the data provider? What are the differences?

I tried the OracleClient Data Provider option and entered in the database server name, my username for the database login, and my password, but when I click Test Connection, I get the following error: Test connection failed because of an error in initializing provider. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

How come? I did a little searching and found this page: http://blogs.msdn.com/b/spike/archive/2008/11/06/connecting-to-an-oracle-server-you-know-is-there-but-connection-still-fails-what-gives.aspx (if you search that webpage for "8.1.7", you'll see where it mentions the error that I am receiving)

..it says to change some registry keys, but I wanted to get some more info on this first.

Thanks all.

Edited by: DataHandle on Feb 9, 2012 10:01 AM