topic Re: Connect to MS SQL Data base in QlikView https://community.qlik.com/t5/QlikView/Connect-to-MS-SQL-Data-base/m-p/1307752#M830703 <HTML><HEAD></HEAD><BODY><P>I usually do this:</P><P>1.Create a DS using odbc 32bit. </P><P><IMG alt="1_DSCreation.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167195_1_DSCreation.PNG" style="max-width: 620px; height: auto;" /></P><P>2. Once connected using the ODBC from Edit script of Qlikview. </P><P>Eg:</P><P>ODBC CONNECT32 DATABASECONNECTIONNAME; created from above. </P><P></P><P>You can see the name in the Connect window in QV edit script.&nbsp; </P></BODY></HTML> Sun, 18 Jun 2017 02:46:13 GMT vishsaggi 2017-06-18T02:46:13Z Connect to MS SQL Data base https://community.qlik.com/t5/QlikView/Connect-to-MS-SQL-Data-base/m-p/1307751#M830701 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I would like to know what all things required to connect to MS SQL database through ODBC.</P><P></P><P>Thanks in advance for help.</P><P></P><P>Regards,</P><P>Imran Khan</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Connect-to-MS-SQL-Data-base/m-p/1307751#M830701 khan_imran 2020-11-25T16:16:04Z Re: Connect to MS SQL Data base https://community.qlik.com/t5/QlikView/Connect-to-MS-SQL-Data-base/m-p/1307752#M830703 <HTML><HEAD></HEAD><BODY><P>I usually do this:</P><P>1.Create a DS using odbc 32bit. </P><P><IMG alt="1_DSCreation.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167195_1_DSCreation.PNG" style="max-width: 620px; height: auto;" /></P><P>2. Once connected using the ODBC from Edit script of Qlikview. </P><P>Eg:</P><P>ODBC CONNECT32 DATABASECONNECTIONNAME; created from above. </P><P></P><P>You can see the name in the Connect window in QV edit script.&nbsp; </P></BODY></HTML> Sun, 18 Jun 2017 02:46:13 GMT https://community.qlik.com/t5/QlikView/Connect-to-MS-SQL-Data-base/m-p/1307752#M830703 vishsaggi 2017-06-18T02:46:13Z