Server Returned Error: Log in failed for user.

Description

'Server Returned Error: An unexpected error has occurred. Error from ODBC opening database. Log in failed for user. NULL not associated with a trusted SQL server connection.'

Solution

When using the On-Demand Print Client with a database requiring a password, you must add an advanced connection string to the label. To do this:

1. In Loftware Design Mode, double click on the key field.
2. In the 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. dialog box, click on the Advanced tab
3. Enter the Data source name, User ID, and Password.
4. Include the DSN(DSN = Data Source Name), the UID(UID=user name), and the PWD(PWD=password)

The structure of the Advanced connection string MUST contain these!

Example
DSN=loftware;UID=scott;PWD=tiger