Connect to OLEDB/ODBC sample data - Connection Details

[pradeep92]

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 ?

[ramasaisaksoft]

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)

[pradeep92]

I dont have SQL Server installed in the system. I just wanted to connect to any of the database available in online for free..

[krishnacbe]

You may try connecting to MS Access DB. It has some sample/Test DB.

[ramasaisaksoft · Accepted solution]

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

[pradeep92]

Ywah okay .. I will try with the excel attached. Thanks!