Is This Content Helpful?
We're glad to know this article was helpful.
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.
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.