User Directory Connector Access(via ODBC)

[jschrader]

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:

Here is my error:

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

Thanks!

[jschrader · Accepted solution]

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.

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

[tmumaw]

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