Re: Oracle ODBC connection problem

This has to be one of the most pathetic problem I've ever run into.

My PATH was:
PATH=C:\blah;...; C:\oracle\ora81\bin;...;C:\blahblah; instead of:
PATH=C:\blah;...;C:\oracle\ora81\bin;...;C:\blahblah;

Noticed the difference? Neither did I in the beginning. There was a single *space* before the ORACLE_HOME directory in the PATH, and it seems xp does not handle this!! I had checked my PATH but could never ever imagine the problem came from this misplaced space. I am speechless, it costed me several days of work.

Thanks for pointing me into the right direction!!

SerGioGio

info_at_Boecker-OCP.com (Yukonkid) wrote in message news:<ed737cdd.0409210507.6017d299_at_posting.google.com>...
> "SerGioGio" <sergiogio_at_yahoo.fr> wrote in message news:<414fca4e$1_at_news.starhub.net.sg>...
> > Hello,
> >
> > I am going nuts. I am trying to connect to my local ORACLE instance using
> > ODBC.
> > It used to work few weeks ago, but it fails now.
> >
> > Connection with:
> > - SQL*plus: connection works!
> > - DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection
> > works when I hit the driver's "test connection"
> > but not anymore in real case scenario (using th DSN from an application).
> > - Oracle ODBC driver 9.02.00.05: connection does not work when I hit the
> > driver's "test connection", I get:
> > Unable to connect
> > SQLState=IM004
> > [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
> > failed
> > - Microsoft ODBC for Oracle 2.575.1022.00: cannot even configure the ODBC
> > data source, always get:
> > The Oracle(tm) client and networking components were not found.
> > These components are sypplied by Oracle Corporation and are part
> > of the Oracle Version 7.3 (or greater) client software installation.
> > You will be unable to use this driver until these components have been
> > installed.
> >
> > I am running Oracle version 9.2.0.1.0 on an xp Home Computer SP1 FAT32, and
> > trying to use ODBC on the same computer. I installed the Oracle client
> > version 9.2.0.5 to solve the problem but it did not work. I searched the
> > newsgroup for the error messages but could not find any solution solving my
> > problem - I do not think it is a permission problem on a registry or on a
> > file system directory. I also installed the latest MDAC with no success.
> >
> > This used to work but does not anymore!! I do not know how/when/why it got
> > corrupted. Does anyone have any clue on what could be going on here?
> >
> > Thanks in advance for your help,
> >
> > Regards,
> >
> > SerGioGio
>
> Hi,
>
> 2 recommendations:
>
> * check PATH setting on your Windows if the ORACLE_HOME containing the
> ODBC DLLs is listed first
> * Set your ORACLE_HOME explicit with "Oracle home selector" (should be
> available under the menu 'Oracle installation products'
>
> yk
Received on Fri Sep 24 2004 - 06:06:22 CEST