Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
chriscammers
Partner - Specialist
Partner - Specialist

Configurable ODBC Directory Service Connector using Access Text Driver

Hello Everyone,

I'm having some trouble and I don't know what to try next.

I am configuring the Configurable ODBC Directory Service Connector in QlikView 11.20.12904.0

I am attempting to connect to two CSV files which are being generated by another QlikView server wich is extracting data from Salesforce.

I configured a system DSN using the 64 bit Microsoft Access Text Driver(*.txt, *.csv)

The files are located in the directory... and the odbc configuration created the schema,ini file

When I configure the DSC I am getting an error that the dscusers.csv is not found.

As far as I can tell everything is in the right place and the DSC is finally using the driver to find the data but it just can't read the tables so does anybody have any suggestions for what to try next?

I have attached my latest attempt to configure the connection

I have tried naked, single quoted, and square braced variations of the tables names but nothing has worked to this point.

All suggestions are appreciated and when I figure this out I will post my solution

Thanks

1 Reply
Colin-Albert

Can you open the csv file directly using a UNC path to the file location? There is no need to use ODBC to load text data.