Properties for cSQLConnectionHandler

Name

Description

phoSQLConnectionIniFile

A handle to the child object of class cSQLConnectionIniFile.

psDriverID

The database driver (e.g. DataFlex, MSSQLDRV, DB2_DRV, ODBC_DRV, ORAFLEX, SQLFLEX, MDSPgSQL or MDSMySQL). Automatically maintained by the Database Update Framework via the SQL Connections Tool, but can be overridden in a cDbUpdateVersion object.

psConnectionID

The connection ID used in the application and *.int files. Automatically maintained by the Database Update Framework.

psConnectionString

The connection string that is used by the database driver to login to the database.

psServer

Part of the psConnectionString. Changing this property automatically changes the psConnectionString's content and creates/recreater a cCLIHandler connection.

psDatabase

Part of the psConnectionString. Changing this property automatically changes the psConnectionString's content and creates/recreater a cCLIHandler connection.

psUserID

Part of the psConnectionString. Changing this property automatically changes the psConnectionString's content and creates/recreater a cCLIHandler connection.

psPassword

Part of the psConnectionString. Changing this property automatically changes the psConnectionString's content and creates/recreater a cCLIHandler connection.

pbTrusted

Part of the psConnectionString. Changing this property automatically changes the psConnectionString's content and creates/recreater a cCLIHandler connection.

piDbType

Database type; Microsoft SQL Server, IBM DB2, Oracle, MySQL or PostgreSQL. This is a enumeration type and can be any of; EN_DbTypeMSSQL, EN_DbTypeMySQL, EN_DbTypeOracle, EN_DbTypeDB2, EN_DbTypePostgre or EN_DbTypeDataFlex.

psSchema

The Schema name (or Owner name for Microsoft SQL Server)

psBaseTableSpace

For IBM DB2, Oracle and PostgreSQL

psLongTableSpace

For IBM DB2

psIndexTableSpace

For IBM DB2, Oracle and PostgreSQL

pbSilentLogin

If silent login to the database. If login fails the database back-end login dialog will not be displayed.

pSQLConnectionData

Property that contains all of the data from the SQLConnectionData struct

ghoSQLConnectionHandler

A global object handle that can be used to call any property or message of this class.