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

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.

Regards,

~Tim

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 18 1998 - 11:12:55 CDT