topic Re: Force connection to 32 bits in macro vbscript? in QlikView

Force connection to 32 bits in macro vbscript?

Fri, 05 Feb 2016 14:03:02 GMT

Hello,

I need to export data from Qv to Oracle database via vbscript macro.

This macro works fine in local and doesn't in the server.

I need to force the connection to 32 bits instead of 64 bits in the macro.

Here is the script that allow the connection to Oracle:

set fso=CreateObject("Scripting.FileSystemObject")

Set cn = CreateObject("ADODB.Connection")

set cd = CreateObject("ADODB.Command")

Set rs = CreateObject("ADODB.Recordset")

cn.Provider = "MSDAORA.1"

cn.Properties("Data Source").Value = "DWVAL"

cn.Properties("User Id").Value = "DWH_BO"

cn.Properties("Password").Value = "DWH_BO"

cn.Open

cd.ActiveConnection = cn

Thanks a lot for your help.

Regards,

Myriam

Re: Force connection to 32 bits in macro vbscript?

marcus_sommer — Sat, 06 Feb 2016 12:00:12 GMT

I'm not sure if your issue is really related to a 32-bit connection and for vbs-topics are other sites probably more suitable as qlik community, maybe this one: http://stackoverflow.com/questions/25733257/how-to-connect-to-the-oracle-db-using-vbscript.

I think your issue will be caused from feature- respectively security-restriction. For example a server-task didn't execute any macros. Also within the access point by using an AJAX client won't such macros executed and by using such an application within the desktop-client or per IE plugin you need to enable the macro-execution and to write in databases within the user-properties and similar within the qmc.

- Marcus