6 Replies Latest reply: Feb 4, 2016 6:41 AM by Gabor Tarnoczai RSS

    Qliksense Database Connection

    Marco Puccetti

      Hello, i need to connect to a Database and to do this i have used this statement:

       

      OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=USER_ID;Data Source=DATA_SOURCE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=M_WS_ID;Use Encryption for Data=False;Tag with column collation when possible=False];

       

      This cause the following error:


      CONNECTs other than LIB CONNECT are not available in this script mode: OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=AAAAAAA;Data Source=XXXXXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=KKKKKKKI;Use Encryption for Data=False;Tag with column collation when possible=False]

       

       

      Anybody knows how to solve this?

      Thanks