topic Re: best practices while connecting to databases in QlikView https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588625#M1112247 <HTML><HEAD></HEAD><BODY><P>If you can connect with database by OLE DB,&nbsp; You should use it instead&nbsp; ODBC.</P><P>OLE DB is the succesor of ODBC, provides more functionality and&nbsp; not require any configuration at the system as create a DNS entry.</P><P></P><P>Regards</P></BODY></HTML> Sat, 01 Mar 2014 14:21:50 GMT 2014-03-01T14:21:50Z best practices while connecting to databases https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588623#M1112245 <HTML><HEAD></HEAD><BODY><P>what are the best practices while connecting to data bases in Qlikview?</P></BODY></HTML> Sat, 01 Mar 2014 12:10:42 GMT https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588623#M1112245 2014-03-01T12:10:42Z Re: best practices while connecting to databases https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588624#M1112246 <HTML><HEAD></HEAD><BODY><P>Once connected, save the connection string in a text file and then call the text file by using Include Statement</P><P></P><P><IMG alt="2014-03-01_1407.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54074_2014-03-01_1407.png" /></P></BODY></HTML> Sat, 01 Mar 2014 14:07:50 GMT https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588624#M1112246 rustyfishbones 2014-03-01T14:07:50Z Re: best practices while connecting to databases https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588625#M1112247 <HTML><HEAD></HEAD><BODY><P>If you can connect with database by OLE DB,&nbsp; You should use it instead&nbsp; ODBC.</P><P>OLE DB is the succesor of ODBC, provides more functionality and&nbsp; not require any configuration at the system as create a DNS entry.</P><P></P><P>Regards</P></BODY></HTML> Sat, 01 Mar 2014 14:21:50 GMT https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588625#M1112247 2014-03-01T14:21:50Z Re: best practices while connecting to databases https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588626#M1112248 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Best practice is that create any database connection and store that connection string in a text file and include this text file in the QVW application and use this string for database connection. Because some how if some changes in the database connection string you have to change this only on the text file and then use this.</P><P></P><P>HTH</P><P>Thanks &amp; Regards</P></BODY></HTML> Sat, 01 Mar 2014 15:19:07 GMT https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588626#M1112248 its_anandrjs 2014-03-01T15:19:07Z Re: best practices while connecting to databases https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588627#M1112249 <HTML><HEAD></HEAD><BODY><P>Force 32BIT</P></BODY></HTML> Sat, 01 Mar 2014 20:19:58 GMT https://community.qlik.com/t5/QlikView/best-practices-while-connecting-to-databases/m-p/588627#M1112249 2014-03-01T20:19:58Z