FAQ: What Are the Supported DBMS Connection Strings for Workstation ArcInfo?

Answer

For the most complete information, please see the ArcInfo Workstation Online Help > Contents tab > Working with tables > Using DBI.

A link to the supported DBMS configurations and system requirements is found below in the Related Information section.

From the command line, use the CONNECT command:

Code:
connect <database> {connect string}

where the 'connect string' is one of the following:

For Oracle:

Code:
<username>/<password>

Code:
<username>/<password>@<alias>

Sample Oracle syntax:
Arc: connect oracle1 scott/tiger@pedro

---------------------------------------
For Informix:

Code:
database

Code:
//<servicename>/<database>

Code:
<database>@<servicename>

Sample Informix syntax:
Arc: connect informix //hogan_net/james

---------------------------------------
For Sybase:

Code:
<user>/<password>

Code:
<username>/<password>/<servicename>

Code:
<username>/<password>/<server>/<database>

Code:
-Uusername -Ppassword -Ddatabase -Sserver -Cclient character set

Sample Sybase syntax:
Arc: connect sybase sandy/sandy

---------------------------------------
For Ingres:

Code:
<database>

Code:
<vnode>::<database>

Sample Ingres syntax:
Arc: connect ingres hogan::sandy
---------------------------------------
For Microsoft Access:

Code:
<datasource>

Code:
DSN=datasource

Sample Access syntax:
Arc: connect access DSN=parcelsdb
---------------------------------------
For Microsoft SQLServer:

Code:
<datasource>/<user>/<password>

Code:
"DSN=datasource;UID=user;PWD=password"

Sample SQLServer syntax:
Arc: connect sqlsrvr "DSN=roads;UID=gisdba;PWD=gisdba"

Article ID:000004278

Software:

Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

ArcInfo Workstation System Requirements

What are the supported DBMS connection strings for Workstation ArcInfo?

Answer

Related Information

Discover more on this topic