Discussion Board for collaboration on QlikView Scripting.
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!
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
ODBC and OLEDB are 2 interfaces to get data from database
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