Skip to end of metadata
Go to start of metadata

Description

This error occurs when attempting to print a label with multiple database-key fields, where one key field is a Copy From a Database-Data field returned from the another database-key field. The originating database-key is coming from a password protected database. 

 

Message
(M1144) Error from ODBC (opening recordset2): No columns were bound prior to calling SQLFetchScroll/SQLExtendedFetch

 

The error is being caused because the secondary, Copy From Database-Key is actually attempting to communicate with the password controlled database, but is getting rejected. 

Solution

The Solution is to add an Advanced Connection String to the first Database-Key field, as follows;

DSN=<system DNS name>;UID=<database userid>;PWD=<database password>;

 

 

 

Article Number

 2013104

Versions

All LLM/LPS versions

Environment

All supported installation environments.