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

    ODBC Connection SQL Server

    Philipp Ziemer

      Hey,

       

      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:

      odbc.PNG.png

       

      Thanks

      Philipp