Re: ORA-03121 Unable to connect to Oracle via ODBC

From: Wes Matchett <wes_at_augustschell.com>
Date: Fri, 18 Sep 1998 17:01:17 -0400
Message-ID: <3602CA1D.BB392711@augustschell.com>

Tim Haynes wrote:

> In article <6tt8kr$bgd$1_at_hermes.is.co.za>,
> "Billy Verreynne" <vslabs_at_onwe.co.za> wrote:
> > Wes Matchett wrote in message <36016111.89FD9B6D_at_augustschell.com>...
> > >
> > >I have the exact same symptoms - except the error code is different:
> > >
> > >08003 - Connection not open.
> > >>
> > >> I got the following problem: I'm unable to connect to my Oacle-Server
> > >> (physically different machine) via ODBC. Connect via SQLNet works fine
> > >> (can connect to the DB with SQL Plus etc.) but not via ODBC. Always get
> > >> the error message (from OBBC-Test, MSAccess etc.) ORA-03121: no driver
> > >> connected - function not performed (translated from German).
> >
> > There's a couple of things to remember when using Oracle with ODBC.
> [none of which applies if you don't use SQL*net]

>


> > ODBC sucks. So don't expect any great performance nor any robustness from


> > Oracle ODBC drivers. Many times they do not even implement Oracle's SQL

> > properly. Real client-server software use a proper NATIVE(!) interface. ODBC
> > is fine for mickey mouse programs. IMO. :-)

>

> Well, the Oracle ODBC drivers may suck, as you eloquently put it. But not
> everyone's do - OpenLink offer a proper multi-tier architecture ODBC and JDBC
> driver, very compatible with Oracle, available for free evaluation non-expiry
> download from http://www.openlinksw.com/ onwards.
>

I have installed the MS ODBC and eliminated the problem. I am downloading the OpenLink drivers now for a quick test. I agree that the Oracle drivers are not as robust as others that are available.

I have been using ODBC for web server access for almost a year now with very good performance. ODBC was a poor performer in its infancy, but it has become quite stable and able to perform as it matures. We are using it to provide multiplatform server access to a web product with success.

-Wes Received on Fri Sep 18 1998 - 16:01:17 CDT