Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is the use force 32 bit in qlik view?
is their any force 64 bit available in qlik view?
Force 32 is there to ensure your connections will work in all cases. There's no Force 64 as this would not ensure that your connection will work.
Hi
See below
Windows QlikView Connectstatement Result
64-bit 64-bit connect uses a64-bitODBC
64-bit 64-bit connect32 uses a32-bitODBC
64-bit 64-bit connect64 uses a64-bitODBC
64-bit 32-bit connect uses a32-bitODBC
64-bit 32-bit connect32 uses a32-bitODBC
64-bit 32-bit Connect64 uses a64-bitODBC
32-bit 32-bit connect uses a32-bitODBC
32-bit 32-bit connect32 uses a32-bitODBC
32-bit 32-bit connect64 causes scripterror
Connect32 This statement has the same application as the connect statement, but forces a 64-bit system to use a 32-bit ODBC/OLEDB provider. Not applicable for custom connect.
Connect64 This statement has the same application as the connect statement, but forces use of a 64-bit provider. Not applicable for custom connect.
For more read qlikview reference manual
Dear Subbu,
Force 32 Bit
Force 32 Bit Normally, QlikView 64-bit uses 64-bit providers. In case a data source with a 32-bit driver is to be used, check this option to force the ODBC/OLEDB connect statement to a 32-bit provider.
Kind regards,
Ishfaque Ahmed
For a better understanding on Force 32 bit you can refer this link. very useful
The answer of this question is on this post:
"If you are using 64 Bit Qlikview and you wants to use 32 Bit DB connection (ODBC/OLEDB) then you have to select Force 32 Bit option."
https://community.qlikview.com/thread/76179
Regards,
MB
Normally, QlikView uses 64-bit providers. In case a data source with a 32-bit driver is to be used, check this option to force the ODBC/OLEDB connect statement to a 32-bit provider.