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

Home -> Community -> Usenet -> c.d.o.server -> Re: Access to Oracle database 8.1.7 via ODBC

Re: Access to Oracle database 8.1.7 via ODBC

From: Yo Man <yo_at_man.fr>
Date: Mon, 21 Jun 2004 22:51:20 +0200
Message-ID: <40d749ec$0$23526$626a14ce@news.free.fr>


I upgrade MDAC to version 2.8
I use Microsoft ODBC Driver and the connection to database is ok now, but only in read. I can't write !!!

It's so complicated ! Snif

"Turkbear" <john.g_at_dot.spamfree.com> a écrit dans le message de news:c976d05gsp3g4cdesvin2l3o56m71f76ct_at_4ax.com...
> "Yo Man" <yo_at_man.fr> wrote:
>
> >Yes, sqlplus is ok.
> >I install Oracle server, so Oracle Client is install too.
>
> Not necessarily all its components.( The Client install has more user-type
components under the Custom install option)
> Do you have an Oracle OLE DB provider? If so, use that .
> If not, try the Microsoft OLE DB provider for Oracle , not the generic
ODBC one.
>
> hth,
>
>
> >I suspect an environment Oracle variable cause this problem. NLS_... or
> >TNS_... ????
> >
> >"Turkbear" <john.g_at_dot.spamfree.com> a écrit dans le message de
> >news:hts5d01ajacu2mlccai1ab7f9ced6pqh8k_at_4ax.com...
> >> "Yo Man" <yo_at_man.fr> wrote:
> >>
> >> >Hye,
> >> >
> >> >I have this error message on a Windows 2000 server with IIS5 and an
ASP
> >page
> >> >:
> >> >Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >> >Driver can't be loaded, system error 126
> >> >
> >> >
> >> >I upgrade MDAC, but nothing is better.
> >> >
> >> >Where is the problem exactly ????????
> >> >Thanks for your help.
> >> >
> >> Can you connect directly using SqlPlus?
> >> Is your Oracle client correctly installed?
> >>
> >>
> >
>
Received on Mon Jun 21 2004 - 15:51:20 CDT

Original text of this message

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