Product: LABELVIEW, CODESOFT
Version: All Versions
1. Navigate to Data Sources > Database > Create/Edit Query. Alternatively, from the Data Sources window, right-click Database and select Create/Edit Query.
2. Click New and select Wizard.
3. Select ODBC and click Finish.
4. Navigate to the System DSN tab.
5. Click Add.
6. Choose the appropriate driver for the connection being made. Click Finish.
7. Enter a Data Source Name. This will be the name of the connection within LABELVIEW or CODESOFT and does not have to be the name of the file.
8. Depending on the driver and the data connection, click Select Database or Select Workbook. Ensure that Use Current Directory is unchecked.
9. Browse to the database file, select it, and click OK.
10. Verify that the path to the database is displayed in the ODBC Setup screen. Click OK.
11. Click OK to close the ODBC Data Source Administrator window.
12. Select the new connection from the Select a data source drop-down in the Query Definition window.
13. Select the table.
14. Select the fields you would like to add, or click the Select All button. Then Click OK.
15. Click No when asked if you would like to save the current query.
NOTE: Though we recommend selecting No for a standard query, this option is useful if you have created a custom SQL statement in SQL creation mode. The database connection will work whether or not the query is saved.
16. Navigate to Data Sources > Database > Your Database Connection > Your Field and click Place. Alternatively, right-click the field in the Data Sources window and select Place. Click anywhere on the label to add the field.