Solved

oracle driver does not work on windows 7

Posted on 2013-12-17
4
183 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Have you ever stumbled upon a software that is so great that you just love? It happened to me. Love at first sight. Filezilla Server.   Ok its not the most advanced ftp server I've came across. But its a fairly simple piece of software to get the …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now