English

Error: Server path name dbi_odbc does not exist

Error Message

ArcInfo Workstation CONNECT command is used to access an external database from the ArcInfo Workstation command line. Running this command at version 10.0 returns the following error message:

"Server path name dbi_odbc does not exist".

Cause

The CONNECT command uses the Database Integrator (DBI). Esri can no longer update this technology to meet the needs of current database platforms. ArcInfo Workstation 9.3.x was the last release to include and support use of the Database Integrator.

Solution or Workaround

Warning:
Please be aware that Esri does not support this procedure, but the process described has allowed continuation of access of external database management systems (DBMS) using ArcInfo Workstation 10.


Note:
ArcInfo Workstation must be installed prior to performing these steps.


Note:
ArcInfo Workstation supports up to Oracle v. 9i, as listed in the system requirements web page below:

ArcInfo Workstation 9.3 System Requirements

Note:
If a more recent version of Oracle is installed, the connection may fail even though the workaround is performed.

The attached archive, AI_DBI.zip, contains the following files:

dbi_informix.exe
dbi_odbc.exe
dbi_oracle.exe
database\access.dbs
database\access1.dbs
database\informix.dbs
database\informix1.dbs
database\informx1.dbs
database\oracle.dbs
database\oracle1.dbs
database\sqlsrvr.dbs
database\sqlsrvr1.dbs

  1. Extract the contents of the ZIP archive to the local hard drive. Have the 'use folder names' or a similar option turned on.
  2. Copy the 'database' folder from the extraction location, and paste the folder and its contents to the following location:

    C:\arcgis\arcexe10x


    Note:
    This is the default installation location for ArcInfo Workstation. Paste to the appropriate location in the system if the installation location differs.

  3. Select and copy the three executable files from the extraction location, and paste into the folder:

    C:\arcgis\arcexe10x\bin

    dbi_informix.exe
    dbi_odbc.exe
    dbi_oracle.exe

Related Information