1 Reply Latest reply: Feb 6, 2016 7:00 AM by Marcus Sommer RSS

    Force connection to 32 bits in macro vbscript?

    Myriam QUATABOU

      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