Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is the use force 32 bit in qlik view?

what is the use force 32 bit in qlik view?

is their any force 64 bit available in qlik view?

7 Replies
ThornOfCrowns
Specialist II
Specialist II

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.

er_mohit
Master II
Master II

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

engishfaque
Specialist III
Specialist III

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

saimahasan
Partner
Partner

For a better understanding on Force 32 bit you can refer this link. very useful

The Great ODBC Confusion

miguelbraga
Specialist III
Specialist III

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

miguelbraga
Specialist III
Specialist III

You can also see the explantion here:

https://community.qlikview.com/thread/102721

Regards,

MB

Ronnie_Taborn
Support
Support

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.


Edit Script Dialog ‒ QlikView