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

> ## Connection failures and OpenEdge responses

> Table 6–5 lists circumstances under which a connection might fail and describes how OpenEdge responds.

> Table 6–5: Failure responses
> Failure circumstance | Result
> --- | ---
> During startup | The system displays an error message and returns to the operating system prompt.
> During a `CONNECT` statement | The system aborts the remainder of the `CONNECT` statement as though the remainder never existed, and a run-time error condition occurs. Any connections that you made prior to the failed connection remain in effect. You can use the `NO–ERROR` option with the `CONNECT` statement to trap run-time errors. If you use the `NO–ERROR` option and it fails, you see the same failure behavior as you do with an unsuccessful `CONNECT` statement. However, run-time error conditions do not occur.
> During an attempted auto-connect | The system aborts the remainder of the connect as though the remainder never existed, and a run-time error condition occurs. Any connections that you made prior to the failed connection remain in effect. You cannot trap auto-connect run-time error conditions.
> During an attempt to connect using the Data Dictionary | The Data Dictionary displays an error message and returns to the main window.
> During an attempt to connect a connected MS SQL Server database with a different logical name | The system responds with a run-time error condition but you can continue. You can use the `NO–ERROR` option to suppress the error.
> During an attempt to connect a connected MS SQL Server database with the same logical name | The system responds with a warning but you can continue. You can use the `NO–ERROR` option to suppress the warning.
> During an attempt to connect an unconnected MS SQL Server database whose logical name is already in use by a connected MS SQL Server database | The system responds with a run-time error condition and you cannot connect to the second database.

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