Force connection to 32 bits in macro vbscript?

[#1]

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

[marcus_sommer]

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