How To: Establish an ArcSDE connection using ArcGIS Schematics Designer
Instructions provided describe how to establish an ArcSDE connection as a data source in ArcGIS Schematics Designer.
Create a data source name (DSN) for the ArcSDE connection through the operating system.
a. Go to Start > Settings > Control Panel. b. Double-click Administrative Tools. c. Double-click Data Sources (ODBC). d. Select the User DSN tab. e. Click the Add button and select the appropriate driver for the type of RDBMS being used. f. Click the Finish button. g. Enter the connection information for the server. h. Test the connection. i. If the connection is successful, click OK on all windows.
Note: This will require that the RDBMS client tools be installed.
For ArcGIS 9.2 and 9.3, create a new schematic dataset.
a. Start ArcCatalog.
b. Click or create a folder in the Catalog tree.
c. Create a new personal geodatabase in this folder by right-clicking the folder, pointing to New, and clicking Personal Geodatabase.
d. Type a new name for the personal geodatabase, for example, SchematicDatabase.
e. Right-click the personal geodatabase, point to New, and click Schematic Dataset. A new schematic dataset appears in the Catalog tree.
f. Type a new name for the schematic dataset, for example, MyFirstSchematicDataset.
g. Press Enter.
h. Open the new schematic dataset in Schematics Designer.
Right-click on Data Sources and select Add Data Source.
Give the new SDE data source a name, select ADO, and click Edit Connection.
Select the Provider tab and select ESRI GeoDatabase OLE DB Provider.
Select the All tab.
Click on Data Source and then click the Edit Value button.
Select the ArcSDE DSN created in Step 1 and click OK.
Click on Extended Properties and click the Edit Value button.
Enter the instance, version, and workspace type using the following syntax and then click OK: