Re: Oracle ODBC connection problem

"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 Tue Sep 21 2004 - 08:07:25 CDT