
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Connect to OLEDB/ODBC sample data - Connection Details
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 ?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I Hope you saw my attachment excel file Northwind.xls (Here each sheet is a separate table) and that to this is free data base for MS Sql server.
no need to install sql server in your machine directly you can work with excel sheets/tables.
except one line of code for ODBC /OLDB connection (in QV edit script code) these tables are from data base only.(Northwind)
for any other doubts feel free to reach me 8376964364 ramasaiqvw@gmail.com

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Click Start > Computer
- Browse to the C: drive
- Open the Windows folder
- Open the SysWOW64 folder
- Double-click on the odbcad32.exe file to open the ODBC Data Sources Administrator window
- Select the System DSN tab
- Click Add
- Select SQL Server and click Finish
- Complete the DSN Configuration wizard (see example screen shots below)
Windows 7 32-bit
- Click Start > Computer
- Browse to the C: drive
- Open the Windows folder
- Open the System32 folder
- Double-click on the odbcad32.exe file to open the ODBC Data Sources Administrator window
- Select the System DSN tab
- Click Add
- Select SQL Server and click Finish
- Complete the DSN Configuration wizard (see example screen shots below)
Windows XP
- Click Start and select Settings > Control Panel > Administrative Tools
- Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator.
- Select the System DSN tab
- Click Add
- Select SQL Server and click Finish
- Complete the DSN Configuration wizard (see example screen shots below)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I dont have SQL Server installed in the system. I just wanted to connect to any of the database available in online for free..

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You may try connecting to MS Access DB. It has some sample/Test DB.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I Hope you saw my attachment excel file Northwind.xls (Here each sheet is a separate table) and that to this is free data base for MS Sql server.
no need to install sql server in your machine directly you can work with excel sheets/tables.
except one line of code for ODBC /OLDB connection (in QV edit script code) these tables are from data base only.(Northwind)
for any other doubts feel free to reach me 8376964364 ramasaiqvw@gmail.com

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ywah okay .. I will try with the excel attached. Thanks!
