5 Replies Latest reply: Jul 15, 2014 5:10 PM by Chris Rice RSS

    QV Server unable to connect to database from QMC

    Sk Sakir Ali

      Hi,

       

      I am facing an issue, when I am executing a qvw from Qlikview Desktop it's getting executed succesfully, but when I am executing it from QMC it is failing by showing an error as:
      ODBC CONNECT32*XUserId*XPassword*
      Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      General Script Error

       

      Strange thing is that sometime it gets executed from QMC but fails more often.

      I have configured System DSN by the service account and I am using ODBC CONNECT32 to connect to database.

       

      Has anyone faced this before?? Any solution for this??

       

      Thank in advance.

       

      Regards,

      Sakir