5 Replies Latest reply: Oct 12, 2017 9:50 AM by Pradeep S RSS

    Connect to OLEDB/ODBC sample data - Connection Details

    Pradeep S

      Hi ,

       

      I am working on the Qlikview personal edition. I would like to connect to any of the sample Database and load data , learn on my own and play with it.

      Can someone help me out ?

        • Re: Connect to OLEDB/ODBC sample data - Connection Details
          Rama Sai

          for sample data base data

           

          This is a sample data base you can find in MS Sql server.

           

          So play/work with data for your qlikView practice.

           

          no need to create ODBC/OLEDB connection.

           

          if you want to create ODBC connection first of all your desktop need to have installation of Data base client/Server edition in your machine.then only you can create ODBC/OLEDB connection.

           

          it will differ from data base to database so for which data base you want to create connection first load that Database in your desktop.

           

          Windows 7 64-bit

          1. Click Start > Computer
          2. Browse to the C: drive
          3. Open the Windows folder
          4. Open the SysWOW64 folder
          5. Double-click on the odbcad32.exe file to open the ODBC Data Sources Administrator window
          6. Select the System DSN tab
          7. Click Add
          8. Select SQL Server and click Finish
          9. Complete the DSN Configuration wizard (see example screen shots below)

          Windows 7 32-bit

          1. Click Start > Computer
          2. Browse to the C: drive
          3. Open the Windows folder
          4. Open the System32 folder
          5. Double-click on the odbcad32.exe file to open the ODBC Data Sources Administrator window
          6. Select the System DSN tab
          7. Click Add
          8. Select SQL Server and click Finish
          9. Complete the DSN Configuration wizard (see example screen shots below)

          Windows XP

          1. Click Start and select Settings > Control Panel > Administrative Tools
          2. Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator.
          3. Select the System DSN tab
          4. Click Add
          5. Select SQL Server and click Finish
          6. Complete the DSN Configuration wizard (see example screen shots below)

          DSN data entry screen 1
          DSN login
          DSN defaults 1
          DSN defaults 2
          DSN Test connection