Supported OLE DB Database Platforms

BarTender supports many OLE DB database platforms. You can select any of the following platforms from the Type of Database page of the Add Database Connection Wizard.

• Microsoft Access. A popular desktop relational database application that can be read by BarTender using an OLE DB provider.

• Microsoft Excel. A popular spreadsheet application that can be read by BarTender using an OLE DB provider.

• Microsoft SQL Server. A popular server-based relational database application that can be read by BarTender using an OLE DB provider.

• Oracle. A popular server-based relational database application that can be read by BarTender using an OLE DB provider. When you select Oracle as the Type of Database in the Add Database Connection Wizard, BarTender uses Microsoft's provider for Oracle. If you prefer to use Oracle's provider, download it from Oracle's web site and select General OLE DB Provider as the desired database platform.

  Before connecting to an Oracle database as your data source, you may want to consider your integration options. For more information, see Integrating with Oracle.

• General OLE DB Provider. Any database application for which there is an OLE DB provider installed on the computer.

• Universal Data Link (UDL) File. An alternate means of BarTender's communication with an OLE DB provider. Select this option if you want to use an OLE DB data source, but you want the connection information stored in a separate file rather than in the BarTender document. This is useful if you have other applications that will be accessing the same OLE DB data source as BarTender, since all of these applications can use the very same UDL file.

• IBM Informix. This option will only be visible if the IBM Informix OLE DB Provider is available on your system.

Related Topics

• Understanding OLE DB

Open topic with navigation