DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle 11g OLEDB taking hours to connect

HenriqueDFeb 2 2017 — edited Feb 3 2017

On my workplace we had computers with 32 bits MS-Excel and a dozen of spreadsheets connecting to Oracle 32 bits database using MSDAORA connector. Recently we updated some machines and new OS came as 64 bits. So we decided to install Oracle 11g client on all machines (x86 and x64) and updated all connect strings to OraOLEDB.Oracle.1 connector.

All shared spreadsheets are working on both x86 and x64 machines due to new Oracle connector compatibility. That is fine.

The problem is some spreadsheets are taking hours to connect (not to load, but to connect), specially one that has pivot in SQL string.

Is there any special reason for the slow down of connector? If yes, how to handle this?

Thanks,

Henrique

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2017

Added on Feb 2 2017

#oracle-provider-for-ole-db, #windows-and-net

1 comment

899 views