0 Replies Latest reply: Sep 2, 2011 7:10 AM by 885918 RSS

    Pivot Sheet is not getting Refreshed in Windows 2008 R2, 64 Bit OS.

    885918
      Hi,

      I am facing some problems with Excel Pivot Sheet while connecting to Oracle DB.

      We do have some VB program did in excel to take connections details while calling the Excel from Oracle Run time. The VB code is working fine in 32 bit machine, but not in 64 Bit.

      I have changed the provider from MSDAORA to OraOLEDB.Oracle.1, after the changes the Code is working fine but the excel data sheet is not getting refreshed, But the data is exist in the table when i checked. the is the code we are using

      OLEDB;Provider=OraOLEDB.Oracle.1;Password=test;User ID=test;Data Source=ji"
      .CommandType = xlCmdSql

      Is there any way to solve this issue.