Error: Unable to create a connection on server for user
When attempting to make a direct connection to your database, the following error message is returned:
"Unable to create a connection on server <arcsde>, for user <myuser>. Extended DBMS error code: 12154 ORA-12154: TNS:could not resolve service name."
The SDEHOME or ARCHOME variables need to be set to point to the ArcIMS installation location.
Solution or Workaround
Set an SDEHOME or ARCHOME variable pointing to your installation location at <ArcIMS Installation Directory>/server on Windows and <ArcIMS Installation Directory>/bin on UNIX.
For help with setting a system environment variable, see: How To: Edit an environment variable.