Databases Reference
In-Depth Information
The
Force 32 Bit
checkmark is used to specify that
QlikView should look for 32-bit drivers, instead of
looking for 64-bit drivers, installed on the computer.
It is relevant for both ODBC and OLE DB drivers.
If you have installed the 64-bit edition of QlikView,
please mark this option before clicking the
Connect…
button so QlikView uses the correct connection engine.
Remember, we are using the 32-bit connection only
because we don't have a 64-bit driver available to query
our database. In all cases in which the 64-bit driver is
available, it is advisable to use that instead, since using
32-bit drivers might significantly reduces performance
over the 64-bit equivalent.
The
Data Link Properties
window, which is composed of several tabs, will appear.
The first tab (
Provider
) shows a list of all the available OLE DB drivers. Here, we will
select
Microsoft Jet 4.0 OLE DB Provider
. Once selected, click on
Next >>
to move to
the
Connection
tab, in which we will specify the database file we want to connect to.