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

Home -> Community -> Usenet -> c.d.o.tools -> Re: MS ODBC connections have vanished with 8.1.6 - Help

Re: MS ODBC connections have vanished with 8.1.6 - Help

From: Michael D. Long <lead_dog_at_bellsouth.net>
Date: 2000/04/16
Message-ID: <dGnK4.85$QU.197316@news2.mia>#1/1

The Microsoft ODBC / OLE DB components only work with the Oracle client 8.0.5.x (or earlier).

Oracle's ODBC / OLE DB components work with 8.1.x.

Mike

"Ray Porter" <ray_porter_at_unc.edu> wrote in message news:8cv5md$1an$1_at_news2.isis.unc.edu...
> I don't have a solution but I'd be very grateful if you would consider
> sharing a solution if you find one. I just installed Oracle 8.1.5 and
 have
> been completely unable to get the MS Oracle ODBC driver to work (I've
 tried
> the drivers supplied with both MDAC 2.1 sp2 and MDAC 2.5 with no luck).
 The
> Oracle ODBC driver that came with 8.1.5, SQL Plus, etc., all work fine.
 I'd
> prefer to use the MS driver if I can make it work given all the bad
 reports
> I've heard about the Oracle supplied driver. It'd also be one less think
 to
> install since all my client workstations will have MDAC anyway.
>
> Thanks,
>
> --
> ================================================
> Ray Porter
> Applications Analyst Programmer
> Administrative Information Services, UNC-CH
> Phone: 966-5878
> email: ray_porter_at_unc.edu
> dragon_at_email.unc.edu
> Home Page: http://www.unc.edu/~dragon/
>
> "Meddle not in the affairs of dragons,
> for thou art crunchy and taste good with ketchup."
>
>
> "Ken Sproule" <kenmn_at_tds.net> wrote in message
> news:1s84fso5kgqpjkm91cfvbds6h4115isup3_at_4ax.com...
> > Thanks in advance.
> >
> > I have 8.0.5 on x:\orant and 8.1.6 on y:\oracle8i.
> >
> > After installing 8.1.6, any connections attempted using Microsoft's
> > ODBC driver fail and I get an
> > "Error while trying to retrieve text for error ORA-00000".
> >
> > I assume there is some sort of configuration issue or some dll, etc
> > got overwritten.
> >
> > Any ideas?
> >
> > Best,
> >
> > Ken Sproule
> > kenmn_at_tds.net
> >
> >
> > Ken Sproule
> > kenmn_at_tds.net
>
>
Received on Sun Apr 16 2000 - 00:00:00 CDT

Original text of this message

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