English

Error: Unable to create a connection on server for user

Error Message

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."

Cause

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.