Re: Error in configuring ODBC Driver for Oracle7/8

I am facing the same problems for a while now. I already found out that the order of installation Oracle 7 and 8 clients make a difference.
Sometimes it will work when you install Oracle 8 first, afterwards Oracle 7 + intersolv driver. Never ever install Intersolv drivers after you only have installed the Oracle 8 client. Intersolv are Oracle 7 drivers which will overwrite or mess up some NT dlls, so Oracle 8 doesn't work anymore. Be also aware that Oracle 7 and 8 put their tns names files in different folders.

Help on this subject is welcome.

Oracle doesn't support 2 different client versions on 1 pc. BTW did you try ODBC test. I am only getting 'Dr Watson' fatal error' when I tried it.

Cheers,

Berbera

<pawan_at_ggn.hcltech.com> wrote in message news:8hcdvb$csj$1_at_nnrp1.deja.com...
> Thanks Don for the reply. I am still looking for the solution.
> Yes, client is MS machine. But I am not using Microsoft drivers. I have
> tried ODBC drivers with Oracle 8i cleint, and also from Intersolv also
>
> > Is the client a MS machine?
> > If so, make sure that you are using the Oracle ODBC drivers, not the
 default
> > Microsoft ones.
> > MS has a problem with multi-homed.
> >
> > Don
> Hi,
> I am facing problems in configuring ODBC drivers on my m/c. I want to
> access DB residing in Oracle 8 and Oracle 8i on UNIX. At my machine
> (client), I have installed Oracle 8i client (including ODBC driver, SQL
> Net etc.).I am able to access data through SQL Plus.
> But using ODBC driver, I am not able to access database. I have also
> installed Oracle 7 client (SQL *Net & ODBC drivers). But still same
> problem comes.
> tnsping (connectstring) gives ok.
>
> Following error comes, when i try to connect using ODBC DSN :
> SQL STATE : 01000
> Native Error Code : 444
> Driver Message: The driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 03.50
>
> It'll be a great help , if sombody can give some idea to solve this.
>
> TIA
> Pawan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jun 07 2000 - 00:00:00 CEST