SqlDbx Forum

Jason Lipman

Guest

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?

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

sqldbxhelp

Administrator

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.

Vijesh

Guest

Re: Connection Error "OCIServerAttach failed"

Hi All,

I am also facing the same problem. But I dont want to install any other version of Oracle Client. Please assist how to solve this issue. I have Oracle 10 client.

Vijesh

sqldbxhelp

Administrator

Re: Connection Error "OCIServerAttach failed"

Try to start SqlDbx with command line -l and take a look at file SqlDbx.exe.log which will be generated in the same directory where SqlDbx.exe located and email it to support (at) sqldbx.com

gap0134

Member

Re: Connection Error "OCIServerAttach failed"

I had the same problem.  Not sure if you have the same exact issue or not.  Try this:

http://sqldbx.com/forum/viewtopic.php?pid=1252#p1252

JEROLD

Member

Re: Connection Error "OCIServerAttach failed"

Tackled the issue. I propelled Oracle 11 of the other two forms in the PC's way factor. Presently eleven is referenced and SqlDbx is making an association.