Skip to Main Content
Forums

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

EdStevens

I do not know the immediate cause of your error, but I do know that Excel makes a lousy data entry tool for a database.  It's just another case of your only tool being a hammer, so every problem looks like a nail.

BPeaslandDBA

Likely, the out of memory condition is not on the Oracle side nor the ODBC driver. Its is most likely coming from Excel and possibly because your query is returning a very large amount of data. Have you tried in an Excel forum?

Cheers,
Brian

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 26 2016
Added on Jan 29 2016
#odbc, #windows-and-net
2 comments
1,581 views