topic Problem with OLEDB connection string to connect to SQL Server database in QlikView https://community.qlik.com/t5/QlikView/Problem-with-OLEDB-connection-string-to-connect-to-SQL-Server/m-p/688665#M1318408 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I use OLEDB connection to connect to my SQL database but sometimes the related connection string contains an extra part at the end of it (First example) and sometimes it does not contain this part. Does anyone know how I can have the first example, because when I give Qlikview exe file to users they have to enter password everytime they reload the data.</P><P></P><P><SPAN style="color: #339966;">First Example</SPAN> : OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=<SPAN style="color: #000000;">**</SPAN>;Initial Catalog=***;Data Source=***;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=***;Use Encryption for Data=False;Tag with column collation when possible=False]<SPAN style="color: #ff0000;"> (XPassword is HNUNFYEHGTRNETYYA);</SPAN></P><P></P><P><SPAN style="color: #339966;">Second Example :</SPAN> OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security="";Persist Security Info=False;User ID=***;Initial Catalog=***;Data Source=***;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=***;Use Encryption for Data=False;Tag with column collation when possible=False;DataTypeCompatibility=0;Trust Server Certificate=False];</P><P></P><P>Thanks </P><P>Farzaneh</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT 2026-01-26T18:19:17Z Problem with OLEDB connection string to connect to SQL Server database https://community.qlik.com/t5/QlikView/Problem-with-OLEDB-connection-string-to-connect-to-SQL-Server/m-p/688665#M1318408 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I use OLEDB connection to connect to my SQL database but sometimes the related connection string contains an extra part at the end of it (First example) and sometimes it does not contain this part. Does anyone know how I can have the first example, because when I give Qlikview exe file to users they have to enter password everytime they reload the data.</P><P></P><P><SPAN style="color: #339966;">First Example</SPAN> : OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=<SPAN style="color: #000000;">**</SPAN>;Initial Catalog=***;Data Source=***;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=***;Use Encryption for Data=False;Tag with column collation when possible=False]<SPAN style="color: #ff0000;"> (XPassword is HNUNFYEHGTRNETYYA);</SPAN></P><P></P><P><SPAN style="color: #339966;">Second Example :</SPAN> OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security="";Persist Security Info=False;User ID=***;Initial Catalog=***;Data Source=***;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=***;Use Encryption for Data=False;Tag with column collation when possible=False;DataTypeCompatibility=0;Trust Server Certificate=False];</P><P></P><P>Thanks </P><P>Farzaneh</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Problem-with-OLEDB-connection-string-to-connect-to-SQL-Server/m-p/688665#M1318408 2026-01-26T18:19:17Z Re: Problem with OLEDB connection string to connect to SQL Server database https://community.qlik.com/t5/QlikView/Problem-with-OLEDB-connection-string-to-connect-to-SQL-Server/m-p/688666#M1318413 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>While creating your connection string make sure to select Allow saving password.</P><P>As shown in the attached image.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 02 Sep 2014 08:49:29 GMT https://community.qlik.com/t5/QlikView/Problem-with-OLEDB-connection-string-to-connect-to-SQL-Server/m-p/688666#M1318413 ashfaq_haseeb 2014-09-02T08:49:29Z