Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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