How to resolve Error 12001 when running query in Prepackaged Reports?

Problem symptoms

When running a query in Access Reports (Reports.mdb) via Prepackaged Reports and ODBC drivers, receive Error 12001. How to resolve?

Cause

This error can be caused by an incorrect language setting in the Windows Registry.  Technically, NLS_LANG values in PC registry are not set to AMERICAN_AMERICA.US7ASCII

Resolution

Preparatory Steps:

1. Login to the workstation with an account that has full administrative rights on the local PC
2. Open Windows Registry Editor by typing regedit in the Start menu's Search box 
3. When the Registry Editor opens, back up the entire Registry by selecting "Computer" at the top of the left-hand pane, and clicking File > Export... and save the file to a safe location.

Update language setting in the registry:

1. In the Registry Editor go to Edit > Find and search for: NLS_LANG
2. Set registry value of all NLS_LANG keys to AMERICAN_AMERICA.US7ASCII.
3. Restart PC.
4. If error persists, double-check for other NLS_LANG keys and change the value as per Step 2.
5. Restart PC after any registry changes.

Additional Information

This error is specific to the UTF8to16() function.

• Article last edited: 20-Sep-2019