[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7691
  • Last Modified:

problem with Oracle in OraHome92 driver

Hi all
I tryin to configure a new access to a database with my Oracle in OracleHome92 driver but fails with the next error message
"THE SETUP ROUTINES FOR THE ORACLE IN ORAHOME92 ODBC DRIVER COULD NOT BE FOUND. pease re. install the driver"

I'm re-instal from my oracle disks the connectivity utilities but, the result is the same.
how do i fix this problem, and re install correctly this driver.
thank you
ernesto
 
0
Ernesto
Asked:
Ernesto
  • 13
  • 12
  • 3
2 Solutions
 
mohammadzahidCommented:
How are you connecting to the database?
- SQLPLUS?
- External Application?

Why are you using ODBC? Is database on the same machine as client? What are the operating Systems?
0
 
ErnestoAuthor Commented:
Ok my server si Under W2K my client is wxp profesional.
the driver for connect to the database fails, I'm re-instal the client conectivity tools from my oracle cd, and the result is the same
i just want to do an odbc connection against my server.
The error is as descibed after
Than you
Ernesto

0
 
mohammadzahidCommented:
Are you trying to make database connection using ODBC Data Source Administrator?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ErnestoAuthor Commented:
yes
0
 
mohammadzahidCommented:
Ok, that is easy. All you need is a valid connect string. Here are the steps:

- Launch ODBC Data Source Administrator
- Select User DSN
- Click on Add
- Select Oracle in Oracle driver
- Click on Finish
- On the next window
Type for Data Source Name = Any thing
Description can be anything
TNS Service name = Select the one that works
Enter userid
and press Test connection
Enter password and then Ok.

Let me know the results.

0
 
ErnestoAuthor Commented:
yes i'm positive right is easy.
I have a problem with my odbc driver.
I don't kow why but isn't work, when i double click it for configure a new odbc string it gave me a
ugly error ""THE SETUP ROUTINES FOR THE ORACLE IN ORAHOME92 ODBC DRIVER COULD NOT BE FOUND. pease re. install the driver"
I'm re-install the driver but again isn't work
I don't know how to fix this problem.
My net configuration assistant neither work
when im trying to configure a listener gave me this error "the listener can't be created" (No se ha podido crear el istener)
and when Im triying to create a local network service name, the assistant simply do nothing, is not reach the assistant.
thats already the situation.
Thank you
0
 
mohammadzahidCommented:
I think your installation was not correct. Please use Oracle installer to remove Net and ODBC and then re-install. Please backup tnsnames.ora before removing components.

then re-install Net and ODBC using custom install option from installer.
0
 
ErnestoAuthor Commented:
I done before and still didn't work
I need to re-start my pc?
0
 
mohammadzahidCommented:
Your ODBC driver is not started, listener cannot be created, Net8 not coming up. I suspect installation error. Please remove those components and try again. Is this the first time these error are coming up?
0
 
ErnestoAuthor Commented:
yes it is
I re-install the components that you say, but the results are still the same,
the question is, I need to re- starr the pc for the changes take effect or is not necesary?
0
 
mohammadzahidCommented:
you can re-start PC but I doubt that it will fix the error.
0
 
ErnestoAuthor Commented:
I doubt to.
Who others alternatives I have?
1. I re install the componets (isn't work
2.-I re star the pc ( isn't work)
something else that i would do?
thank you
0
 
mohammadzahidCommented:
Please take a look at the url. It has some good tips on resolving your error. Hope this helps.
0
 
ErnestoAuthor Commented:
where do I find the Oracle92 drive for download and install it alone?
0
 
mohammadzahidCommented:
ODBC driver for Oracle9i comes with the software.
Here is the link from where you can download individual components.

http://www.oracle.com/technology/software/index.html

0
 
schwertnerCommented:
On both Server and Client immediatelly turn off the firewalls and the antiviruses.
Especially on the XP side.
0
 
ErnestoAuthor Commented:
what are you talking about schwertner, explain please?
0
 
schwertnerCommented:
I tried to install Oracle on XP and suddenly the installation fails.
After the panic period I realized that XP SP2 has default firewall
that has blocked port 1521. So the Listener installation fails ..
I had to remove Oracle and begin from scratch.

The same effect cause some antivirus programs ..
0
 
ErnestoAuthor Commented:
Ok,
result the same
thanks however
0
 
schwertnerCommented:
If by the installation the firewall was ON the
installation is defect.
You can turn off the firewall but this will not fix the corrupted installation.
So if you find working firewall then reinstall Oracle.
0
 
ErnestoAuthor Commented:
ok.
In the re installation I note several errors like, isn't registry some dll and cant and some more problems more.
turning off the firewall that installation will be succede?
you recomend me to re install again all the administrator client tools?
0
 
mohammadzahidCommented:
yes that will be a good idea.
0
 
ErnestoAuthor Commented:
I have the same errors
those are
Can't write oci.dll
Manually registry wfnvg.ocx
                         wfproc.ocx

ole inicializing errror or ocx at registering ocx

Those errors I have
any idea to fix it?
thank you



 
0
 
mohammadzahidCommented:
Do a clean un-install (remove entries from registry, remove files).
restart your computer and check files. If exist then delete them.

restart
and start installation of client software
0
 
ErnestoAuthor Commented:
WHAT REGISTRY FILES I NEED TO FIND AND DELETE?
PLEASE TELL ME
0
 
mohammadzahidCommented:
Delete Oracle_home entry from registory of the version you want to delete and remove files. RE-start machine and re-install client software.
0
 
ErnestoAuthor Commented:
Thanks a lot for the support you guys
see you in another
ernesto
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 13
  • 12
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now