This content has been marked as final. Show 3 replies
I have a similar error. I can connect to database with TNSPING, and I can also connect with SQL Developer. But I am unable to connect with Access using ODBC, I get ORA-12154 error. Am also completely stumped. So if anyone can help, I would appreciate it too.
(P.S. I have tried on a number of PCs here in the office, on one PC I have here I can connect using Access and ODBC, I can see the tables, I pick on a table, it says "linking", but it never links - it just hangs forever.)
Thanks for any pointers,
..We solved our problem.
Previously I was using the system login and password. This gave the error.
I then used a specific user login and password for a specific schema and we got to our data OK.
The slightly annoying thing is that we did not get an error message - it just never linked and MS Access just hung when using the system login.
Best of luck with your problem.
it worked for my problem although its a toad issue
Thank you much