Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jschrader
Contributor III
Contributor III

User Directory Connector Access(via ODBC)

I am trying to setup the User Directory Connector using Access(via ODBC). I am targeting two .csv files.

I have installed the Microsoft Access Text Driver.

Here is my setup:

User Directory Connector Setup.PNG

Here is my error:

User Directory Connector Error.PNG

Has anyone seen this error? How can I resolve the issue?

Thanks!

1 Solution

Accepted Solutions
jschrader
Contributor III
Contributor III
Author

I figured out what I needed to do.

After installing the connector, I needed to create the system dsn, modify the file path to the correct directory, and then define the format.User Directory Connector Configure.PNG

Once the dsn is correctly I configured, I was able to modify the connector to reference the correct dsn.

User Directory Connector Fix.PNG

View solution in original post

2 Replies
jschrader
Contributor III
Contributor III
Author

I figured out what I needed to do.

After installing the connector, I needed to create the system dsn, modify the file path to the correct directory, and then define the format.User Directory Connector Configure.PNG

Once the dsn is correctly I configured, I was able to modify the connector to reference the correct dsn.

User Directory Connector Fix.PNG

tmumaw
Specialist II
Specialist II

Hi,

I'm sort of having the same issue you had.  I'm getting the message "The UDC is not configured, because the following error occurred: One or more of the expected tables users.csv and secaccessgroups.csv are not present.  I followed your example with no luck....any suggestions?  I'm using ODBC driver for text and when I create my UDC I used Access via ODBC.  Thanks