Forum Stats

  • 3,783,382 Users
  • 2,254,767 Discussions
  • 7,880,376 Comments

Discussions

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

Evie-Oracle
Evie-Oracle Member Posts: 69 Employee
edited Jan 29, 2016 10:52AM in ODBC

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!

Answers

  • EdStevens
    EdStevens Member Posts: 28,616 Gold Crown
    edited Jan 29, 2016 9:52AM

    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
    BPeaslandDBA Member Posts: 4,615 Blue Diamond
    edited Jan 29, 2016 10:52AM

    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

This discussion has been closed.