topic Re: Force 32 in QlikView

Force 32

NavinReddy — Tue, 24 Dec 2013 12:07:11 GMT

Hi All,

Today interview call some one as asked what is the purpose of force32

Could some one explain me

Thanks in Advance

Niranjan

Re: Force 32

Tue, 24 Dec 2013 12:11:59 GMT

if u used the 32 bit driver (ODBC or Jdbc) to fetch the data from database then we need to check force 32 check box in edit script dialog box.

Regards,

Kabilan K.

Re: Force 32

NavinReddy — Tue, 24 Dec 2013 12:16:23 GMT

Hi Kabilan,

What is the purpose of ODBC and OLEDB ,

When it prefer odbc and oledb

Thanks in Advance

Niranjan

Re: Force 32

Gysbert_Wassenaar — Tue, 24 Dec 2013 12:20:19 GMT

You need Force 32 if you need to use a 32-bit odbc driver when you're using the 64-bit version of Qlikview.

Re: Force 32

NavinReddy — Tue, 24 Dec 2013 12:23:28 GMT

Hi Gysbert Thanks for your replay

What is the purpose of ODBC and OLEDB ,

When it prefer odbc and oledb

Regards

Niranjan

Re: Force 32

Gysbert_Wassenaar — Tue, 24 Dec 2013 12:26:57 GMT

ODBC and OLEDB are two types of drivers. For some data sources there is no OLEDB driver available, but there is an ODBC driver. In that case you have no choice and need to use the ODBC driver. If both types of driver are available for a data source then using the OLEDB driver is easier. You can find more information if you search the internet. There are a lot of articles about OLEDB versus ODBC.

Re: Force 32

NavinReddy — Tue, 24 Dec 2013 12:54:10 GMT

Hi Gysbert ,

i have Sql server Data source can i use ODBC Connection String (Instead of OLEDB)

Thanks in Advance

Niranjan

Re: Force 32

Gysbert_Wassenaar — Tue, 24 Dec 2013 13:02:36 GMT

Yes, you can if

1. The odbc driver for SQL Server is installed on your system and

2. an ODBC datasource was created with the ODBC Data Source Administrator tool for the database you want to connect to.

Re: Force 32

NavinReddy — Tue, 24 Dec 2013 13:06:29 GMT

Hi Gysbert ,

Thank you so much

Thanks in Advance

Niranjan