Solved

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

Posted on 2008-06-18
2
1,450 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

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Creating and Managing Databases with phpMyAdmin in cPanel.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

758 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