Open topic with navigation

Using Named Database Connections

When you have configured a database connection in Process Builder that you want to use in other process files and actions or in other applications in the BarTender suite, you can save the database connection as a named database connection. Named database connections save your connection properties and parameters so that you don't have to re-enter them every time you use them. If the connection parameters change, you can edit them in one place rather than in every place that uses the connection.

ClosedTo create a named database connection

  1. On the property tab for a database action, click Database Connection Setup to open the Database Setup dialog.

    If you have not previously connected to a database, you must complete the Database Setup wizard to open the Database Setup dialog. The Database Setup wizard starts when you click Database Connection Setup.

  2. On the Connection Properties page, click Create named database connection.

  3. In the Create Named Database Connection dialog, enter the name that you want in the Name field, and then click OK.

ClosedTo modify a named database connection

On the Connection Properties page of the Database Setup dialog, click Configure named database connection to start the Database Setup wizard. Use the wizard to modify the named database connection.

When you modify the configuration settings for a named database connection, all other process files, actions, and connections in other BarTender applications that use the named database connection are affected.

ClosedTo connect to a database by using a named database connection

  1. On the property tab for a database action, click Database Connection Setup to start the Database Setup wizard.

  2. Click to select Use an existing named database connection, and then click the named database connection that you want to use.

  3. Click Next, and then complete the steps in the wizard.

    If you try to use a named database connection that references a text, Access, or Excel database in an Insert Database Record, Delete Database Record, or Update Database Record action, you will receive an error message. These actions do not support these database types.

ClosedTo stop using a named database connection

In some cases, you may want to stop using a named database connection with a particular process file and create a separate copy of the connection settings that is used only within that process file. To do this, click Stop using named database connection on the Connection Properties page of the Database Setup dialog. Any subsequent changes that you make to the unnamed database connection apply only to the current process file. The named database connection is still available to other process files and actions and to other applications in the BarTender Suite.

Related Topics