skip to main content
OpenEdge Data Management: DataServer for ODBC
The DataServer Tutorial : Changing connection information in a schema holder
 

Changing connection information in a schema holder

The Edit Connection Information utility allows you to change ODBC data-source connection information or logical name in the associated schema.
To change connection information for a schema holder:
1. Access Data Administration, if you are not already there, and select DataServer > ODBC Utilities > Edit Connection Information. The Create/Modify Database Record for DataServer Schema dialog box appears:
2. Make changes to Connection Parameters as required. When you are done, click 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, OpenEdge uses the new connection parameters.
For details on connection parameters, see The DataServer Tutorialand OpenEdge Deployment: Startup Command and Parameter Reference.
Using the Edit utility to change the logical name of an ODBC data source causes the tool to close; this is because you started the tool when you were connected to the data source under another name. To continue working with the utilities, simply restart the tool.
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 driver name. You will receive only a warning if you do use a different driver, but the schema holder configuration may no longer match the characteristics of the driver and cause unpredictable run-time results.