Solved

oracle driver does not work on windows 7

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Introduction People like FTP.  It's a solid, stable, robust protocol for quickly transferring files between two hosts using TCP/IP.  In most cases it's much faster than SMB or CIFS, and certainly much easier to set up between organizations.  This…
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 …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

776 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