topic Re: Alternate between CONNECT32 and CONNECT64 in QlikView

Alternate between CONNECT32 and CONNECT64

Wed, 17 Jun 2015 17:48:36 GMT

Hi,

In my environment we are 32 bits on Desktop and 64 bits no Server. Because of that, we need to change the connection strings from something like:

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=myuser;Data Source=animus;Extended Properties=""] (XPassword is XXXXXXX);

OLEDB CONNECT64 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=myuser;Data Source=animus;Extended Properties=""] (XPassword is XXXXXXX);

every time we need to deploy the application in qlikview server, and do the opposite when we need to do some maintenance on it in the desktop.

I'm wondering if there is any feature (eg, a conditional) in qlikview scripting than I can use here to avoid changing the connection string by hand. If so, how can I do that?

Thanks in advance,

Matheus

Re: Alternate between CONNECT32 and CONNECT64

Miguel_Angel_Baeyens — Wed, 17 Jun 2015 19:19:48 GMT

‌Hi Matheus,

Use a varible in the script with the full sente ce or keyword and include it in the script:

$(Include=arch.txt);

OLEDB '$(vArch)' TO [...];

where arch.txt is a file with a single line:

SET vArch = 'CONNECT32';

and likewise in the server with the 64 bit command.

Miguel

Re: Alternate between CONNECT32 and CONNECT64

MarcoWedel — Wed, 17 Jun 2015 19:36:15 GMT

‌connect instead of connect32/64

Re: Alternate between CONNECT32 and CONNECT64

Thu, 18 Jun 2015 12:13:43 GMT

That would be great, but I'm getting an "unregistered class" error when I use CONNECT instead of CONNECT32 on desktop:

ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Classe não registrada

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=XXXX;Data Source=XXXX;Extended Properties=""] (XPassword is XXXXX)

Re: Alternate between CONNECT32 and CONNECT64

Thu, 18 Jun 2015 12:21:56 GMT

Thanks, Miguel! I just had to take off the quotes, the following worked like a charm:

$(Include=arch.txt)

OLEDB $(vArch) TO [...];