HomeFlySpeed SQL QueryOracle conection didn't work with Flyspeed on windows7

Oracle conection didn't work with Flyspeed on windows7


Hello,

Oracle connection on Windows XP flyspeed installation is OK but
Oracle connection on Windows 7 flyspeed installation didn't work : ORA-12154: TNS

Test on two W7 PC with 2 different oracle clients
Jerome | email
March 31 2011, 04:53 AM
On my Windows 7 I set the TNS_ADMIN variable to tnsnames.ora full path, set the ORACLE_HOME variable to the Oracle client folder, set the content of tnsnames.ora file as follows and now I'm able to connect to oracle using the "XE" descriptor (I set "XE" to the Server name edit box in Connection Properties dialog):

XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.103)(PORT = 1521))
)
(CONNECT_DATA = (SID = XE))
)
Sergey Smagin | email
21 hours, 17 mins since original post
I follow you instructions but it didn't work.
I create a new variable :
TNS_ADMIN -> C:\oracle\product\10.1.0\Client_1\NETWORK\ADMIN

Set
ORACLE_HOME -> C:\oracle\product\10.1.0\Client_1

My tnsname is ok (I can connect my Sql Developer to Oracle)

Thank you for your help
Jerome | email
3 days, 23 hours since original post
Please find the updated article about your problem in the F.A.Q:
http://www.activedbsoft.com/faq-querytool.html
Sergey Smagin | email
6 days, 9 hours since original post
Dear Jerome,

We recently found that the problem may be caused by presence of special characters (parantheses) in the path to executable file. On Windows 64bit versions the executables are usually installed to "Program Files (x86)". One of our customers successfully solved this problem by re-installing FlySpeed SQL Query to the User's folder. I suppose the "<user>/AppData/Local/ActiveDBSoft/FlySpeed SQL Query" folder will be fine as this is also the folder to store SQL queries saved in connections.

Hope this will help you to cope with the problem.
Sergey Smagin | email
1 week, 1 day since original post
This topic is closed