Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

conneting

    Hi All,

I have been given with the ip add , user name and password to fetch the data from sql server ,

i see in the edit script that there is already 

OLEDB CONNECT TO $(Include=SDB.conn)

in this , what doeas this means ,, now i have to change this server with the ip given above ,

how do i do this

1 Solution

Accepted Solutions
marcus_sommer

Yes you need to made the changes within the text-file (a Backup of them before changing might be useful to be able to reverse it again or to have a look on the previous statement) and no this file isn't autogenerated - it's quite probably just a copy + paste from an autogenerated connect-statement. For the logic of include-variables take a look here: The $(Include) which you $(Must_Include) into your toolkit.

- Marcus

View solution in original post

3 Replies
marcus_sommer

The connection-statement is outsourced within an include-variable which is in a small text-file within the same folder like the qvw with the filename: SDB.conn.

- Marcus

smilingjohn
Specialist
Specialist
Author

Hi Marcus

Thanks for the reply

So do i need to make the changes within the text file ? and one more this is this file auto generated ?

marcus_sommer

Yes you need to made the changes within the text-file (a Backup of them before changing might be useful to be able to reverse it again or to have a look on the previous statement) and no this file isn't autogenerated - it's quite probably just a copy + paste from an autogenerated connect-statement. For the logic of include-variables take a look here: The $(Include) which you $(Must_Include) into your toolkit.

- Marcus