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 5 102526
"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
"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
<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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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
|
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 '
|
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
|
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 :
| |
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!
|
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
|
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"
|
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
|
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,...
|
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...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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();...
|
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...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |