Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Visible Connection String

I'm trying to build a UDC and having some issues.  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.  Expected 1....Here is what my screen looks like.  Any ideas on how to get around the error?

 

UDC.jpg

Labels (1)
1 Reply
hinamasu
Partner - Contributor III
Partner - Contributor III

Hello,

I experienced the same error and managed to resolve it.
This error may be caused by the Byte Order Mark (BOM) that is included in the character encoding of the CSV file.
You might want to try removing the BOM and see if that solves the problem.

Best regards,