.NET/Oracle/C#

[Guest]

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?

 

[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

 

[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

 

[Guest]

Carlos,

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

Pat

 

[Guest]

Glenn,

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

Pat

 

[Guest]

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

 

[Guest]

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.