I looked through some articles and it seems not that hard to manage this. Ps: I'm not a connection string specialist so maybe here lies the problem. I need this for my customer because some persons doesn't work through the the also existing Active Directory connection and need Qlik. If I check ODBC then I see the driver in SYSTEM.Ĭan anybody help me please. But if i want to connect to an UDC, Qlik tells me that no DSN of driver is found or a mismatch in string. Recap: I have a working Excel ODBC connection because i see the data in my app. So I tried this and other message appear "The specified DSN contains an architecture mismatch between the Driver and Application " Ok, I understand that Qlik can not find the data source name and no driver is specified. Edit the connection string in the user directory connector configuration "ħ. The 32-bit ODBC Administrator is found at systemdrive/Windows/. I checked the log and see also this "Setting up UDC'EXCEL' of type Repository.UserDirector圜 unsuccessful ERROR Data source name not found and no default driver specified↵↓Exception when trying to connect to the data source.
Edit the connection string in the user directory connector configuration "Ħ. Getting the famous message "Exception when trying to connect to the data source. Created an Excel ODBC user directory and names of sheet are matchingĥ. Created a test app in Hub and make connection. The latest MySQL Connector/ODBC version is recommended for use with MySQL Server version 5.7 and higher. Created a SYSTEM DSN with the 2010 versionģ. Windows (x86, 64-bit), ZIP Archive: 8.1.0: 13.7M: Download. Uninstall my 2016 version and Installed the 2010 version Microsoft Access Engine:Ģ.
#Microsoft excel odbc for windows 7 32 bit 64 Bit#
Windows 64 bit but I need a 32 bit ODBC.ġ. My customer have QlikSense Enterprise November 2018. I read a lot where others facing problems but still it won't work for me. I'm struggling to connect an Excelsheet for user directory purposes.
0 kommentar(er)
