Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Connecting to SQL Server in a cloud

Dear All,

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!

1 Solution

Accepted Solutions
Not applicable

Re: Connecting to SQL Server in a cloud

Hi,

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.

3 Replies

Re: Connecting to SQL Server in a cloud

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)


talk is cheap, supply exceeds demand
Not applicable

Re: Connecting to SQL Server in a cloud

Hi,

Should I create a connection string and use it in the script itself?

Thanks!

Not applicable

Re: Connecting to SQL Server in a cloud

Hi,

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.

Community Browser