1 Reply Latest reply: Sep 7, 2011 9:33 AM by Sunil Chauhan RSS

    QlikView Connect To MicroSoft SQL Server 2005

      Dear All,

       

      I am new to Qlik View. I need a coding help for how to Connect QlikView with the MS SQL Server 2005.

        • QlikView Connect To MicroSoft SQL Server 2005
          Sunil Chauhan

          reuirement

           

          Need to install oledb provider for sql srver 2005 ( download from internet)

           

          if ready follow the steps below

           

          Contol + E->connect  or in database drop dowwn select  oledb

           

          give te credential

          server name

          user name

          password

           

          test connection if succeed

           

          go to edit script

           

          select

           

          now select ur database  then table and add into script;

           

          reload and then you will have your table from sql server 2005