MySQL_ConnectionString

MySQL_ConnectionString (FB)

FUNCTION_BLOCK MySQL_ConnectionString

Short description:

This function block contains the login and server information.

Detailed description: The function block must be defined once in the PLC program. It stores all parameters of the other MySQL-FBox instances.

Attention: For stable functionality this function block should not be "called" within the PLC program.

InOut:

Scope	Name	Type	Comment
Input	xConnected	BOOL	TRUE: Successfully connected and logged in.
Input	sHost	STRING	MySQL server host address as hostname or IP address
Input	uiPort	UINT	MySQL server port (Default: 3306)
Input	sUsername	STRING	MySQL database username
Input	sPassword	STRING	MySQL database user password
Input	sDatabase	STRING	MySQL database schema name
Input	stServerInfo	MySql_ServerInfo	MySQL server information which are stored in the MySQL_ServerInfo structure
Input	hInternalSocket	RTS_IEC_HANDLE	internal_SocketHandle : __XWORD; // Socket handler
Input	internal_SemaBuffer	__XWORD	sema buffer
Input	abTxBuffer	ARRAY [0..gc_MySQL_dwTxBufferSize] OF BYTE	Transmit buffer
Input	abRxBuffer	ARRAY [0..gc_MySQL_dwRxBufferSize] OF BYTE	Receive buffer