Progress
DataServer for
Microsoft SQL Server
Guide
Changing Connection Information in a Schema Holder
The Edit Connection Information utility allows you to change a SQL Server™ database’s connection information or logical name in the associated schema.
To change connection information for a schema holder, follow these steps:
- Access the Progress Data Administration tool, if you are not already there, and select DataServer
MSS SQL Server Utilities
Edit Connection Information. The following dialog box appears:
![]()
- Make changes to the Connection Parameters fields as required. When you are done, choose OK to return to the Data Administration main window.
The changes do not take effect until you disconnect and reconnect the schema holder. When you reconnect, Progress uses the new connection parameters.
For details on connection parameters, see "Connecting the DataServer," and the Progress Startup Command and Parameter Reference.
NOTE: If you change the ODBC Data Source Name (DSN), do not select a DSN that uses a different ODBC driver than the original DSN. Configuration switches residing in the schema holder are dependent on the driver name. You will receive only a warning if you use a different driver, but the schema holder configuration may no longer match the characteristics of the driver and might cause unpredictable run-time results.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |