- Created by Unknown User (cboivin), last modified by kbadmin on Mar 12, 2018
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.
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
- Close the CSV file in Excel.
- Open a new blank Excel file.
- Select the Data tab.
- Select From Text.
- Select the transactions.csv file and select Import.
- In the Text Import Wizard, select Delimited and My data has headers. Select Next.
- Uncheck Tab, select Comma, and select Next.
- Select Package Tracking Number column.
- Select Text and select Finish.
- In the Import Data window, select OK.
Related Articles
-
Page:Error When Trying To Retrieve Records From Text Database (Loftware Print Server Family Knowledge Base)
-
Page:Connecting To a Password-Protected Database Through the Label Design (Loftware Print Server Family Knowledge Base)
-
Page:Error M1112 from ODBC Data Source Name Not Found and No Default Driver Specified (Loftware Print Server Family Knowledge Base)
-
Page:
-
Page:Warning: NOKEYTOREF: Database-key field 'Text0000' has no data fields (Loftware Print Server Family Knowledge Base)
-
Page:Error M1141 Unable to Open Database (Loftware Print Server Family Knowledge Base)
-
Page:Missing Fields on an Intermec 3400 (Loftware Print Server Family Knowledge Base)
-
Page:Loftware Oracle Connector Service Not Available After Installing Loftware Oracle Connector (Loftware Print Server Family Knowledge Base)
-
Page:Entire Label Does Not Print on Intermec PM43 (Loftware Print Server Family Knowledge Base)
-
Page:Toolbar Has Been Closed and Will Not Open Back Up (Loftware Print Server Family Knowledge Base)
-
Page:Automatically Linking Labels To Specific Databases (Loftware Print Server Family Knowledge Base)
-
Page:
-
Page:Database Locked When Using On Demand Or Range Print (Loftware Print Server Family Knowledge Base)
-
Page:
-
Page:Tables Not Displaying Under DSN In Data Source Dialog Box (Loftware Print Server Family Knowledge Base)
Article Number
2013041
Versions
LPS / LLM 10.1.0.21
Environment
All supported Windows installation environments.