Oracle ODBC connection problem

[SerGioGio]

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

[sybrandb]

"SerGioGio" <se*******@yahoo.fr> wrote in message news:<41********@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

This version of the Microsoft driver has the location and the name of
the DLL hardcoded.
Consequently it won't work on any version other than 7.3
Oracle 9i is not certified against and support on XP Home.

Sybrand Bakker
Senior Oracle DBA

[Yukonkid]

"SerGioGio" <se*******@yahoo.fr> wrote in message news:<41********@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

[Michael D. Long]

<sy******@yahoo.com> wrote in message
news:a1**************************@posting.google.c om...

This version of the Microsoft driver has the location and the name of
the DLL hardcoded.
Consequently it won't work on any version other than 7.3
Oracle 9i is not certified against and support on XP Home.

Actually, this isn't correct. The latest shipping version of the Microsoft
ODBC Driver for Oracle worked fine with Oracle Client 8.0.x/8i. In fact, in
independent testing by Oracle Support the Microsoft ODBC Driver performed
better than Oracle's ODBC Driver and both the Oracle and Microsoft OLE DB
Providers available when 8i shipped.

--
Michael D. Long

[TomTom]

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:\blahbl ah;

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

in**@Boecker-OCP.com (Yukonkid) wrote in message news:<ed**************************@posting.google. com>...

"SerGioGio" <se*******@yahoo.fr> wrote in message news:<41********@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

[Raju]

Hi All,

Yes this is a know problem with xp and oracle 9i. If i'm correct i
found it on metalink(fix).

good luck.

Raju