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 on the New button 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 that is 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 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'd like to add, or click the Select All button.
15. Click OK.
16. Click No when asked if you'd like to save the current query.
NOTE: Though we recommend selecting No for a standard query, this option is useful if you've created a custom SQL statement in SQL creation mode. The database connection will work whether or not the query is saved.
17. Navigate to to Data Source > 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.
|