Discussion Board for collaboration on QlikView Scripting.
I got a URL, user & password to connect to SQL Server in the cloud.
Does anyone know how I can define the connection?
Thanks in advance!
Go to Solution.
I had to create an ODBC connection with the URL as the SQL server name.
Afterwards, I could connect with QlikView selecting it from the available ODBC connections list.
Perhaps this link helps:
SQL Server Native Client 10.0 OLE DB Provider Connection String Samples - ConnectionStrings.com
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:
General Guidelines and Limitations (Windows Azure SQL Database)
Should I create a connection string and use it in the script itself?