topic Re: Connect to SQL in QlikView

Connect to SQL

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I am using Qlikview 11.2 , 32-bit . How can i connect to SQL through ODBC? how can i configure DSN setup?

Regards,

Mahesh.

Re: Connect to SQL

marcus_sommer — Wed, 25 May 2016 05:36:47 GMT

Have a look here: The Great ODBC Confusion.

- Marcus

Re: Connect to SQL

Kushal_Chawda — Wed, 25 May 2016 05:45:10 GMT

see this

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/OLEDB_ODBC.htm?q=odbc

Re: Connect to SQL

Anil_Babu_Samineni — Wed, 25 May 2016 06:25:40 GMT

Mahesh,

Try like this ..

Goto control panel->administrative tools->data sources(ODBC). There you can add a user DSN (data source name). When you click add you can select the ODBC driver (which has to be installed) and give the configuration

In qlikview you can select direct DSN.

After that Install Oracle. Then connect with your Access so that you will get....

Re: Connect to SQL

qlikview979 — Thu, 26 May 2016 05:05:09 GMT

Hi All,

How can i create New Data Source in System DNS.

Regards,

Mahesh.

Re: Connect to SQL

Anonymous — Thu, 26 May 2016 05:11:22 GMT

Follow these steps to create system DSN.

Click Start, point to Control Panel, double-click Administrative Tools, and then double-click Data Sources(ODBC).
Click the System DSN tab, and then click Add.
Click the database driver that corresponds with the database type to which you are connecting, and then click Finish.

Regards,

Sagar

Re: Connect to SQL

Anil_Babu_Samineni — Thu, 26 May 2016 06:29:53 GMT

Did you try my side which i post before ...

Re: Connect to SQL

qlikview979 — Fri, 27 May 2016 04:45:05 GMT

Hi All,

Thanks for Your Support

Regards,

Mahesh

Re: Connect to SQL

Anonymous — Fri, 27 May 2016 04:52:34 GMT

Welcome