Name

Description

CreateSQLConnection

It will call the CreateConnectionID of the cCLIHandler class that will be used to open SQL tables. Note that you normally don't need to send this message as it is made automatically by the Database Update Framework.

ConstructConnectionString

Constructs a proper connection string. Pass; sServer, sDatabase, bTrusted, sUserID and sPassword.

AutoSetConnectionID

Called when the object is constructed. It will check the psDriverID for a ConnectionID and save it as the psConnectionID property. It is used whenever a login to the database is needed.

DeComposeConnectionString

Takes a connection string as parameter and returns a tSQLConnectionSettings struct with the; sConnectionID, sServer, sDatabase, sUser, sPassword and bTrusted parameters.

ParseKeyWord

Sub function used to extract keywords from a connection string.

RedirectConnection

Redirects a database connection. Pass the old connection string and a new one. Makes changes to the cCLIHandler object.

RemoveExistingConnectionID

This is needed when the connection ID in the SQLConnections.ini file also exists in e.g. the MSSQLDRV.ini file. It is then needed to delete that one before creating a new one from the SQLConnections.ini file. Else an error will be raised that the ID already exists.

ExistingConnectionSettings

Returns a tSQLConnectionsSettings struct with all of the current connection settings for the passed driver ID and connection ID.

UpdateConnectionString

This will update the connection settings of the cCLIHandler object. Pass a tSQLConnectionSettings struct.