SQL Server Database

When you select Microsoft SQL Server as the Database Platform in the Add Database Connection Wizard, you must specify a SQL Server database to use with BarTender.

There are two ways to select an SQL Server database as your data source:

1. Type the server name into the Server field and the database name into the Database field. If the database requires a login, enter the user name and password into the corresponding fields. The Save User Name and Password to BarTender Document option saves the login information as part of the open document. This option is disabled for OLE DB data sources that do not have a user ID or password.

2. Click the Setup button to open the Windows Data Link Properties dialog. Enter the database path and file name and/or provide the necessary security credentials to access the database. For more information, refer to the Windows' help documentation.

Once you have defined a Microsoft SQL Server database, select Test Connection to verify that BarTender successfully connects to the database.

Related Topics

• Understanding OLE DB

Open topic with navigation