Frequently asked question

What are the supported DBMS connection strings for Workstation ArcInfo?

Last Published: April 25, 2020

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

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options