Number Property (Remote Data)

       

Returns a numeric value specifying a native error.

Syntax

object.Number

The object placeholder represents an object expression that evaluates to an object in the Applies To list.

Return Values

The return value is a Long integer representing an error number.

Remarks

Use the Number property to determine the nature of an error that occurred on the remote server or in the ODBC interface with the data source. The value of the property corresponds to a unique number that corresponds to an error condition generated by a stored procedure, a syntax or other procedural error, a permissions or rule violation or some other type of error. This native number can also be generated by a remote procedure executing a statement such as SQL Server's RAISERROR statement.

Note   The SQL Server error severity level is not returned by the ODBC driver, and is therefore unavailable.