非淡泊无以明志,非宁静无以致远 -心静如止水,动于静

ORA-12154: TNS:could not resolve service name

Today, we made a SFC program, the strange is: when the code try to connect Oracle using TNS connection string, always pop up an error: "ORA-12154: TNS:could not resolve service name". Toad can use the same TNS connect Oracle on the same machine. After 2 hours trying, I found the project folder name has "(XXXX)", after I remove the "()" of ther folder, everything is OK!

P.S. There is another connection error when I 1st use Toad connect DB. because the sqlnect.ora file has one line: SQLNET.AUTHENTICATION_SERVICES= (NTS), after I modified: SQLNET.AUTHENTICATION_SERVICES= (NONE) is OK

posted @ 2010-05-22 18:48  烟雨客  阅读(554)  评论(0编辑  收藏  举报