https://community.qlik.com/t5/Connectivity-Data-Prep/Visible-Connection-String/m-p/1762678#M5561 <P><STRONG>I'm trying to build a UDC and having some issues.&nbsp; I'm getting the message The UDC is not configured, because the following error occurred: Exception when trying to access the userid field of the Users.csv table: Error [07002] [Microsoft] [ODBC Text Driver] too few parameters.&nbsp; Expected 1....Here is what my screen looks like.&nbsp; Any ideas on how to get around the error?</STRONG></P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UDC.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44400iCEFB4BF793003BEE/image-size/large?v=v2&amp;px=999" role="button" title="UDC.jpg" alt="UDC.jpg" /></span></P> Wed, 22 Dec 2021 14:51:32 GMT tmumaw 2021-12-22T14:51:32Z https://community.qlik.com/t5/Connectivity-Data-Prep/Visible-Connection-String/m-p/1762678#M5561 <P><STRONG>I'm trying to build a UDC and having some issues.&nbsp; I'm getting the message The UDC is not configured, because the following error occurred: Exception when trying to access the userid field of the Users.csv table: Error [07002] [Microsoft] [ODBC Text Driver] too few parameters.&nbsp; Expected 1....Here is what my screen looks like.&nbsp; Any ideas on how to get around the error?</STRONG></P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UDC.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44400iCEFB4BF793003BEE/image-size/large?v=v2&amp;px=999" role="button" title="UDC.jpg" alt="UDC.jpg" /></span></P> Wed, 22 Dec 2021 14:51:32 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Visible-Connection-String/m-p/1762678#M5561 tmumaw 2021-12-22T14:51:32Z https://community.qlik.com/t5/Connectivity-Data-Prep/Visible-Connection-String/m-p/2427579#M13459 <P>Hello,<BR /><BR />I experienced the same error and managed to resolve it.<BR />This error may be caused by the Byte Order Mark (BOM) that is included in the character encoding of the CSV file.<BR />You might want to try removing the BOM and see if that solves the problem.<BR /><BR />Best regards,</P> Wed, 06 Mar 2024 08:45:05 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Visible-Connection-String/m-p/2427579#M13459 hinamasu 2024-03-06T08:45:05Z