Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: MSDAORA and Oracle 8.1.7 - problems establishing connection

Re: MSDAORA and Oracle 8.1.7 - problems establishing connection

From: Mike <okana!!nofuckingsp|am!!~_at_!!nofuckingsplam!!~voidnet.!!mapson!!.com>
Date: Fri, 29 Mar 2002 09:12:09 -0700
Message-ID: <Ev0p8.39043$x51.1392248@news.webusenet.com>


Cancel this - I see the answer from Matt Man on this topic - it was the answer I needed.

"Mike" <okana!!nofuckingsp|am!!~@!!nofuckingsplam!!~voidnet.!!mapson!!.com> wrote in message news:N_Io8.21018$x51.331330_at_news.webusenet.com...
> MSDAORA will not work on a client when the Oracle OleDB has been
installed.
> Don't ask me why but I think it's a pain in the @##. I have some things
> that will not work because a few of our databases are still on 8.0.5.
>
> You'll have to use the OraOLEDB.oracle to get a connection.
>
> Mike
>
>
> "Matt Man" <matt.mcdonnell.90_at_bc.edu> wrote in message
> news:b4aef96e.0203270908.1ade49c7_at_posting.google.com...
> > I am running the 8.1.7 Client from an NT box trying to connect to an
> > 8.1.7 Server running on Win2K.
> >
> > Net8 Assistant has no problems connecting to the database and with
> > some troubleshooting, the Oracle ODBC driver works fine, while the MS
> > ODBC driver for Oracle however will not... is there a related issue
> > here?
> >
> > I've been pouring over the archived newsgroups for the past 24 hours
> > and still cannot find a solution to my problem. I have put in the
> > TRS_ADMIN registry key, I've double and triple checked my tnsnames.ora
> > file and I've even added the service name to my local hosts file
> > (although I'm confident that this doesn't change anything anyway)
> >
> > There's a chance I might solve this by using OraOLEDB.Oracle
> > instead... but I wonder if there isn't a simpler solution. Switching
> > to OraOLEDB.Oracle now would blow-up my testing efforts.
> >
> > Any help would be GREATLY appreciated.
> >
> > Matt Man
>
>
>
Received on Fri Mar 29 2002 - 10:12:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US