Connection String Generator dialog box

This dialog box helps you create a string to connect to your database.

To access
Click Connection String Generator in the Database Connection dialog box.
Relevant tasks
See also

User interface elements are described below:

UI Element
Test Connection…
Tests the connection to the database.
Generates the database connection string and writes it in the Connection String field in the Database Connection dialog box.
Server Name
The name or IP address of the database server.
DB Name
The name of the database.
The authentication method for the database: Windows Authentication or User/password.
  • User Name, Password. The credentials for the database.

SQL Provider
The SQL provider: OLEDB or SQL.