Progress
DataServer
for ODBC Guide


Connection Failures and Progress Responses

Table 4–4 lists circumstances under which a connection might fail and describes how Progress responds.

Table 4–4: 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 Progress Data Dictionary
The Data Dictionary displays an error message and returns to the main window.
During an attempt to connect a connected ODBC data source 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 ODBC data source 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 ODBC data source whose logical name is already in use by a connected ODBC data source
The system responds with a run-time error condition and you cannot connect to the second database.


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