Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.