473,739 Members | 2,375 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle ODBC connection problem

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
Jul 19 '05 #1
5 102554
"SerGioGio" <se*******@yaho o.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
Jul 19 '05 #2
"SerGioGio" <se*******@yaho o.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
Jul 19 '05 #3
<sy******@yahoo .com> wrote in message
news:a1******** *************** ***@posting.goo gle.com...

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
Jul 19 '05 #4
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:\bla hblah;
instead of:
PATH=C:\blah;.. .;C:\oracle\ora 81\bin;...;C:\b lahblah;

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.go ogle.com>...
"SerGioGio" <se*******@yaho o.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

Jul 19 '05 #5
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
Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1512
by: John Benson | last post by:
Thanks much for help with the Oracle db connection problem. That, plus some local assistance getting the sqlnet.ora default domain right, got everything fixed. Now I'm connected, and have been able to retrieve information from Oracle into my PC Python session. I seem to see a lot of advice asking people to google before submitting a problem to the list. This was nicely illustrated by the suggestion to google on the verbatim Oracle...
2
13643
by: GitarJake | last post by:
Hello all, I am trying to test an ODBC connection to an Oracle dbf using the ODBC Data Source Administrator. It's not working and I suspect I haven't configured Oracle correctly. Below is the error message I am getting: Invalid attribute in connection string: Description.ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
0
2415
by: M.L.Srinivas | last post by:
hi, This is my first task with MySQL. We have a site with php as front end MySql as back end. The remote database is on Linux. Now my task is to update some data to MySql database (on the web server) from VB. My operating system id Windows. I installed the MySQL ODBC 3.51 driver on my system. Now when i'm trying to create a DSN with the above driver, I'm getting an error '
1
4718
by: Cliff Cooley | last post by:
Can anybody suggest what may be causing the following problem ? I have an ASP script that opens a connection to an Oracle database using a DSN connection string, such as : Set dbConn= Server.CreateObject("ADODB.Connection") dbConn.Open "DSN=somedsn; UID=someuser; PWD=somepassword" With the ASP running on an IIS 5 server, using the Oracle 8 driver to connect to an Oracle 9 database, there are no connection problems, and
1
2091
by: lighthammer | last post by:
Hi I think i have a very unique issue .... Running 2 machines Win2000 / WinXP Both have Sql / Service packs Identical ODBC Setup The issue is as follows :
6
2142
by: hugenin | last post by:
Hello This is my problem: I hava a php script which collect data from a remote IBM DB2 AS400 , and puts them on a local MYSQL server. Calling it from a browser, it's fine. I want to launch it from command line using CLI ($php script.php) to put it in a cron job. Not working!
8
9636
by: Greg Strong | last post by:
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query work from
5
1855
by: SerGioGio | last post by:
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"
1
4574
by: Debabrata Jana | last post by:
Please go through the JAVA code below: class Main{ public Connection getConnection(){ Connection l_con = null; try { String hostname = "172.10.23.1:1527"; //Host IP:port No String dbsid = "TESTSID"; //SID Name or Service Name String username = "TESTUSER"; //Database user String password = "password"; //User password
0
8969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8794
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9483
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9341
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9211
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6756
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6056
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4572
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3282
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.