Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
jschrader
New 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
New Contributor III

Re: User Directory Connector Access(via ODBC)

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

1 Reply
jschrader
New Contributor III

Re: User Directory Connector Access(via ODBC)

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