RE: Oracle 9i release 2 on Win2KSP4. .NET 1.1.. Exception from OracleC

From: Cowboy (Gregory A. Beamer) - MVP (NoSpamMgbworld_at_comcast.netNoSpamM)
Date: 11/04/04 

Date: Wed, 3 Nov 2004 19:08:01 -0800

Install the full client. SQLPlus only requires part of the Oracle Client to
connect. You will have to pull out the Oracle medium. I am sure there is a
way to install less than that, but I have not taken the time to find out how.

I would also suggest moving to ODP.NET, which you can download free from
otn.oracle.com. It is much better tuned to Oracle 9i. Not sure if this will
alleviate the Oracle Client full install or not.

Plug into your memory bank the fact that Oracle has changed the engine in
10g, so you will have to update software at the time you switch. Currently,
OracleClient does NOT work with 10g, so you have to switch to the ODP.NET
version for 10g (the 9i version of ODP.NET is not compatible with 10g either,
BTW, but the model between different ODP.NET versions is largely compatible). 

---
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"phronima" wrote:
> Hi
> I'm using System.Data.Oraclient client developing on the same machine
> as the Oracle Server. I'm able to talk to my database via SQLPlus but
> when I try to connnect via the OracleConnection's Open() method I get
> an error saying
> 
> System.Data.OracleClient requires Oracle client software version 8.1.7
> or greater.
> 
> I have Oracle 9i release 2 on the same machine. Any clues?
> 
> TIA
>

Relevant Pages

  • Re: Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... The project I'm trying to get running, consists of approx 25 seperate packages where 3-4 of them gets data from different Oracle sources, but I'm not even got to the point where I'm trying to run the whole lot. ... There are two issues in the topic that could be an issue, and that is to switch the whole project to 32-bit mode and then the part that says that the Designer only shows 32-bit versions of the provider. ... What I think I'll try now, it to install the 32-bit version of the Oracle ODAC to see if that makes any difference. ... uninstall ODAC and when I uninstall the regular Oracle Client with the ...
    (microsoft.public.sqlserver.dts)
  • Re: install DBD::Oracle on oracle application server
    ... I am trying to install DBD::Oracle on a box that has oracle application server. ... Is it a must that I have to install Oracle client for DBD to compile? ... You will need the client and development libraries and optionally the sqlplus - 3 tar files, you just untar anywhere and then set your LD_LIBRARY_PATH to the sdk dir before you run perl Makefile.PL. ...
    (perl.dbi.users)
  • Re: Questions related to DBI and DBD::Oracle
    ... You can use the Oracle Instant client for free and you can get it here ... If I install oracle.pm will that solve my problem or do I need to install oracle client on the unix box to make it work. ... so far you only have DBI or th Data Base Interface you need a Data Base ...
    (perl.dbi.users)
  • Oracle client
    ... I have just downloaded Oracle 10.2 XE for Debian x86 and installed it. ... I can connect to the database instance using SQLPlus and everything is ... From reading the documentation it appears I should install ... but just to get SQLPlus I have to download and install just under ...
    (comp.databases.oracle.server)
  • Re: SQL Server 2005 64-bit - Fetch data from Oracle 8i?
    ... Have I understood you right if I say you have managed to install a 32-bit Oracle client and a 32-bit Microsoft OLE DB driver for Oracle on 64-bit Windows 2003 Server? ... I have never installed any Microsoft OLE DB drivers for Oracle, ...
    (microsoft.public.sqlserver.dts)