Solved

ODBC issue with 1 user account over several if not all machines

Posted on 2008-06-18
2
1,451 Views
Last Modified: 2013-12-18
We are having an issue with an account on our system.  The user in question is unable to get ODBC connections to work for them on any of the 3 servers that we have tried.  All of the other accounts have worked fine with no issues.  We even copied his account and used the copied account to test and it worked fine.

Other notes:  
"      Oracle SQL Plus will connect to the database under the persons account
"      We created a connection to another database server and the same issue exists for this person

Error:
Unable to connect
SQLState=08004
[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
0
Comment
Question by:evileyejoe
2 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 21816713
what does the sqlnet.ora,  tnsnames.ora and/or ldap.ora look like for the oracle home of that user?

that error means it tried to lookup what server and port to get to a database and couldn't find it.  It has nothing to do with privileges of the account.  
0
 

Accepted Solution

by:
evileyejoe earned 0 total points
ID: 21925546
They are the same for all users and it occurred with this user on each machine.  We created a new AD account for the person and it works now.... odd one.
0

Featured Post

New! My Passport Wireless Pro Wi-Fi Mobile Storage

Portable wireless storage to offload, edit, and stream anywhere.

High-capacity, wireless mobile storage designed to accompany professional photographers and videographers in the field to easily offload, edit and stream captured photos and high-definition videos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle RAC 12c 8 56
How to SQL Trace a SPECIFIC query 24 57
Copying MS SQL database does not copy default balues or identity specificatio 3 49
Sql Join Problem 2 27
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Creating and Managing Databases with phpMyAdmin in cPanel.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

911 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

22 Experts available now in Live!

Get 1:1 Help Now