Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 Message

When running On-Demand Print 32 and or the On-Demand Print Client, and selecting the ellipse button to run the query to the database, you receive the following two errors. 

Panel
titleMessage

Windows Application (M1111) Error from ODBC (Opening recordset range): Syntax error in FROM clause.

Windows Application (M1144) Error from ODBC (opening recordset2): Syntax error in FROM clause. Please verify the availability of the database and the accuracy of the Advanced Connection String

 

Example:

Explanation

One of these errors will happen every time you attempt to pull data from a CSV or Text file via an ODBC connection where the filename contains characters not considered valid by ODBC. You will get the M1111 error when you attempt to browse the database using the ellipse button and M1144 when you enter a value and attempt to change field focus, making it impossible to print the label.

Solution

  1. Close the CSV file in Excel.
  2. Open a new blank Excel file.
  3. Select the Data tab.
  4. Select From Text.
  5. Select the transactions.csv file and select Import.
  6. In the Text Import Wizard, select Delimited and My data has headers. Select Next.
  7. Uncheck Tab, select Comma, and select Next.
  8. Select Package Tracking Number column.
  9. Select Text and select Finish.
  10. In the Import Data window, select OK.

Content by Label
labelsodbc,database,missing

Article Number

 2013041 

Versions

LPS / LLM 10.1.0.21

Environment

All supported Windows installation environments.

Page properties
hiddentrue

This table provides article information that is only visible to Loftware users.

Linked Jira 
JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverJira
serverIdb694bd2b-f495-3baf-a460-a9c93a1d1de3
keyOOB-302
Author Mike

Mike Alley

Andrea Veno - 3-12-18

Incident/Case Number 80815
Review Date10/17/2013