Terminates a connection to a data source.
- Specifies the statement handle to the data source returned by SQLCONNECT(В ). Specify 0 for nStatementHandle to terminate all active connections.
Numeric. SQLDISCONNECT(В ) returns 1 if the connection is successfully terminated, вЂ“ 1 if there is a connection level error, and вЂ“ 2 if there is an environment level error.
SQLDISCONNECT(В ) terminates a connection to a data source. You must supply the statement handle that SQLCONNECT(В ) returned when you established the connection.
|If you execute SQLDISCONNECT(В ) within an asynchronous function sequence or during a transaction, SQLDISCONNECT(В ) generates an error.|
The following example assumes an ODBC data source called MyFoxSQLNT is available. SQLCONNECT(В ) is issued, and its return value is stored to a variable named
If you successfully connect to the data source, SQLCONNECT(В ) returns a positive number, a dialog box is displayed and SQLDISCONNECT(В ) is used to disconnect from the data source.
If you cannot connect to the data source, SQLCONNECT(В ) returns a negative number and a message is displayed.
STORE SQLCONNECT('MyFoxSQLNT', '<userid>', '<password>') TO gnHandle IF gnHandle <= 0 = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error') ELSE = MESSAGEBOX('Connection made', 48, 'SQL Connect Message) = SQLDISCONNECT(gnHandle) ENDIF