New user of Qlik View Personal Edition (QlikView 11.20 SR13) on Windows 7 Pro, 32bit.
I have a DSN, let’s call it SMEG. This DSN works fine with MS Query/MS Excel or OpenOffice. It is using the Clarion TopSpeed read only driver to connect to the SMEG database.
I am trying to connect to this DSN in Qlik.
I have created an additional user DSN as well as the existing system DSN with no success.
I create a new blank file and edit the script. I use ODBC and hit the connect button. I have tried with both force 32bit on and off. I can select SMEG from the data source. Test connection is successful. Press OK.
Press the select button to select my tables and fields. This is where the problem is. The data source is listed, SMEG.
The database and fields drop down menus are grayed out, I can’t select any tables or fields. The driver button reports many details relating to the Clarion driver.
I am sure that I am missing something basic.
The support button from the connection statement window reports the following: