6 Replies Latest reply: Jan 10, 2014 6:40 AM by Dave Riley RSS

    ODBC Connection SQL Server

    Philipp Ziemer



      I want to connect a SQL Server Database through ODBC. I do not want to add a ODBC Data Source but want to add a connection string in QlikView. Which is the correct driver?


      ODBC CONNECT TO 'Driver(?); DbName=c:\Database.mdb' (XUserId is enxrypt_user, XPassword is encrypt_password);


      An analogue working statement for an Interbase Firebird Database would be:


      ODBC CONNECT TO 'FIREBIRD; DbName=c:\Inter_Database.IB' (XUserId is user123, XPassword is password123);


      The connection in ODBC Data Soruces: