SqlDbx
You are not logged in.
Pages: 1
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?
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
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.
Offline
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
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
Offline
I had the same problem. Not sure if you have the same exact issue or not. Try this:
Offline
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.
Offline
Pages: 1