topic Re: Connect to OLEDB/ODBC sample data - Connection Details in QlikView

Connect to OLEDB/ODBC sample data - Connection Details

pradeep92 — Wed, 25 Nov 2020 16:16:04 GMT

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

ramasaisaksoft — Wed, 11 Oct 2017 14:18:16 GMT

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)

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

pradeep92 — Wed, 11 Oct 2017 15:12:57 GMT

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

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

krishnacbe — Wed, 11 Oct 2017 15:17:38 GMT

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

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

ramasaisaksoft — Thu, 12 Oct 2017 05:16:19 GMT

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

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

pradeep92 — Thu, 12 Oct 2017 13:50:40 GMT

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