topic Re: How do I add more data source providers in QlikView

How do I add more data source providers

Fri, 15 Aug 2014 08:08:13 GMT

I am a new user who has downloaded the Personal Edition on a 64bit Windows7 machine.

I would like to connect to an SQL data source (ODBC connection established & tested using the ODBC administrator tool within Qlikview) however when I access the data source list I don't have Microsoft SQL as a provider. In fact I only have 3 providers as can be seen below.

How do I add other providers ?

Re: How do I add more data source providers

Fri, 15 Aug 2014 08:25:25 GMT

You have to create a Conenction to the Data Source first with the ODBC Administration from Windows, you can open them direct from QlikView in the Script Editor -> Tools -> ODBC Administration (select the Bit Version your driver is)

Re: How do I add more data source providers

Fri, 15 Aug 2014 08:35:34 GMT

Thanks for the reply Daniel.

I have created the ODBC connection in the windows administration as follows :

My issue is that SQL is not listed as a provider when I am trying to connect to a data source

Re: How do I add more data source providers

Fri, 15 Aug 2014 08:41:33 GMT

It is better to create a System DSN, is it a 32bit Conenction, in this case you have to Force 32bit