Updating Oracle Connection Table Closes Workbook

[kitjosh1050]

Hello All,

I am using an Oracle connection which was working for some time. But now, doing anything with it closes the Workbook. It just closes there is no warning or message or anything.

I am using PowerPivot SP2 Excel 2010 32bit (on Windows 7 64bit).

The provider is OraOLEDB.Oracle. The database is Oracle 10g.

Thank you
Josh

 

[kitjosh1050]

One other point. It will work if I restart my computer. But eventually it doesn't work for no apparent cause.

Note that I am using the 32 bit driver because my Excel is sitll 32 bit, even though windows is 64bit. Do you think this could be a cause?