dbprocinfo

Returns information about a DBPROCESS connection.

Syntax

RETCODE dbprocinfo (
PDBPROCESS pdbproc,
LPDBPROCINFO pdbprocinfo );

Arguments

pdbproc

The DBPROCESS structure that is the handle for a particular workstation/Microsoft® SQL Server™ process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.

pdbprocinfo

A pointer to a DBPROCINFO structure that DB-Library will fill with information about the specified connection.

The DBPROCINFO structure is defined as follows:

typedef struct
{
   DBINT  SizeOfStruct;
   BYTE   ServerType;
   USHORT ServerMajor;
   USHORT ServerMinor;
   USHORT ServerRevision;
   CHAR   ServerName[MAXSERVERNAME+1];
   CHAR   NetLibName[MAXNETLIBNAME+1];
   CHAR   NetLibConnStr[MAXNETLIBCONNSTR+1];
} DBPROCINFO, PTR LPDBPROCINFO;

  

The DBPROCINFO fields are described here.

 

Field	Description
SizeOfStruct	Before calling dbprocinfo, set this field equal to the value returned by the C sizeof function for the DBPROCINFO structure.
ServerType	Is one of the following: SERVTYPE_MICROSOFT if you are connected to a server running SQL Server. SERVTYPE_UNKNOWN if you are connected to an unknown type of SQL Server.
ServerMajor	Is the XX value in the XX.YY.ZZZ version number of the SQL Server you are connected to. For example, 6.
ServerMinor	Is the YY value in the XX.YY.ZZZ version number of the SQL Server you are connected to. For example, 0.
ServerRevision	Is the ZZZ value in the XX.YY.ZZZ version number of the SQL Server you are connected to. For example, 101.
ServerName	Is the name of the SQL Server you are connected to
NetLibName	Is the name of the Net-Library DLL used to connect to SQL Server.
NetLibConnStr	Is the Net-Library connection string used to connect to SQL Server.

Returns

SUCCEED or FAIL.

Remarks

Before calling dbprocinfo, set the SizeOfStruct field equal to the value returned by the C sizeof function for the DBPROCINFO structure. The dbprocinfo function fills the supplied DBPROCINFO structure with information about the DBPROCESS connection.

See Also