Basic connections to databases in ScriptWorx are stored as reusable connections, which can be used as the basis for creating dynamic page controls or database actions.

To Create Connections: Choose "Connections" on the Database CCP.

What you need to create a connection, can be summarized as follows:

• A unique name for the connection in ScriptWorx.
• The username and password for your database.
• The name of the database (MySQL)/SQL Serveror the filename (ADO/ODBC).
• The DSN of your database (ADO/ODBC) or the server name (MySQL/SQL Server).
• The table you wish to connect to.

A unique name is used to save your connection, so that you can reload or modify the connection as required. Usernames and passwords are mandatory for MySQL connections, but may also be needed for ADO/ODBC connections.

The database name is the identifier of your MySQL database, whilst a filename is required for ADO/ODBC connections, which acts as the database name. Similarly, a server name is needed for your MySQL server, whilst ADO/ODBC connections require a DSN.

You may optionally specify a table, although you can change this if you wish.