CX-Supervisor Script To Modify A CX-Supervisor DB Connection

CX-Supervisor allows you to modify the database connection from within a script. This can be done using the DBExecute command as shown in the following example:

 

 

Where:

 

dbeSuccess = the success of the command

[myDatabaseConnection] = The database connection in CX-Supervisor

"Connection" = The command we are using on the database - do not change this

[database reference] = The reference to the database file (e.g. Microsoft Access .accdb file) or File DSN (.dsn) on the disk

{User Name} = Optional User name for a password protected MDB file

{Password} = Optional password for a password protected MDB file

 

It should be noted that this command does NOT take a replacement connection string as a parameter, it creates a new connection string from the parameters provided.

 

If using an mdb, accdb or other database file as the {database reference} parameter, CX-Supervisor runtime will select an appropriate installed driver for that database and create a connection string.

 

If using a File DSN, simply supply the path and filename of the FileDSN as the {database reference} parameter.

 

If your database is accdb and uses password protection or you use a workgroup or system database, you must create a File DSN containing the correct parameters and switch between DSN files rather than between Access Database files.

 

For details of supported databases in CX-Supervisor and further information on their use, consult Section 12 of the Manual - Databases. Additionally, remember that CX-Supervisor Machine Edition has support for just the Microsoft Access Database (.mdb and .accdb), if you need to use a File DSN you must upgrade to PLUS Edition.