Database Connection

Database Connection Overview:

Barcode Label Workshop enterprise edition provide data access through the ADO framework. ADO, (Microsoft ActiveX Data Objects) is a set of COM objects that access data through an OLE DB provider. It consists of Microsoft ADO 2.1, an OLE DB provider or ODBC driver for the data store access.

Click menu 'File\Connect to Database' in Datasheet window, you will get a Database Connection dialog.

Here is the guide for make a query from database:

• Connect to database : Click the button 'Database' on Database Connection dialog, the Windows Data Link Properties dialog box appears. This Windows dialog box displays the OLE DB providers currently on the Windows computer running Barcode Label Workshop enterprise edition.
  Complete the Data Link Properties dialog box and click OK, if connect successfully, all tables and its fields appear in the treeview box.
• Make SQL command: You can input SQL statement to 'SQL commands' edit box by yourself directly, or generate through program.
  Select tables to be used from available tables in treeview box, it will appears in FROM clause when made by program.
  Select fields to be used from available fields in treeview box, it will appears in SELECT clause when made by program.
  The Join, Where, and Sorting tabs work together to automatically generate an SQL statement based on the user's settings.
  You need click the 'Make SQL' button to generate statement to 'SQL commands' edit box, and click 'Test SQL' button to preview the query result in Browse preview tab.
• Save query result to datasheet: Click 'OK' to save query result from database to datasheet.

* Note: Only enterprise edition supports connecting to database.