topic Re: Connecting to SQL Server in a cloud in QlikView https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562403#M692040 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I had to create an ODBC connection with the URL as the SQL server name.</P><P>Afterwards, I could connect with QlikView selecting it from the available ODBC connections list.</P></BODY></HTML> Fri, 06 Sep 2013 13:41:15 GMT 2013-09-06T13:41:15Z Connecting to SQL Server in a cloud https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562400#M692037 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I got a URL, user &amp; password to connect to SQL Server in the cloud.</P><P>Does anyone know how I can define the connection?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 03 Sep 2013 08:50:07 GMT https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562400#M692037 2013-09-03T08:50:07Z Re: Connecting to SQL Server in a cloud https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562401#M692038 <HTML><HEAD></HEAD><BODY><P>Perhaps this link helps:</P><P><A href="http://www.connectionstrings.com/sql-server-native-client-10-0-oledb-provider/" title="http://www.connectionstrings.com/sql-server-native-client-10-0-oledb-provider/">SQL Server Native Client 10.0 OLE DB Provider Connection String Samples - ConnectionStrings.com</A></P><P></P><P>If you're trying to connect to SQL Azure instead of SQL Server you can try defining an odbc connection in the odbc manager instead of trying oledb:</P><P><A href="http://msdn.microsoft.com/en-us/library/ee336245.aspx#tats" title="http://msdn.microsoft.com/en-us/library/ee336245.aspx#tats">General Guidelines and Limitations (Windows Azure SQL Database)</A></P></BODY></HTML> Tue, 03 Sep 2013 09:08:34 GMT https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562401#M692038 Gysbert_Wassenaar 2013-09-03T09:08:34Z Re: Connecting to SQL Server in a cloud https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562402#M692039 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Should I create a connection string and use it in the script itself?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 03 Sep 2013 09:25:51 GMT https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562402#M692039 2013-09-03T09:25:51Z Re: Connecting to SQL Server in a cloud https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562403#M692040 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I had to create an ODBC connection with the URL as the SQL server name.</P><P>Afterwards, I could connect with QlikView selecting it from the available ODBC connections list.</P></BODY></HTML> Fri, 06 Sep 2013 13:41:15 GMT https://community.qlik.com/t5/QlikView/Connecting-to-SQL-Server-in-a-cloud/m-p/562403#M692040 2013-09-06T13:41:15Z