topic Re: conneting in QlikView

conneting

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: conneting

marcus_sommer — Tue, 17 Jan 2017 09:28:37 GMT

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

Re: conneting

smilingjohn — Tue, 17 Jan 2017 09:33:43 GMT

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 ?

Re: conneting

marcus_sommer — Tue, 17 Jan 2017 09:39:33 GMT

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