Having some trouble importing users to Qlik Sense, hoping someone can help.
I am attempting to store my users in a SQL Server database. I cannot currently use Excel due to a 32 bit/64bit driver issue (I have 32 bit Office products installed, which makes the 64 bit Excel driver impossible to install).
Here is the error I am getting:
(I tried with the table names as Table1, Table2 and as dbo.Table1 and dbo.Table2.
Here is my 64 bit ODBC app:
(Not sure this even needs to be created with the Native Connection, but did anyway...though no where in the QMC does it ask for the DSN)
Here is my SQL Server and tables: