To connect using the ODBC provider, you either make a direct connection to a database or upload a file for the resource. The resource created from an ODBC database is always a feature source.
To connect to an ODBC database
- Click

.
- In the Connect To Data dialog box, select OSGeo FDO Provider for ODBC and click OK.
The Connection Editor is displayed to the right of the Site Explorer.
- For Type Of Connection, select one of the following:
- Optionally, select Specify User Credentials. Then do one of the following:
- If the database does not require a user ID and password, select Use Map Server Credentials.
- If the database requires them, select Use The Following Credentials and enter the user ID and password.
- Click Test Connection.
- You should see a Successful Connection message. If you receive an error, check the connection string carefully or verify that the DSN is set up correctly.
- If necessary, modify the string in the Connection String field or enter your own.
Note:
For Microsoft SQL Server, when entering the server name in the appropriate place in the Connection String window, you must enter the fully qualified Microsoft SQL Server 2008 server name. In many cases, this is the server name followed by the Microsoft SQL Server instance name.
- Click Reset to restore the automatically generated connection string.
- Optionally, under Define Geometry Properties To Create Spatial Feature Classes, select the tables and coordinate system to use to create geometry.
- Optionally, under Joins With Other Feature Sources, you can set up feature joins after you have saved the connection. For more information, see Using Feature Joins.
- On the Autodesk Infrastructure Studio toolbar, click Save to store this connection resource in the repository.