ONE Active Server Pages Product Home Page Developer Site Version


Connecting to a Database (DBMS)

MySQL databases are administered via database connections configured in DBMS. These connections are comprised of a title and the actual connection string used to connect to a database, and can be configured using DSN-based or DSN-less connection strings (data source names are collections of information required for connecting to a specific database).

Your first step in using DBMS is to create and establish a connection to a MySQL database. Once a connection is successfully established, DBMS can then be used to perform such tasks as creating and designing tables, adding and editing data, and querying the database using SQL statements. The tasks you can perform are determined by privileges granted by the database administrator.

Connection strings used to connect to a database are configured on the Add a DSN forms in DBMS.

Once successfully added, database connections are displayed in the left pane in the DBMS user interface, along with the tables and SQL statements associated with the connection.

A database connection node represents a DSN or connection string used to connect to a database. A connection is active if an ADO connection can be established using the parameters provided.

After connections have been added, clicking the words Database connections in the left pane displays a list of database connections and their connection status (connected or not). You can also click a specific connection.

Note icon Note You can only connect to an existing MySQL database on the MySQL server. The DBMS application cannot be used to create a new database.

This section describes how to add, edit, and delete DSN-based and DSN-less database connections.

In this section:

DSN-based Database Connections (DBMS)

DSN-less Database Connections (DBMS)