topic Re: ODBC connection to a SQL DB from Qlikview in QlikView https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724258#M1068232 <HTML><HEAD></HEAD><BODY><P><IMG alt="p01.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/66569_p01.png" style="width: 620px; height: 308px;" /></P><P>download the ODBC file</P></BODY></HTML> Thu, 11 Sep 2014 14:52:15 GMT ecolomer 2014-09-11T14:52:15Z ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724249#M1068223 <HTML><HEAD></HEAD><BODY><P>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 ?</P></BODY></HTML> Fri, 05 Sep 2014 22:46:11 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724249#M1068223 2014-09-05T22:46:11Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724250#M1068224 <HTML><HEAD></HEAD><BODY><P>Did you try adding the SQL DB to the Microsoft ODBC Aministrator first?</P><P></P><P>Thank you</P><P>Suraj</P></BODY></HTML> Fri, 05 Sep 2014 23:21:57 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724250#M1068224 2014-09-05T23:21:57Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724251#M1068225 <HTML><HEAD></HEAD><BODY><P>You have the ODBC in</P><P><A href="http://www.microsoft.com/en-US/download/details.aspx?id=36434" title="http://www.microsoft.com/en-US/download/details.aspx?id=36434">Download Microsoft® ODBC Driver 11 for SQL Server® - Windows from Official Microsoft Download Center</A></P></BODY></HTML> Sat, 06 Sep 2014 07:02:28 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724251#M1068225 ecolomer 2014-09-06T07:02:28Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724252#M1068226 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Vikram,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">You can use OLEDB for SQL Server. It's simple and easy to set up. See the below screenshot.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></P><P><IMG alt="OLEDB.png" class="jive-image jiveImage" src="https://community.qlik.com/legacyfs/online/66113_OLEDB.png" /></P></BODY></HTML> Sat, 06 Sep 2014 10:25:41 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724252#M1068226 IAMDV 2014-09-06T10:25:41Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724253#M1068227 <HTML><HEAD></HEAD><BODY><P>Hi Vikran</P><P></P><P>1) Create the odbc in control panel (windows) and set the database</P><P>2) go to qlikview, edit script and use the button "Connect"</P><P>3) put the user and pasword</P><P>4) go to the button "Select" </P><P>5) all the table will be appear</P><P></P><P>good luck</P><P></P><P>Fernando</P></BODY></HTML> Sat, 06 Sep 2014 13:39:09 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724253#M1068227 fkeuroglian 2014-09-06T13:39:09Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724254#M1068228 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>make sure proper drivers are installed.</P><P>You can go with ODBC or OLEDB connecting string.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 07 Sep 2014 06:25:08 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724254#M1068228 ashfaq_haseeb 2014-09-07T06:25:08Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724255#M1068229 <HTML><HEAD></HEAD><BODY><P>Thanks all. I needed to add POSTgreSQL drivers on my machine</P></BODY></HTML> Thu, 11 Sep 2014 14:44:25 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724255#M1068229 2014-09-11T14:44:25Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724256#M1068230 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Can u close this thread</P><P>Regards</P><P>Ashfaq</P></BODY></HTML> Thu, 11 Sep 2014 14:49:57 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724256#M1068230 ashfaq_haseeb 2014-09-11T14:49:57Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724257#M1068231 <HTML><HEAD></HEAD><BODY><P>Downlod and install ODBC&nbsp; from</P><P></P><P><A href="http://www.postgresql.org/ftp/odbc/versions/msi/" title="http://www.postgresql.org/ftp/odbc/versions/msi/">PostgreSQL: File Browser</A></P></BODY></HTML> Thu, 11 Sep 2014 14:50:49 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724257#M1068231 ecolomer 2014-09-11T14:50:49Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724258#M1068232 <HTML><HEAD></HEAD><BODY><P><IMG alt="p01.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/66569_p01.png" style="width: 620px; height: 308px;" /></P><P>download the ODBC file</P></BODY></HTML> Thu, 11 Sep 2014 14:52:15 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724258#M1068232 ecolomer 2014-09-11T14:52:15Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724259#M1068233 <HTML><HEAD></HEAD><BODY><P>Sure, I do not see any way to close it.&nbsp;&nbsp; What are the steps ?</P></BODY></HTML> Thu, 11 Sep 2014 14:52:51 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724259#M1068233 2014-09-11T14:52:51Z Re: ODBC connection to a SQL DB from Qlikview https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724260#M1068234 <HTML><HEAD></HEAD><BODY><P>Mark it as correct and helpful.</P><P>Open in new window</P><P>Regards </P><P>Ashfaq</P></BODY></HTML> Thu, 11 Sep 2014 14:54:41 GMT https://community.qlik.com/t5/QlikView/ODBC-connection-to-a-SQL-DB-from-Qlikview/m-p/724260#M1068234 ashfaq_haseeb 2014-09-11T14:54:41Z