ODBC Error: Data Source Name Not Found
Description
When opening a label in On-Demand Print or double-clicking on a database connected field in Design, I get the following error:
Error from ODBC: Data source name not found and no default driver specified. ODBC Data source is ____________. Consult online help or the User Guide for more information on using ODBC.
Solution
Follow these steps to reconnect your labels to their data sources:
- From the Windows desktop, select Start | Settings | Loftware Labeling, and double click on the ODBC icon to launch the ODBC administrator.
- Click Add, and from the list of available ODBC drivers select the one that corresponds to the type of database your label is connected to; click Finish.
- In the box labled Data Source
Where data is extracted to produce labels. Loftware Label Manager provides a variety of data sources, including the keyboard, a database, serial number, a formula, via the UCC or UPN Wizard. For RFID labels and tags, data can come from the Keyboard data source or by configuring data blocks using the Block Configuration data source. Name enter that name referenced in the ODBC error ('ODBC data source is _________.') exactly as it is displayed in the error. ODBC data source names are space and case sensitive and as such, your ODBC driver is NOT recognized unless its DSN is entered exactly as it is displayed in the error. Entry of an appropriate 'Description' is optional.
- Select the exact directory or database file to connect to, then click OK until you have exited the configurator.
Note
If using the On-Demand Print Client with the Loftware Print Server, follow the same instructions on the PC running the LPS. Also, make sure that the DSN is configured as a system DSN.
Your database connection should now be established on this computer.
Use only the 32 bit ODBC admisiatrator found under Loftware Labeling
Article Number
2009071
Versions
All supported LPS family product versions.
Environment
Any supported LPS Family product environment