.NET/Oracle/C#

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Ireland - 08 Jun 2005 15:22 GMT

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?

Reply to this Message

Glenn - 08 Jun 2005 15:38 GMT

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

> I am trying to do access a remote Oracle database
> I have Oracle 10g Client software installed on my PC (10.1.0)
[quoted text clipped - 20 lines]
>
> Any clues where to look next?

Reply to this Message

Pat Ireland - 08 Jun 2005 16:18 GMT

Glenn,

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

Pat

> Pat
>
[quoted text clipped - 30 lines]
> >
> > Any clues where to look next?

Reply to this Message

Carlos J. Quintero [.NET MVP] - 08 Jun 2005 16:00 GMT

Does SQL*Plus work?

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

Signature

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

>I am trying to do access a remote Oracle database
> I have Oracle 10g Client software installed on my PC (10.1.0)
[quoted text clipped - 21 lines]
>
> Any clues where to look next?

Reply to this Message

Pat Ireland - 08 Jun 2005 16:16 GMT

Carlos,

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

Pat

> Does SQL*Plus work?
>
[quoted text clipped - 26 lines]
> >
> > Any clues where to look next?

Reply to this Message

Slap - 22 Feb 2006 16:28 GMT

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

> Does SQL*Plus work?
>
[quoted text clipped - 26 lines]
> >
> > Any clues where to look next?

Reply to this Message

W Brian Gibbemeyer - 11 Aug 2007 03:24 GMT

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.

> Does SQL*Plus work?
>
[quoted text clipped - 26 lines]
> >
> > Any clues where to look next?

Reply to this Message

.NET/Oracle/C#

Free Magazines