Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any step in the ODBC Connection before Creating the System DSN like some kind of registry (I am not sure about this). But my question is in real time, do we have any step which is prior to System DSN setup in an ODBC connection ?
Install the oracle and then create DSN.
Right from Reference Manual: Page 33 and 34 /Read this very informative.
6.1 OLE DB
QlikView supports the OLE DB interface for connection to external data sources. A great number of external
databases can be accessed via the Microsoft OLE DB Provider for ODBC Drivers.
6.2 When Is the ODBC Interface Needed?
To access a general database, it is necessary to have the ODBC (Open DataBase Connectivity) interface
installed. The alternative is to export data from the database into a file that is readable to QlikView.
Normally some ODBC drivers are installed with the operating system. Additional drivers can be bought from
software retailers, found on the Internet or delivered from the DBMS manufacturer. Some drivers are redistributed
freely.
The ODBC interface described here is the interface on the client computer. If the plan is to use ODBC to
access a multi-user relational database on a network server, additional DBMS software that allows a client to
access the database on the server might be needed. Contact the DBMS supplier for more information on the
software needed.
QlikView works with both 32-bit and 64-bit ODBC drivers. It is however very important to use the corresponding
versions of the ODBC drivers and the program version. The 32-bit version of QlikView will only
work with the 32-bit ODBC drivers. However, the 64-bit version will work with both 32-bit and 64-bit
ODBC drivers.
Is the Correct ODBC Driver Installed?
On a 64-bit platform it is possible to use both 32-bit and 64-bit applications. It is also possible to run both
32-bit and 64-bit ODBC drivers.
When using the 64-bit versions of ODBC and QlikView, the ODBC Data Source Administrator is found in
the Control Panel, Administrative Tools.
When using the 32-bit versions of ODBC and QlikView, you must start the 32-bit administrator via the
executable file, odbcad32.exe, that is located in the SysWOW64 folder, usually c:\windows\SysWOW64.
According to Microsoft, in the 64-bit versions of the operating systems, the system32 folder, usually c:\windows\
system32, contains only 64-bit files. If there is also a 32-bit version of the file, it resides in the syswow64
folder. See http://technet.microsoft.com for more information.
On a 32-bit operating system the configuration is very straightforward since all files and drivers are 32-bit.
There should be an ODBC Data Source Administrator installed on the system. (For 32-bit ODBC on a 64-
bit operating system start odbcad32.exe).
Go to the ODBC Drivers tab to find out what drivers are installed.
Hi Karthick,
if you want to create DSN,Frst you need to have Admin privileges for the system.
particular Database client (Oracle client, Sql server client...etc) version need to install in your machine.
Start->Control panel->Administrative tools->Data sources(ODBC)->System DSN->Add->select your data source
and create the odbc connection.
for more information below link will help to you.