ODBC connection to a SQL DB from Qlikview

[#1]

I am trying to do a ODBC connection to a SQL DB from Qlikview. I tried to connect and all I am seeing is the data source type of dBase,Access,Excel,Visio. How do I get option to connect to SQL DB ? Looks like I need a JDBC driver for SQL DB if that is the case where do I find this ?

[#2]

Did you try adding the SQL DB to the Microsoft ODBC Aministrator first?

Thank you

Suraj

[ecolomer]

You have the ODBC in

Download Microsoft® ODBC Driver 11 for SQL Server® - Windows from Official Microsoft Download Center

[IAMDV]

Hi Vikram,

You can use OLEDB for SQL Server. It's simple and easy to set up. See the below screenshot.

Thanks,

DV

www.QlikShare.com

[fkeuroglian]

Hi Vikran

1) Create the odbc in control panel (windows) and set the database

2) go to qlikview, edit script and use the button "Connect"

3) put the user and pasword

4) go to the button "Select"

5) all the table will be appear

good luck

Fernando

[ashfaq_haseeb]

Hi,

make sure proper drivers are installed.

You can go with ODBC or OLEDB connecting string.

Regards

ASHFAQ

[#7]

Thanks all. I needed to add POSTgreSQL drivers on my machine

[ashfaq_haseeb]

Hi

Can u close this thread

Regards

Ashfaq

[ecolomer]

Downlod and install ODBC  from

PostgreSQL: File Browser

[ecolomer · Accepted solution]

download the ODBC file