Skip to Main Content

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!

How to troubleshoot Out of Memory - MSQuery connect to Oracle through ODBC

Evie-OracleJan 29 2016 — edited Jan 29 2016

Hi

I am trying to connect from Excel to Oracle database for running query (and populating table columns) using ODBC.

I installed winnt_12102_client32 to my laptop and configured the ODBC driver with the Data Sources 32 bit utility.

Verified I can successfully connect to the database both from sqlplus and from the Data Sources utility, but when trying to open the data source with MSQuery from Excel I get error Out of Memory and Cannot open this file.

Any idea what I may have done wrong or how to find out more of what is generating this error?

thanks in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2016
Added on Jan 29 2016
2 comments
1,577 views