Re: Access to Oracle database 8.1.7 via ODBC

"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 Fri Jun 18 2004 - 11:53:12 CDT