Skip to main content

MobileAsset v7: Editing or printing Location labels gives error 28000 or 42000, or no result - Knowledgebase / Discontinued Products / MobileAsset / Version 7 - Wasp Helpdesk

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

Authors list

Symptoms

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

    labeler7-error-28000.png

    labeler7-error-42000.png

  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.
Helpful Unhelpful

15 of 50 people found this page helpful