topic Re: DSN in QlikView

DSN

Wed, 30 Apr 2014 07:48:53 GMT

Hi all,

Please let me know what is DSN in QV ,,how it works.. what is the use of it with examples,please reply

Re: DSN

Wed, 30 Apr 2014 07:53:17 GMT

This dialog is used for creating a connection to an ODBC data source. The dialog is opened when clicking the Connect button in the Data page of the Tool Pane in the Edit Script Dialog if the database option ODBC has been chosen.

On this page choose the data source. As default only the system DSNs are displayed. Check Show User DSNs to view all DSNs.

It is possible if necessary to specify User name and Password for the data source. The connection can also be tested by pressing the Test Connection button.

Finally click the OK button. The connect statement is ready.

Re: DSN

Wed, 30 Apr 2014 07:55:26 GMT

I think you mean Data Source Name, this is nothing QV related. You create a System DSN for a Database Connection to load data.

Data source name - Wikipedia, the free encyclopedia

Re: DSN

Wed, 30 Apr 2014 07:59:28 GMT

sorry i cant get you ...

Re: DSN

its_anandrjs — Wed, 30 Apr 2014 08:53:26 GMT

I my knowledge there is nothing like DSN in qlikview but DSN stands for Data Source Name it is basically used for creating the ODBC and OLE db connections. In your computer system you define the Data Source Name and use this name for connecting the data source.

Re: DSN

Wed, 30 Apr 2014 12:32:35 GMT

Ok,Thanks