1 Topic by Jason Lipman

  • Jason Lipman
  • Guest

Topic: Connection Error "OCIServerAttach failed"

I can connect to Oracle via other means, but in SqlDbx, when attempting a connection, I get the following error...

OCIServerAttach failed
ORA-12154: TNS:could not resolve the connect identifier specified.

I have three Oracle versions installed. I cannot tell in SqlDbx which version, or which TNSNAMES.ORA file is being referenced. Any ideas?

Quote Post 1

2 Reply by Jason Lipman

  • Jason Lipman
  • Guest

Re: Connection Error "OCIServerAttach failed"

Solved the problem. I moved Oracle 11 ahead of the other two versions in the computer's path variable. Now 11 is referenced and SqlDbx is making a connection.

I do not know why it failed to open Oravle 10.x, but it is working now.

Thank you.
Jason Lipman

Quote Post 2

Re: Connection Error "OCIServerAttach failed"

You can select Oracle home in Options->Oracle in Current Home  combo box.
Also you can see what TNSNAMES.ORA file is used. On login dialog select
Oracle as DBMS type and click "..." button.
You will see TNSNAMES.ORA file used on a bottom.

Quote Post 3