Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

> ## Preparing to create the schema holder

> This section addresses the steps required to create the schema holder.

> | To prepare to create the schema holder:

> 1. Verify that your MS SQL Server database is accessible and that you can connect to it. Transact-SQL and the MS SQL Server Query Analyzer can serve as a test for connectivity.

> 2. Verify that you have installed the ODBC drivers.

> 3. Once you have configured your data source (DSN), make sure that you can establish a connection independent of using the DataServer. From your DSN configuration, select to test the connection to MS SQL Server using the ODBC interface.

> 4. Start the DataServer as described in either the "Starting a local DataServer" section, or the "Starting a remote DataServer" section.

> 5. Open the Data Administration tool or the character Data Dictionary.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095