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

    How to connect to an SQL Server



      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,