maz
Thu Aug 02 11:54:33 CDT 2007
On Aug 2, 4:29 pm, Jesse Houwing <Jesse.houw...@nospam-sogeti.nl>
wrote:
> Hello maz,
>
>
>
>
>
> > I'm considering using MS .net provider for oracle to connect to an
> > oracle 10g R1 DB.
>
> > I was reading thru some documents and it seems that an oracle client
> > must be installed so i can use this provider.
>
> > However, how do I go about installing the client? I have Developer
> > Suite 10g (9.0.4), but I am not able to select from the installer
> > which components to install. I am given only 4 options (J2EE
> > installation, Rapid App Dev Installation, etc... but no custom
> > option).
>
> > What are my options?
>
> > Another thing to consider in this is that there already exists a
> > default home installation (pretty old forms/reports 6i) which MUST be
> > present on our production environment. So I have to install the new
> > Oracle Client in another oracle home. Will I be able to use the .net
> > provider for Oracle in this scenario?
>
> > Of course I can use OLEDB/ODBC providers instead if this doesn't work.
>
> > Thanks
>
> OleDB & ODBC providers also need the Oracle client installed. I've run some
> tests in the past with different versions of the OracleClient installed and
> this will cause you an enourmous headache for sure. I'd consider buildign
> a separate server with just the correct OracleClient version. You can download
> an installer from the Oracle website that contains just the client & providers
> for different systems. That download is your best bet I guess. The latest
> client can be found here (Oracle10g Release 2 ODAC 10.2.0.2.21)
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
>
> There are some 3rd party ADO.NET providers that acually let you select the
> Oracle_Home you want to use. The default driver from MS and Oracle don't
> have this ability I'm afraid. There are also some 3rd party ADO.NET providers
> that let you access Oracle without havign any oracle client installed at
> all. These drivers aren't free, but might be your easiest solution.
>
>
http://www.datadirect.com/products/net/net_for_oracle/index.ssp(100% managed,
> no Oracle client installation required)
http://www.crlab.com/oranet/(Option to bypass oracle client)
>
> Kind regards,
>
> Jesse- Hide quoted text -
>
> - Show quoted text -
Thanks Jesse, I will check this out.
I'm not sure what u mean by building a server with the oracle client
installed. How can I make the PC's where I will install the VB.NET
programs access the oracle client on this server u mentioned? As u can
see, I haven't had experience with any Oracle application platform
released after Forms 6i. I'd appreciate some pointers or references.
I'm a quick learner tho ;-)
Thanks again.
Mazen