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"