Rockwell Automation RSBizWare BatchCampaign Users Guide - Manual (Page 22)

RSB IZ W ARE B ATCH C AMPAIGN U SER ’ S G UIDE
28
• •
•
•
•
4. On the Provider tab, select the database type you want to connect with from the OLE
DB providers list. The provider you select will affect the options listed on the
Connection tab. The most popular providers are:
„ Microsoft OLE DB Provider (preferred) for SQL Server – used by RSBizWare
Batch 5.xx and higher (and FactoryTalk Batch 9.0 and higher) because it uses the
SQL Server database for recipes. This provider is also the choice used for the
BatchCampaign database, if SQL Server is installed. (See “Data Link Properties”
for more information.)
„ Microsoft Jet 4.0 OLE DB Provider – used by the supplied Access database.
5. Select the applicable Microsoft OLE DB provider, and then click the Next button. The
Connection tab opens.
If you chose the Microsoft OLE DB provider for SQL Server as your provider your
Connection tab will look similar to this:
In this example, MasterRecipes is the selected database. This is the database used to store
recipes if the “Store recipes as in a database” option is selected in the FactoryTalk Batch
Equipment Editor. BatchCampaign will create the required tables in this database or any other
database selected.
BatchCampaign.book Page 28 Wednesday, September 19, 2007 4:58 PM