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