Error: Unable to store the address locator. Locator cannot be validated
** This issue is addressed with ArcGIS 9.2 Service Pack 1 (SP1). **
When creating a new address locator in an ArcSDE geodatabase using a Direct Connection, the following error may occur:
"Unable to store the address locator. Locator cannot be validated [The specified module could not be found.]"
This is a known issue in ArcGIS 9.2.
Solution or Workaround
In some circumstances, ArcGIS searches for the locator file in the wrong location. Download and install ArcGIS 9.2 Service Pack 1. See the corresponding link in the Related Information below for further information and to download ArcGIS 9.2 Service Pack 1.
Alternatively, one of the two bulleted options described below can be implemented to correct this error on clients using a Direct Connection. Perform one of the following solutions on each client machine making a Direct Connection to the geodatabase.
Remember, connections to Workgroup or Personal SQL Server Express geodatabases are always Direct Connections; therefore, it is necessary to perform one of the following workarounds on any client machine creating locators in a Workgroup or Personal SQL Server Express geodatabase.
- 1. Create a new folder called 'bin' under the existing bin folder in the ArcGIS installation location.
2. Copy the 'locssa.dll' file into the new bin folder.1. Open Windows Explorer and navigate to the bin directory of the ArcGIS install location. This is usually located at C:\Program Files\ArcGIS\bin.
2. Create a new folder named bin in this location.
3. Copy the file 'locssa.dll' from C:\Program Files\ArcGIS\bin and paste it into the newly created bin folder (C:\Program Files\ArcGIS\bin\bin).
- Specify the SDEHOME variable or ArcGIS install location in the service string in the Connection Properties of the spatial database connection. If the client machine has the ArcSDE software installed, set the SDEHOME variable to the ArcSDE installation location. If the ArcSDE software has not been installed on the client machine, set the SDEHOME variable to the ArcGIS installation directory.
1. In ArcCatalog, open the Database Connection Properties dialog box by right-clicking the geodatabase and clicking Connection Properties.
2. In the Service field of the Connection Properties dialog box, specify the correct path in the form:
<div id='indent' style='padding: 0em,0em,0em,1em;'>sde:<RDBMS>:<datasource>;SDEHOME=<SDEHOME/ARCGIS location>
If the ArcSDE software has been installed locally, enter the path to the ArcSDE installation folder. For example, for a direct connection to an Oracle database, type
<div id='indent' style='padding: 0em,0em,0em,1em;'>sde:oracle10g:/;SDEHOME=c:\arcgis\arcsde\ora10gexe
For a direct connection to a SQL Server database, type
<div id='indent' style='padding: 0em,0em,0em,1em;'>sde:sqlserver:mendota;SDEHOME=c:\arcgis\arcsde\sqlexe
If the ArcSDE software has not been installed locally, set the SDEHOME information to the ArcGIS installation directory. For example:
<div id='indent' style='padding: 0em,0em,0em,1em;'>sde:oracle10g:/;SDEHOME=c:\program files\arcgis
Tip: To create a file under the Database Connections node in ArcCatalog for a Workgroup or Personal SQL Server Express geodatabase, open the database server, right-click the geodatabase, and click Save Connection. Once there is a connection file under the Database Connections node, the Service information can be changed to point to SDEHOME. For example:
<div id='indent' style='padding: 0em,0em,0em,1em;'>sde:sqlserver:jersey\sqlexpress;SDEHOME=c:\Program Files\arcgis