4 Replies Latest reply: Oct 29, 2013 4:19 AM by Thomas Jensen RSS

    How to connect to an SQL Server

      Hello,

       

      I am currently trying to integrate datas from an SQL source on QV

       

      I proceed as follow:

      I went to file > Edit script  

      • I clicked on Database OLE DB and pressed the button "Connect"
      • I selected the provider "Microsoft OLE DB Provider for Analysis Services 9.0".
      • I entered the server name and I chose to use Windows security instead of username and password.
      • I clicked “Test Connection” and the window “connection succeed” appeared.
      • Then QV generated the connection string into the script window and I chose to use Views.
      • Finally I clicked OK and QV gave me the script

       

      Here is the problem: when I tried to reload my file I got an error message.

       

      Please see the attached document for more details.

       

      Many thanks,

       

      Helene