Solved

Problems with Oracle ODBC with MS access 2010 and Windows 7

Posted on 2011-09-14
3
2,810 Views
Last Modified: 2012-05-12
Have windows 7 installed and access 2010, but when trying to use the Oracle ODBC through ms access, I get the following error:
ODBC - call failed
Microsoft ODBC driver for Oracle Oracle ORA-12154: TNS:could not resolve the connect identifier specified(#12154)Microsoft ODBC Driver Manager Driver's Sqlsetconnectattr Failed IM006 0  Microsoft ODBC driver manager driver's sqlsetconnectattr failed (#0).  
I installed access 2010 on my xp machine and it works fine.  Also can't get linked data manager to work or any of the wizards.  Uninstalled and reinstalled and still get the same issue.
0
Comment
Question by:sannunzi
  • 2
3 Comments
 
LVL 10

Expert Comment

by:ukerandi
ID: 36537058
What is the Oracle version you are using and may be you need to instllaed Oracle Path
0
 
LVL 10

Accepted Solution

by:
ukerandi earned 500 total points
ID: 36537068
This will help you to solve ure issue
http://ora-12154.ora-code.com/
0
 

Author Comment

by:sannunzi
ID: 37025953
Thanks
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

747 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

13 Experts available now in Live!

Get 1:1 Help Now