T_DBConfig_MsSQL

Describes the database configuration structure for a Microsoft SQL database.

Syntax

Definition:

TYPE T_DBConfig_MsSQL
STRUCT
    sServer: T_MaxString;
    sProvider: T_MaxString;
    sDatabase: T_MaxString;
    sUserID: T_MaxString;
    sPassword: T_MaxString;
    bAuthentification: BOOL;
END_STRUCT
END_TYPE

Parameter

Name	Type	Description
sServer	T_MaxString	Enter the name of your SQL server here. Example: "TESTSERVER\SQLEXPRESS"
sProvider	T_MaxString	"SQLOLEDB" or the provider of the SQL native client, e.g. "SQLNCLI10"
Database	T_MaxString	Enter the desired database name here.
sUserID	T_MaxString	Enter the user name here.
sPassword	T_MaxString	Enter the user password here.
bAuthentification	BOOL	Set this variable to TRUE to activate authentication based on user ID and password.

Requirements

Development environment	Target platform	PLC libraries to be linked
TwinCAT v3.1 Build 4020.10	PC or CX (x86)	Tc3_Database