skip to main content
Using the driver : Using connection properties : Client information properties
  

Try DataDirect Drivers Now

Client information properties

The following table summarizes connection properties which can be used to return client information.
Table 10. Client information properties
Property
Characteristic
Defines accounting information. This value is stored locally and is used for database administration/monitoring purposes.
The name of the application to be stored in the database. This property sets the program_name column in the sysprocesses table in the database.
The host name, or workstation ID, of the client machine to be stored in the database. This property sets the hostname column of the sysprocesses table in the database.
Specifies the user ID. This value is stored locally and is used for database administration/monitoring purposes.
The Media Access Control (MAC) address of the network interface card of the application connecting to Microsoft SQL Server. This value is stored in the net_address column of the sys.sysprocesses table.
The driver name and version information on the client to be stored in the database. This property sets the hostprocess column in the sysprocesses table.