Solved

oracle driver does not work on windows 7

Posted on 2013-12-17
4
187 Views
Last Modified: 2014-06-09
The error message when I am trying to run VB 6 application on windows 7:

Run-time error '-2147467259 (80004005)';

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified



I am running Oracle 9 data base
0
Comment
Question by:Leopoled
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
WalkaboutTigger earned 500 total points
ID: 39724740
Are you using the 32-bit or 64-bit Oracle driver?
To configure the 32-bit Oracle client on 64-bit windows, you cannot use the ODBC administrator from Control Panel and must instead use
C:\Windows\SysWOW64\odbcad32.exe
0
 

Author Comment

by:Leopoled
ID: 39738281
Would you please guide me in a little bit more details how should I configure the correct DSN if you believe this is the key to fix this problem. I am kind of new to Oracle and worked all the time with Microsoft SQL server. I still can not fix this problem for my company and it looks like nobody can help me in this case. Happy holidays and best wishes for the new 2014 year. Gregory
0
 
LVL 15

Expert Comment

by:WalkaboutTigger
ID: 39738774
Let me ask - what is the name of the Oracle client installation executable you used to install the oracle client?

In what folder did you install the Oracle client on the workstations?

Did you configure a TNSNames.ORA file?  If not, what is the IP Address and the name of the Oracle instance and the configured port for the instance?

I really need these answers to help you.

Happy holidays!

WT
0
 

Author Comment

by:Leopoled
ID: 40122073
I've requested that this question be deleted for the following reason:

I have resolved this question. Thanks
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Goal:  To set up a secure SSH server for your home computer to make it accessible anywhere AND to use it as a port forwarding proxy. Steps 1.  WinSSHD version 5 is free for personal use.  So download and install it.  You can download it from the…
Determining the an SCCM package name from the Package ID
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question