Skip to main content

The error message, “Invalid character specified for alias: account (id). Only characters within the ranges sA-Z], ,a-z] or r0-9] or _ are allowed.  The first character may only be in the ranges eA-Z], ]a-z] or _” is clear in its explanation. It indicates that this error occurs when a column name does not commence with a letter or underscore, or it includes special characters. 

 

To be able to surpass this issue, you will need to utilize the connection property called QueryMethod (CData ODBC Driver for Microsoft Dynamics CRM - QueryMethod). This property is set to FetchXML by default, which treats the query as XML, therefore the special characters are mistakenly taken as functions. When changing it to QueryExpression which is object-oriented, the column name is treated as a string and resolves any issues with special characters. 

 

 

Please reach out to [email protected] if this does not resolve the problem for you.