ODBC_DISCONNECT Procedure

Disconnect from an ODBC.

Usage

ODBC_DISCONNECT, connect_handle

Input Parameters

connect_handle—The connection handle to be freed. The connection handle is the value returned by ODBC_CONNECT.

Discussion

Use this procedure to disconnect from the data source when:

You are finished importing data from a data source and want to end the session and free the DBMS license seat.

You want to access the same data source, but using a different login string and the driver doesn't support multiple connections to the same DSN.

Example

In this example, the ODBC_DISCONNECT procedure is used to disconnect from the ORACLE database.

env_handle=ODBC_INIT()

oracle_id = ODBC_CONNECT(env_handle, 'ORACLE','scott/tiger')

emp = ODBC_SQL(oracle_id, 'SELECT * from emp')

ODBC_DISCONNECT, oracle_id

INFO, /Structure, emp