Re: Problem in Connecting with win 95 with Oracle WG 7.3 on NT

Kári Poulsen wrote:
>
> Sounds like you need 32-bit ODBC on your window 95 client..
>
> Saud Kazim <saud.kazim_at_Cressoft.com.pk> wrote in article
> <saud.kazim.4.00193975_at_Cressoft.com.pk>...
> > We have an Oracle WG Server 7.3.2 on NT. We're using SQL*NET 2.3 on the
 Server
> > and SQL*NET 2.2 on the client running Windows 95.
> > When we connect from the client using SQL*PLUS there isn't any problem.
> > But when try to connect through ODBC using Oracle's ODBC Driver 1.14 we
> > encounter the error ORA-01321
> > No Interface driver connected.

Actually, I spoke to Oracle support about this exact error message yesterday (12/2). Here's what they told me:

1. Make sure that the Oracle Bin directory is in your path on the client machine
2. Make sure that your client machine has a TCP/IP connection to the server. Apparently SQL*Plus can get around this and connect anyway, but ODBC applications cannot.
3. If you are running a local connection (non-TCP/IP), then the ODBC SQL*Net connect string needs to be 2:orcl (instead of t:xxx:zzz)

        Hope this helps. In my situation, answer 3) was the one.

-- 
Jim Gilbert
Monsanto Corp.
St. Louis, MO
jwgilb_at_ccmail.monsanto.com