ISQLServerErrorInfo::GetErrorInfo (OLE DB)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
Returns a pointer to an OLE DB Driver for SQL Server SSERRORINFO structure containing the SQL Server error details.
The OLE DB Driver for SQL Server defines the ISQLServerErrorInfo error interface. This interface returns details from a SQL Server error, including its severity and state.
Syntax
HRESULT GetErrorInfo(
SSERRORINFO**ppSSErrorInfo,
OLECHAR**ppErrorStrings);
Arguments
ppSSErrorInfo[out]
A pointer to a SSERRORINFO structure. If the method fails or there is no SQL Server information associated with the error, the provider does not allocate any memory, and ensures that the ppSSErrorInfo argument is a null pointer on output.
ppErrorStrings[out]
A pointer to a Unicode character-string pointer. If the method fails or there is no SQL Server information associated with an error, the provider does not allocate any memory, and ensures that the ppErrorStrings argument is a null pointer on output. Freeing the ppErrorStrings argument with the IMalloc::Free method frees the three individual string members of the returned SSERRORINFO structure, as the memory is allocated in a block.
Return Code Values
S_OK
The method succeeded.
E_INVALIDARG
Either the ppSSErrorInfo or the ppErrorStrings argument was NULL.
E_OUTOFMEMORY
The OLE DB Driver for SQL Server could not allocate sufficient memory to complete the request.
Remarks
The OLE DB Driver for SQL Server allocates memory for the SSERRORINFO and OLECHAR strings returned through the pointers passed by the consumer. The consumer must deallocate this memory by using the IMalloc::Free method when it no longer requires access to the error data.
The SSERRORINFO structure is defined as follows:
typedef struct tagSSErrorInfo
{
LPOLESTR pwszMessage;
LPOLESTR pwszServer;
LPOLESTR pwszProcedure;
LONG lNative;
BYTE bState;
BYTE bClass;
WORD wLineNumber;
}
SSERRORINFO;
Member | Description |
---|---|
pwszMessage | The error message from SQL Server. The message is returned through the IErrorInfo::GetDescription method. |
pwszServer | The name of the instance of SQL Server on which the error occurred. |
pwszProcedure | The name of the stored procedure generating the error if the error occurred in a stored procedure; otherwise, an empty string. |
lNative | The SQL Server error number. The error number is identical to that returned in the plNativeError parameter of the ISQLErrorInfo::GetSQLInfo method. |
bState | The state of the SQL Server error. |
bClass | The severity of the SQL Server error. |
wLineNumber | When applicable, the line of a SQL Server stored procedure that generated the error message. If no procedure is involved, the default value is 1. |
Pointers in the structure reference addresses in the string returned in the ppErrorStrings argument.