Navigate
or
Contact Us
Subscribe Download PDF

MobileAsset v7: Editing or printing Location labels gives error 28000 or 42000, or no result

Scott Barnett
2017-04-10
in Version 7

Symptoms

  1. When attempting to edit the Location label from MobileAsset v7, you receive one of the following errors:





  2. In MobileAsset, attempting to print labels from the Location List (not checking Preview) gives the error "Object reference not set to an instance of an object."

  3. In MobileAsset, attempting to print labels from the Location List (checking Preview), nothing happens (no print preview appears).

Cause

The default Location label was set to access the SQL database with the sa user account, but for this particular database, that account doesn't use Wasp's usual password.

Resolution

    1. In MobileAsset, start the label editing process. The Location Labels file opens in Labeler.

    2. On the Data tab, click Edit Connection.

    3. ODBC Configuration.

    4. In the Login information section, specify these credentials:
      User name: AssetReader
      Password: ReadOnly@1ReadOnly@1


    5. OK.

    6. Apply.

    7. On the File tab, click Save, then Close.

    8. Quit Labeler.

    9. In MobileAsset, click Save Changes, OK, then Close.

    10. The label file is now set to use the proper account.