Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mwallman
Contributor

What are the exact steps I need to go through to make an ODBC connection from scratch?

Hi all,

Can anyone please outline what are the exact steps I need to create an ODBC connection in QlikView?

I am new to making ODBC connections so not sure exactly what I need to setup before and then in QlikView!

Gracias!

2 Replies
p_verkooijen
Valued Contributor

Re: What are the exact steps I need to go through to make an ODBC connection from scratch?

Take a look at

Loading Data from An ODBC Source

Be sure to check if a ODBC dns has allready been made, also check the 32bit check

MVP
MVP

Re: What are the exact steps I need to go through to make an ODBC connection from scratch?

ODBC and OLEDB are 2 interfaces to get data from database

for ODBC

1) choose a source database

2) check your pc has the client for that database (if your database is Oracle you need the Oracle client and the ODBC driver for Oracle database, if your database is Sql Server you need etc.....); 

3) install the client and the driver for that source database (if missing at point 2)

4) configure che DSN (data source name) using the ODBC administrator

you can find some help here for 4)

The Great ODBC Confusion

Community Browser