English

FAQ: What are the supported DBMS connection strings for Workstation ArcInfo?

Question

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"

Related Information