Because they are two different animals alltogether. But if you try some of the other connection strings shown in connectionstrings.com it should work. The other possibility is your web server is being blocked by a firewall. Have you asked your IT department
if they block connections to Oracle in any way?
bbcompent1
All-Star
32974 Points
8500 Posts
Moderator
Re: ORA-12154: TNS:could not resolve service name? - Oracle 9i 32bit version / Windows 64bit mach...
Apr 18, 2012 12:06 PM|LINK
Because they are two different animals alltogether. But if you try some of the other connection strings shown in connectionstrings.com it should work. The other possibility is your web server is being blocked by a firewall. Have you asked your IT department if they block connections to Oracle in any way?