Re: .NET/Oracle/C#

[Glenn]

Pat

Haven't got a clue why that wouldn't work, but why not use ODP.NET instead
of the Microsoft Oracle Driver.

Glenn

http://www.oracle.com/technology/tech/windows/odpnet/index.html

"Pat Ireland" <ire...@airmail.net> wrote in message
news:1A6AF91A-66D0-4208...@microsoft.com...
> I am trying to do access a remote Oracle database
> I have Oracle 10g Client software installed on my PC (10.1.0)
> I have installed the .NET Oracle support from Microsoft.
> I have added a reference in my C# project to the System.Data.OracleClient
dll.
>
> I get the following error on the open for the connection:
>
> System.Data.OracleClient requires Oracle client software version 8.1.7 or
> greater
>
> I am using the following minimal code snippet:
>
> using System;
> using System.Data;
> using System.Data.OracleClient;
> .
> .
> .
> string strConnect = @"Data Source=\\devdbs\DMDC2CCD;USER
> ID=Y272913;PASSWORD=changepass";
> OracleConnection connOracle = new OracleConnection(strConnect);
> connOracle.Open();
>
> Any clues where to look next?
>

[Carlos J. Quintero [.NET MVP]]

Does SQL*Plus work?

Does the PATH variable include c:\Oracle\OraXX\Bin ? SQL*Plus does not
require it, but everybody else does.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

"Pat Ireland" <ire...@airmail.net> escribió en el mensaje

[Pat Ireland]

Carlos,

Thanks - now it is hitting the network looking for the server.

Pat

[Pat Ireland]

Glenn,

I tried download the ODP.NET and was reviewing the documentation when Carlos
responded. His technique worked but thanks for your reply.

Pat

[Slap]

I am having texactly the same problem.
SQLPLUS does work. Which PATH variable are you refering to?
Any help greatly appreciated.

"Carlos J. Quintero [.NET MVP]" wrote:

[Brian Gibbemeyer@discussions.microsoft.com W Brian Gibbemeyer]

In my case I had four different instances of the oracle client installed. Two
of the Bin directories were in the PATH variable. I had to remove the one
that was not registered as the ORACLE_HOME before it would connect
consistently.

"Carlos J. Quintero [.NET MVP]" wrote: