SqlIsAvail%

Determines whether a sqlconn connection is available for general use.

Syntax

SqlIsAvail% ( sqlconn% )

where

sqlconn%
Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

Returns

SUCCEED (1) if the sqlconn connection is available for general use; otherwise, FAIL (0).

Remarks

SqlIsAvail% indicates whether the specified sqlconn connection is available for general use. When a sqlconn connection is first opened, it is marked as being available until it is used. Many DB-Library for Visual Basic functions automatically set sqlconn to "not available," but only SqlSetAvail resets it to "available." This facility is useful when several parts of an application are trying to share a single sqlconn connection.

See Also

SqlSetAvail