Create Database Connection String

To display the Create SQL Connection String dialog, click Add/Edit Saved Connections > New > Build.

1. Select the type of database you want to connect to in the Connection Type list. The options are:

• "Access"

• "Excel"

• "MySQL"

• "OCI"

• "ODBC"

• "Oracle"

• "OracleLite"

• "QuickBooks"

• "SQL Server"

Note : In all cases described below you may enter the connection string directly into the Connection String field.

Access

If you selected "Access" for the Connection Type.

1. Optionally, click Create Database to create a new and empty database.

2. Otherwise:

1. Click to navigate to and select a .MDB database file, then click Open.

2. If necessary, enter your login name in the User field.

3. If necessary, enter your password.

4. Enter any additional parameters required by your database.

5. Click Test Connection.

6. If the connection was successful, click OK to conclude.

Excel

If you selected "Excel" for the Connection Type.

1. Optionally, click Create Database to create a new and empty spreadsheet file.

2. Otherwise:

1. Click to navigate to and select a .XLS file, then click Open.

2. If necessary, enter your login name in the User field.

3. If necessary, enter your password.

4. Enter any additional parameters required by your spreadsheet.

5. Click Test Connection.

6. If the connection was successful, click OK to conclude.

MySQL

If you selected "MySQL" for the Connection Type.

1. Enter the name of the server computer that contains the database in the Hostname field.

2. If necessary, change the port number.

3. Enter your login name in the User field.

4. Enter your password.

5. Click Tab to move to the Database field.

6. Optionally, select a database in the Database field.

7. Optionally, click Create Database to create a new and empty database.

8. Click Test Connection.

9. If the connection was successful, click OK to conclude.

OCI

ODBC

If you selected "ODBC" for the Connection Type.

1. Select the type of database you are accessing in the Data Source Name list. The options are:

• "dBASE Files"

• "dBASE Files" - Word

• "ECDCMusic"

• "Excel Files"

• "FoxPro Files - Word"

• "MQIS"

• "MS Access Database"

• "TeeChart Pro Database"

• "Visual FoxPro Database"

• "Visual FoxPro Tables"

2. Select the database vendor in the Vendor list. The options are:

• "Basic"

• "Excel"

• "MySQL"

• "Oracle"

• "OracleLite"

• "QuickBooks"

• "SQLAnywhere"

• "SQLServer"

3. Enter your login name in the User field.

4. Enter your password.

5. Enter any additional parameters required by your spreadsheet.

6. Click Test Connection.

7. If the connection was successful, click OK to conclude.

Oracle

OracleLite

If you selected "OracleLite" for the Connection Type.

1. Optionally:

1. Click Create Database to create a new and empty database.

2. Click OK to conclude.

2. Optionally:

1. Click to navigate to and select a database file, then click Open.

2. If necessary, enter your login name in the User field.

3. If necessary, enter your password.

4. Enter any additional parameters required by your database.

5. Click Test Connection.

6. If the connection was successful, click OK to conclude.

QuickBooks

If you selected "QuickBooks" for the Connection Type.

1. Click to navigate to and select a database file, then click Open.

2. If necessary, enter your login name in the User field.

3. If necessary, enter your password.

4. Enter any additional parameters required by your database.

5. Click Test Connection.

6. If the connection was successful, click OK to conclude.

SQLServer

If you selected "SQLServer" for the Connection Type.

1. Select the computer that is hosting the database in the Server list.

2. Optionally, leave Use Windows Authentication checked.

3. Otherwise:

1. Enter your login name in the User field.

2. Enter your password.

4. Optionally:

1. Select a database in the Database field.

2. Click Test Connection.

3. If the connection was successful, click OK to conclude.

5. Optionally:

1. Click Create Database to create a new and empty database.

2. Click OK to conclude.

See Also

Creating a Grid Component

Supported By

Alpha Five Version 7 and Above

Limitations

Web publishing applications only.