OdxIsConnected

OdxIsConnected checks if a connection, defined by the instance number, is connected.

Syntax

OdxIsConnected @instance

@instance integer
The instance number that was assigned when the connection was opened.

Options

Example

This example checks to see if the passed cursor is open and closes it if it is. It then checkes to see if the passed instance number is connected and closes it if it is.

CREATE PROCEDURE prODXDisconnect
@cursor_num int,
@instance_num int
AS
declare @status int
exec @status = master.dbo.odx_is_opened @cursor_num
if @status <> 0
exec @status = master.dbo.odx_close_cursor @cursor_num

exec @status = master.dbo.odx_is_connected @instance_num
if @status <> 0
exec @status = master.dbo.odx_disconnect_env @instance_num
GO

Top