Create SQL Connection String Dialog

The SQL Connection String dialog helps you define the connection string that you need to open a connection with an external database.

1. Select a Connection Type. The options include:

• "Access"

• "DB2"

• "Excel"

• "MySQL"

• "OCI"

• "ODBC"

• "Oracle"

• "OracleLite"

• "QuickBooks" (requires QOBC license)

• "SQLAnywhere"

• "SQLServer"

• "Sybase"

2. Some data sources first require that you select a file.

1. If the File Name control appears, click to navigate to and select a database.

2. If the User control appears, and a login is required, enter your user name.

3. If the Password control appears, and a login is required, enter your password.

4. If the Additional Parameters control appears, enter any additional parameters that may be required to connect with the database. [Picture]

3. Some data sources first require that you select a server.

1. If the Hostname control appears, enter the URL of the server.

2. If the Port control appears, enter the port number that the database monitors.

3. If the User control appears, and a login is required, enter your user name.

4. If the Password control appears, and a login is required, enter your password.

5. If the Database list appears, click Refresh and select a database.

See Also

Enterprise Reporting

Supported By

Alpha Five Version 7 and Above (Requires Enterprise Reporting License)