Re: 2005 cluster can't find Oracle client or local system OOBC

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Perhaps this will help you:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclientoracledataadapterclasstopic.asp


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"FidelR" <fidelr@xxxxxxxxxxxxxxxxx> wrote in message
news:C067C753-AA4D-44DB-9A70-C7B3E5F286EF@xxxxxxxxxxxxxxxx
Hi,

I have 2 nodes SQL Server 2005 Ent. 64 bit SP1 cluster on Win2003 R2 Ent.
I
would like to connect via SSIS to an Oracle DB. I don't get any Oracle
data
providers on the list of providers. When I try to use one of the MS
providers
like MS OLE DB for Oracle I get "Oracle client and networking components
were
not found". Oracle client (10.2) is present and working properly. When I
try
to use ODBC provider like .Net Providers\Odbc data provider, I get no
system
data source names in the list although I configured and checked system
data
sources on this cluster node.


.

Relevant Pages

  • Re: oracle 10g cryptography problem
    ... and load third-party providers to the Oracle VM. ... that there was a bug in 10.2.0.1 that prevented third- ...
    (comp.databases.oracle.misc)
  • Re: oracle 10g cryptography problem
    ... Unfortunately sunjce only supports RSA in jdk 1.5+ and for jdk 1.4 ... and load third-party providers to the Oracle VM. ... party providers from working inside the Oracle VM, ...
    (comp.databases.oracle.misc)
  • Re: Database speed issues
    ... Those sold by Microsoft, Oracle itself and DataDirect. ... "OSFA") providers like ODBC and OLE DB that expose less native functionality ... shouldn't be considered the ideal way to conenct to the Oracle Database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database speed issues
    ... There are at least three different "native" managed providers for Oracle. ... Those sold by Microsoft, Oracle itself and DataDirect. ... shouldn't be considered the ideal way to conenct to the Oracle Database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle Function
    ... where I was having a problem with the Microsoft version of the Oracle ... Oracle providers solved this problem, but after I switched all of that ... Wrap the function in a proc ... >> datareader or ExecuteScalar, nothing is ever return. ...
    (microsoft.public.dotnet.framework.adonet)